Client Management Suite

Hi,

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

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

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]

FROM
dbo.Inv_AeX_AC_Identification,
dbo.Inv_AeX_AC_TCPIP,
dbo.Inv_SW_BIOS_Element

WHERE
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid

Check this one thread, may be help you to

https://www-secure.symantec.com/connect/forums/sql-report-cms71-add-ip-address-report

other link for your help to view the report

https://www-secure.symantec.com/connect/forums/altiris-hardware-inventory-report-show-memory-type-column

----Edit----

https://www-secure.symantec.com/connect/forums/system-configuratin-report

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.

hello sachin,

have you tried this one?

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

Please find screen short of the same.

Have you tried my above attached?

i will try and revert.

Thanks for providing the query and report location