Vidéos d'aide de Screencast

SQL Query\Report

Created: 14 Mars 2013 • Updated: 17 Avr. 2013 | 10 comments
Ce problème a été résolu. Voir la solution.


I want the below detail from Altiris. Any report/sql query to find it

Require Detail- User Name, OS, System Type, BIOS Version, IP

Commentaires CommentairesAccéder au dernier commentaire

l'image des Sachin Sawant

kindly check below query,

SELECT dbo.Inv_AeX_AC_Identification.[Name][Host Name]
, dbo.Inv_AeX_AC_Identification.[Os Name]
, dbo.Inv_AeX_AC_Identification.[System Type]
, dbo.Inv_AeX_AC_Identification.[Last Logon User]
, dbo.Inv_AeX_AC_TCPIP.[MAC Address]
, dbo.Inv_AeX_AC_TCPIP.[IP Address]
, dbo.Inv_SW_BIOS_Element.[Version][BIOS Version]


AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid

l'image des Sumit G

Check the step

1 In the Symantec Management Console, on the "Reports" menu, click "All Reports".
2 In the left pane, under "Reports", expand Discovery and Inventory > Inventory > Cross-platform > Operating System.
3 In the left pane, under "Operating System", click the "Computer Summary" report.

Report will be reflect in right hand panel, Choose saveas to save the file in any of the format which you required.


Sumit G.

l'image des rs_cert

hello sachin,

have you tried this one?

l'image des Sachin Sawant

Yes, rs_cert and this query working properly in my office, if you any challenges and query pls revert....

l'image des Sachin Sawant

Please find screen short of the same.

query screen short.jpg
l'image des consoleadmin

Have you tried my above attached?


l'image des rs_cert

Thanks for providing the query and report location