Servers Hardware report

[aristokrat]

Hello,

I searched for it but didn't find something like I want.

If it already exists here in forum please just post the link to the right thread.



I am looking for a query to build a report of all servers with hardware information like: HDD size, HDD count, RAM count, RAM size (total), CPU information, RAID information, serial number, No of network adapters and so on..... plus location and "last seen"/"first seen"
The typical asset information....

Could somebody help me please?

Thank you!

Alex from Germany


EDIT:

Ok, found this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputersystem.Manufacturer, tblComputersystem.Model,
tblComputerSystemProduct.IdentifyingNumber, web40ProcessorCapacity.CPU,
web40ProcessorCapacity.Name, web40ProcessorCapacity.MaxClockSpeed,
web40ProcessorCapacity.NrOfProcessors, web40CorrectMemory.Memory,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As varchar) As [Disk Size], Web40OSName.OSname, Web40OSName.SP,
tblComputers.LastknownIP, tblComputers.Username, tblComputers.Userdomain,
tblComputers.Lastseen, tblComputers.Firstseen
From tblComputers Left Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Left Join
web40ProcessorCapacity On web40ProcessorCapacity.Computername =
tblComputers.Computername Left Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Left Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Left Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Where tblDiskdrives.Caption Like '%c%'
Order By tblComputers.ComputerUnique

..but when I want to use it I get error message: "Invalid object name 'tblComputers'." because of the newer version of Lansweeper I think. What is the new name of that table?

[Hemoco · Accepted solution]

Tblcomputers -> Tblassets