PRUEBA AHORA

Computer Processor Information

Hardware Hardware Components

Find Which CPUs Are Used in Your Network

Gather detailed processor information from all computers in your environment in one overview. The report provides detailed processor information such as the model, architecture, clock speed and the number of cores. Get an accurate inventory of exactly what processors are in your environment and prevent wasting time on getting the details by going to individual machines or running Powershell or CMD scripts. Processor information  

Computer Processor Information Query

Select Top 1000000 tblAssets.AssetID,
  tblAssets.Domain,
  tsysOS.OSname,
  tsysOS.Image As icon,
  ProcCapacity.CPU,
  ProcCapacity.Name,
  ProcCapacity.MaxClockSpeed As ClockSpeed,
  ProcCapacity.NrOfProcessors As #CPU
From tblAssets
  Inner Join (Select tblAssets.AssetID,
        Max(tblProcessor.MaxClockSpeed) As MaxClockSpeed,
        Count(tblProcessor.WIN32_PROCESSORid) As NrOfProcessors,
        Max(tblProcessor.MaxClockSpeed) As [total Proc Capacity],
        Max(tblProcessor.Architecture) As Architecture,
        Max(tblProcessor.Caption) As Name,
        Max(Replace(Replace(tblProcessor.Name, '(R)', ''), '(TM)', '')) As CPU
      From tblAssets
        Inner Join tblProcessor On tblAssets.AssetID = tblProcessor.AssetID
      Group By tblAssets.AssetID) ProcCapacity On ProcCapacity.AssetID =
    tblAssets.AssetID
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1
Order By #CPU Desc,
  tblAssets.AssetName

Show

Hide