locked
Inventário de hardware acontece parcialmente RRS feed

  • Pergunta

  • Caros colegas, estou com problemas na obtenção do relatorio de inventario de hardware no meu ambiente.

    Tanto quanto via SMS ou via SQL somente consigo obter informações sobre 2200 desktops. Sendo que "um dia" esse relatório já trouxe a totalidade de máquinas (aprox. 8000 desktops).

    Segue abaixo a SELECT executada via QUERY ANALYZER e também os comando executados via QUERIES dentro da console SMS.

    Peço ajuda de algum EXPERT para solucionar esse enigma. Obrigado e abraços Big Smile

    ============================================

    via QUERY ANALYZER
    -----------------------------------

    select
    System_DATA.Name0,
    Computer_System_DATA.Manufacturer00,
    Computer_System_DATA.Model0,
    Computer_System_DATA.NumberofProcessors00,
    Processor_DATA.Name0,
    Processor_DATA.MaxClockSpeed0,
    Pc_Memory_DATA.TotalPhysicalMemory0,
    PC_BIOS_DATA.SerialNumber00,
    CD_ROM_DATA.DeviceID0,
    Disk_DATA.PNPDeviceID00,
    Disk_DATA.Size0
    from
    System_DATA,
    Computer_System_DATA,
    Processor_DATA,
    Pc_Memory_DATA,
    PC_BIOS_DATA,
    CD_ROM_DATA,
    Disk_DATA
    where
    System_DATA.MachineID=Computer_System_DATA.MachineID and
    System_DATA.MachineID=Processor_DATA.MachineID and
    System_DATA.MachineID=PC_Memory_DATA.MachineID and
    System_DATA.MachineID=PC_BIOS_DATA.MachineID and
    System_DATA.MachineID=CD_ROM_DATA.MachineID and
    System_DATA.MachineID=Disk_DATA.MachineID

    ====================================================

    via QUERIES pela console do SMS
    ----------------------------------------------------

    select
    distinct SMS_G_System_CDROM.Description,
    SMS_G_System_CDROM.Drive,
    SMS_G_System_CDROM.Manufacturer,
    SMS_G_System_COMPUTER_SYSTEM.Description,
    SMS_G_System_COMPUTER_SYSTEM.Manufacturer,
    SMS_G_System_COMPUTER_SYSTEM.Model,
    SMS_G_System_COMPUTER_SYSTEM.Name,
    SMS_G_System_COMPUTER_SYSTEM.NumberOfProcessors,
    SMS_G_System_DESKTOP_MONITOR.Description,
    SMS_G_System_DESKTOP_MONITOR.DisplayType,
    SMS_G_System_DESKTOP_MONITOR.MonitorManufacturer,
    SMS_G_System_DESKTOP_MONITOR.Name,
    SMS_G_System_DISK.Description,
    SMS_G_System_PARTITION.Description,
    SMS_G_System_DISK.InterfaceType,
    SMS_G_System_DISK.Manufacturer,
    SMS_G_System_DISK.MediaType,
    SMS_G_System_DISK.Name,
    SMS_G_System_DISK.SystemName,
    SMS_G_System_LOGICAL_DISK.DriveType,
    SMS_G_System_LOGICAL_DISK.FileSystem,
    SMS_G_System_LOGICAL_DISK.Name,
    SMS_G_System_LOGICAL_DISK.Size,
    SMS_G_System_LOGICAL_DISK.SystemName,
    SMS_G_System_X86_PC_MEMORY.Name,
    SMS_G_System_X86_PC_MEMORY.TotalPhysicalMemory,
    SMS_G_System_MOTHERBOARD_DEVICE.Description,
    SMS_G_System_MOTHERBOARD_DEVICE.SystemName,
    SMS_G_System_NETWORK_ADAPTER.AdapterType,
    SMS_G_System_NETWORK_ADAPTER.Manufacturer,
    SMS_G_System_NETWORK_ADAPTER.MaxSpeed,
    SMS_G_System_NETWORK_ADAPTER.Name,
    SMS_G_System_NETWORK_ADAPTER.ProductName,
    SMS_G_System_OPERATING_SYSTEM.Name,
    SMS_G_System_OPERATING_SYSTEM.OSLanguage,
    SMS_G_System_OPERATING_SYSTEM.Version,
    SMS_G_System_PC_BIOS.Manufacturer,
    SMS_G_System_PC_BIOS.SerialNumber,
    SMS_G_System_PC_BIOS.TimeStamp,
    SMS_G_System_PROCESSOR.Manufacturer,
    SMS_G_System_PROCESSOR.MaxClockSpeed,
    SMS_G_System_PROCESSOR.Name,
    SMS_G_System_PROCESSOR.Version,
    SMS_G_System_SOUND_DEVICE.Manufacturer,
    SMS_G_System_SOUND_DEVICE.ProductName,
    SMS_G_System_SYSTEM.Name,
    SMS_G_System_SYSTEM.SMSID,
    SMS_G_System_VIDEO_CONTROLLER.Description,
    SMS_G_System_VIDEO_CONTROLLER.SpecificationVersion,
    SMS_G_System_WORKSTATION_STATUS.LastHardwareScan
    from 
    SMS_R_System
    inner join
    SMS_G_System_CDROM on SMS_G_System_CDROM.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_COMPUTER_SYSTEM on SMS_G_System_COMPUTER_SYSTEM.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_DESKTOP_MONITOR on SMS_G_System_DESKTOP_MONITOR.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_DISK on SMS_G_System_DISK.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_PARTITION on SMS_G_System_PARTITION.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_LOGICAL_DISK on SMS_G_System_LOGICAL_DISK.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_X86_PC_MEMORY on SMS_G_System_X86_PC_MEMORY.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_MOTHERBOARD_DEVICE on SMS_G_System_MOTHERBOARD_DEVICE.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_NETWORK_ADAPTER on SMS_G_System_NETWORK_ADAPTER.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_OPERATING_SYSTEM on SMS_G_System_OPERATING_SYSTEM.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_PC_BIOS on SMS_G_System_PC_BIOS.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_PROCESSOR on SMS_G_System_PROCESSOR.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_SOUND_DEVICE on SMS_G_System_SOUND_DEVICE.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_SYSTEM on SMS_G_System_SYSTEM.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_VIDEO_CONTROLLER on SMS_G_System_VIDEO_CONTROLLER.ResourceID = SMS_R_System.ResourceId
    inner join
    SMS_G_System_WORKSTATION_STATUS on SMS_G_System_WORKSTATION_STATUS.ResourceID = SMS_R_System.ResourceId

    quarta-feira, 14 de janeiro de 2009 15:15

Respostas

  • Bom dia Flavio,

    Qual a versao do seu SQL?

    Não sei se é este o caso, mas já tive problemas com a limitação de linhas no SQL e executei os passos contido no link a seguir:

    SMS 2003 - Report value 1.000 row limit

    Retorne caso não seja isto. Vamos procurar!

    Um abraço,

    Alexandre Perazza - MCP/MCTS - Caso a resposta lhe ajude, não esqueça de validá-la. http://aperazza.spaces.live.com
    quarta-feira, 18 de fevereiro de 2009 13:01