Video Screencast Help
Symantec to Separate Into Two Focused, Industry-Leading Technology Companies. Learn more.

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