Video Screencast Help

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

Created: 17 Dec 2008 • Updated: 17 Dec 2008
Sidd's picture
+11 11 Votes
Login to vote

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

License: AJSL
By clicking the download link below, you agree to the terms and conditions in the Altiris Juice Software License
Support: User-contributed tools on the Juice are not supported by Altiris Technical Support. If you have questions about a tool, please communicate directly with the author by visiting their profile page and clicking the 'contact' tab.