Server hardware info

[Ismail]

Hi,

I added a few fields on the available report called "Server: All Servers"

Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique,
  Web40OSName.OSname, Web40OSName.Compimage As icon,
  tblComputerSystemProduct.Vendor, tblComputersystem.Model As [Model Number],
  tblOperatingsystem.TotalVisibleMemorySize As RAM
From tblComputersystem Inner Join
  tblcomputers On tblComputersystem.Computername = tblcomputers.Computername
  Inner Join
  web40ActiveComputers On tblcomputers.Computername =
    web40ActiveComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = tblcomputers.Computername Inner Join
  tblOperatingsystem On tblcomputers.Computername =
    tblOperatingsystem.Computername Inner Join
  tblComputerSystemProduct On tblcomputers.Computername =
    tblComputerSystemProduct.Computername
Where tblComputersystem.Domainrole > 1
Order By tblcomputers.Computer

Right now it shows:

Computer name, Domain, OS, vendor, server model number and ram.

When I add tblproccessor to show Proccessor name I get duplicate server names entries.

Select Top 1000000 tblcomputers.Computername, tblcomputers.ComputerUnique,
  Web40OSName.OSname, Web40OSName.Compimage As icon,
  tblComputerSystemProduct.Vendor, tblComputersystem.Model As [Model Number],
  tblOperatingsystem.TotalVisibleMemorySize As RAM, tblPROCESSOR.Name
From tblComputersystem Inner Join
  tblcomputers On tblComputersystem.Computername = tblcomputers.Computername
  Inner Join
  web40ActiveComputers On tblcomputers.Computername =
    web40ActiveComputers.Computername Inner Join
  Web40OSName On Web40OSName.Computername = tblcomputers.Computername Inner Join
  tblOperatingsystem On tblcomputers.Computername =
    tblOperatingsystem.Computername Inner Join
  tblComputerSystemProduct On tblcomputers.Computername =
    tblComputerSystemProduct.Computername Inner Join
  tblPROCESSOR On tblcomputers.Computername = tblPROCESSOR.Computername
Where tblComputersystem.Domainrole > 1
Order By tblcomputers.Computer

I'm looking to remove duplicate names while showing CPU Name. I would like to show number of processors, number of cores per processor and Disk Capacity available plus disk capacity Used on each server.


Thanks for your help in advance!

[Ismail]

Perfect! Thanks.

[Hemoco]

Please try the report below.

Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, Web40OSName.OSname, Web40OSName.Compimage As
icon, tblComputerSystemProduct.Vendor, tblComputersystem.Model As
[Model Number], web40CorrectMemory.Memory, tblPROCESSOR.Name,
tblPROCESSOR.NumberOfLogicalProcessors, tblPROCESSOR.NumberOfCores,
tblDiskdrives.Caption, Cast(Cast(tblDiskdrives.Freespace As bigint) / 1024 /
1024 As numeric) As [Disk Free], Cast(Cast(tblDiskdrives.Size As bigint) /
1024 / 1024 As numeric) - Cast(Cast(tblDiskdrives.Freespace As bigint) /
1024 / 1024 As numeric) As [Disk Used]
From tblComputersystem Inner Join
tblComputers On tblComputersystem.Computername = tblComputers.Computername
Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblPROCESSOR On tblComputers.Computername = tblPROCESSOR.Computername
Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername
Where tblComputersystem.Domainrole > 1 And Cast(Cast(tblDiskdrives.Size As
bigint) / 1024 / 1024 As numeric) <> 0
Order By tblComputers.ComputerUnique, tblDiskdrives.Caption