SQL Query for Computer IP Address and MAC Address - Inventory Report

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