→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
pdumbleton
Engaged Sweeper
I have been asked to create a custom report based on the computer model overview which would show the model count by location.

Location is the IP Location, which I have added via LanSweeper Configuration.

Any suggestions.
2 REPLIES 2
pdumbleton
Engaged Sweeper
Thanks that worked great.
Hemoco
Lansweeper Alumni
Please try the report below. Replace "YourLocation" with the location you want to report on.

Select Top 1000000 tblComputersystem.Model As Model,
tblComputersystem.Manufacturer As Manufacturer,
Count(tblComputersystem.Computername) As Total
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
web40AllIPLocations On web40AllIPLocations.Computername =
tblComputers.Computername
Where web40AllIPLocations.IPLocation = 'YourLocation'
Group By tblComputersystem.Model, tblComputersystem.Manufacturer