Custom Page or Report

[pdumbleton]

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.

[pdumbleton]

Thanks that worked great.

[Hemoco]

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