Inventário de hardware acontece parcialmente

• Pergunta

• 

  

  0

  Entrar para Votar

  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
  
  ============================================
  
  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