→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
kcovingt
Engaged Sweeper III
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
kcovingt
Engaged Sweeper III
Thanks that works like a champ.
Hemoco
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now