Report for HW by IP

[codyhastings]

Hey guys,

I am looking to create a report that gives me the computer name, domain, IP, Last Scanned, OS, SP, Manufacturer, Model, Number of Physical Procs as well as logical, total RAM and HD space/free

Once I have the base report, I'm going to filter it by IP ranges for each office I have with Like 'X.X.X.%'

I tried attempting this myself by looking at some of the other reports and trying to mirror them but it didn't turn out that great 🙂 I managed to get most of it in there but ran into issues with the way the HD and RAM was displayed (was displaying as full amount instead of 2 GB etc.)

Any help would be appreciated!

Thanks

Cody

[codyhastings]

That's perfect!

Thanks for the quick reply as usual 🙂

[Hemoco · Accepted solution]

Please try the report below.

Select Distinct Top 1000000 tblComputers.Computername,
tblComputers.ComputerUnique, tblComputers.Domain, tblComputers.LastknownIP As
[IP Address], tblComputers.Lastseen, Web40OSName.OSname,
tblOperatingsystem.ServicePackMajorVersion, tblComputerSystemProduct.Vendor As
Manufacturer, tblComputerSystemProduct.Name As Model,
web40ProcessorCapacity.NrOfProcessors, web40ProcessorCapacity.CPU,
web40CorrectMemory.Memory As Memory, tblDiskdrives.Caption,
Cast(Cast(Cast(tblDiskdrives.Size As bigint) / 1024 / 1024 / 1024 As
numeric) As varchar) As [Disk size], Cast(Cast(Cast(tblDiskdrives.Freespace
As bigint) / 1024 / 1024 / 1024 As numeric) As varchar) As [Free Space]
From tblComputers Inner Join
tblDiskdrives On tblComputers.Computername = tblDiskdrives.Computername
Left Outer Join
web40ProcessorCapacity On tblComputers.Computername =
web40ProcessorCapacity.Computername Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblComputerSystemProduct On tblComputers.Computername =
tblComputerSystemProduct.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Inner Join
tblDiskdrives tblDiskdrives1 On tblComputers.Computername =
tblDiskdrives1.Computername
Where (tblDiskdrives.Caption Like '%C%') Or
(tblDiskdrives.Caption Like '%D%')
Order By dbo.tblComputers.Computername