Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

system configuratin report

Created: 19 Feb 2013 • Updated: 11 Apr 2013 | 4 comments
This issue has been solved. See solution.

anyone help me to create the report/query to find the system configuration?

Comments 4 CommentsJump to latest comment

Jackie007's picture

Hi,

Which type configuration report do you have want ?

 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 > Hardware >You can select Report type

Check this thread

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

https://www-secure.symantec.com/connect/forums/basic-inventory-report-altiris-7x

Thanks....

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you

Sachin Sawant's picture

try this 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.vHWComputerSystem.[manufacturer][CPU Make]
, dbo.vHWComputerSystem.[Model][CPU Model]
, dbo.vHWComputerSystem.[Total Physical Memory (Bytes)][Memory Size (Bytes)]
, dbo.Inv_AeX_AC_TCPIP.[MAC Address]
, dbo.Inv_AeX_AC_TCPIP.[Device]
, dbo.Inv_AeX_AC_TCPIP.[IP Address]
, dbo.Inv_AeX_AC_TCPIP.[DHCPEnabled]
, dbo.Inv_HW_Baseboard.[Serial Number][Motherboard Serial Number] 
, dbo.Inv_HW_Baseboard.[Part Number][Motherboard Part Number]
, dbo.Inv_HW_Desktop_Monitor.[Monitor Type]
, dbo.Inv_HW_Desktop_Monitor.[Serial Number][Monitor Serial Number]
, dbo.Inv_HW_Keyboard.[Device ID]
, dbo.Inv_HW_Physical_Memory.[Serial Number][Memory Serial Number]
, dbo.Inv_HW_Physical_Memory.[Capacity (Bytes)][Memory Size (Bytes)]
, dbo.Inv_HW_Pointing_Device.[Device ID][Mouse Device ID] 
, dbo.Inv_HW_Printer_Windows.[Port Name][Printer IP]
, dbo.Inv_HW_Printer_Windows.[Device ID][Printer Name]
, dbo.Inv_SW_BIOS_Element.[Manufacturer][BIOS Manufacturer]
, dbo.Inv_SW_BIOS_Element.[Name][BIOS Name]
, dbo.vHWProcessor.[Model][Processor Model]
, dbo.vHWProcessor.[Family][Processor Family]
, dbo.Inv_HW_Processor.[Max Clock Speed (Mega-hertz)][Processor Speed (Mega-hertz)]
FROM 
dbo.Inv_AeX_AC_Identification,
dbo.vHWComputerSystem,
dbo.Inv_AeX_AC_TCPIP,
dbo.Inv_HW_Baseboard, 
dbo.Inv_HW_Desktop_Monitor, 
dbo.Inv_HW_Keyboard,
dbo.Inv_HW_Physical_Memory,
dbo.Inv_HW_Pointing_Device,
dbo.Inv_HW_Printer_Windows,
dbo.Inv_SW_BIOS_Element,
dbo.vHWProcessor,
dbo.Inv_HW_Processor
WHERE 
dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.vHWComputerSystem._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_AeX_AC_TCPIP._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Baseboard._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Desktop_Monitor._ResourceGuid 
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Keyboard._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Physical_Memory._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Pointing_Device._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Printer_Windows._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_SW_BIOS_Element._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.vHWProcessor._ResourceGuid
AND dbo.Inv_AeX_AC_Identification._ResourceGuid=dbo.Inv_HW_Processor._ResourceGuid
Jackie007's picture

hi rohit,

Any more help require ?

Thanks....

Don't forget to mark your thread as 'SOLVED' with the answer that best helped you