Client Management Suite

 View Only
  • 1.  system configuratin report

    Posted Feb 19, 2013 02:02 AM

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



  • 2.  RE: system configuratin report
    Best Answer



  • 3.  RE: system configuratin report

    Posted Feb 19, 2013 02:22 AM

    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



  • 4.  RE: system configuratin report

    Posted Mar 19, 2013 01:36 PM

    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


  • 5.  RE: system configuratin report

    Posted Apr 05, 2013 03:31 AM

    hi rohit,

    Any more help require ?