The following is the SQL query based reports to fetch details like Computer Name, OS Name, OS Version, Domain, IP Address and MAC Address from Altiris Inventory.
----------- Begin of Code --------- SELECT DISTINCT V1.[Name] AS 'Computer Name', V1.[OS Name], V1.[OS Version], V1.[Domain], V1.[IP Address], V1.[MAC Address] FROM vComputer V1 JOIN Inv_AeX_AC_Identification ID ON V1.GUID = ID._ResourceGUID AND V1.[Domain]=ID.[Domain] Order by V1.[Name] ----------- End of Code ---------
One can exclude OS Name, OS Version, if this information is not needed.
Thanks, Sid