Report of computers not meeting hardware requirements, grouped by IP Location

[kcovingt]

Is it possible to run the Not meeting hardware requirements report on a IP location and not the entire system?

For example I've defined a group called BranchOffice with an IP range of 192.168.1.1-254 and ideally it would be great if I could click on that group and then run the report to show the same information but just for this location.

We have a lot of locations so running the overall report gave us all the information we needed but it's pretty difficult to use right now as it is hard to determine where the pc is located at.

Thanks for the help and the great product.

[kcovingt]

Thanks that works like a champ.

[Hemoco · Accepted solution]

This adds the IP location to the report:

Select Top 1000000 dbo.tblComputers.Computername,
dbo.tblComputers.ComputerUnique, dbo.tblComputers.Domain, Web40OSName.OSname,
dbo.web40ProcessorCapacity.[total Proc Capacity] As Clockspeed,
web40CorrectMemory.Memory, dbo.tblComputersystem.Manufacturer,
dbo.tblComputersystem.Model, dbo.tblComputers.Lastseen, Web40OSName.Compimage
As icon, web40AllIPLocations.IPLocation
From dbo.tblComputers Inner Join
dbo.web40ProcessorCapacity On dbo.tblComputers.Computername =
dbo.web40ProcessorCapacity.Computername Inner Join
dbo.tblComputersystem On dbo.tblComputers.Computername =
dbo.tblComputersystem.Computername Inner Join
dbo.tblOperatingsystem On dbo.tblComputers.Computername =
dbo.tblOperatingsystem.Computername Inner Join
dbo.web40ActiveComputers On dbo.tblComputers.Computername =
dbo.web40ActiveComputers.Computername Inner Join
web40CorrectMemory On web40CorrectMemory.Computername =
dbo.tblComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = dbo.tblComputers.Computername
Inner Join
web40AllIPLocations On web40AllIPLocations.Computername =
dbo.tblComputers.Computername
Where (dbo.web40ProcessorCapacity.[total Proc Capacity] < 1000) Or
(web40CorrectMemory.Memory < 512)
Order By dbo.tblComputers.Computer