Asset Location report

[danielm]

Hi, how could i make a report to show a list of computers and what Asset location they have.
Basically I would like to start assigning computers to their MAP locations and just see a list of ones easily that did not have any location assigned, or have whatever the default one is.



if i start using the IP address report as a start, what tables should be added?
---
Select Top 1000000 tblAssets.IPAddress As IP,
tsysIPLocations.IPLocation,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssets.Domain,
tsysOS.OSname,
tsysOS.Image As icon
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tsysIPLocations On tblAssets.IPNumeric >=
tsysIPLocations.StartIP And tblAssets.IPNumeric <= tsysIPLocations.EndIP
Where tblAssets.IPAddress <> '' And tblAssetCustom.State = 1
Order By tblAssets.IPNumeric
---

[danielm · Accepted solution]

actually I just noticed if you click the UNDEFINED location it has a web report
"Assets without a location"
which is basically what i want. 🙂