assets with no location.

[danielm]

Is there an easy way to find the "assets with no location" report other than going to an asset with no location and clicking the part where the location would be but is undefined?
to get that report ->
/lansweeper/report.aspx?det=web50nolocation&title=Assets%20without%20a%20location

I could not see the web50nolocation view in the report creator.

[danielm]

great. thanks

[Hemoco · Accepted solution]

Queries used to populate automatically generated pages cannot be found in the Reports tab. They're stored in the tsysDBobjects database table, which you should *not* modify in any way.

Below is web50nolocation's SQL query, pulled directly from tsysDBobjects. You can use it to create a new report under Reports/Create New Report.

SELECT s.AssetName, s.AssetID, tsysAssetTypes.AssetTypeIcon10 AS Icon, s.IPAddress AS [IP Address], tblAssetCustom.Manufacturer, tblAssetCustom.Model,
tblAssetCustom.Location, s.Lastseen
FROM tblAssets AS s INNER JOIN
tblAssetCustom ON tblAssetCustom.AssetID = s.AssetID INNER JOIN
tsysAssetTypes ON s.Assettype = tsysAssetTypes.AssetType INNER JOIN
tblState ON tblAssetCustom.State = tblState.State
WHERE (NOT EXISTS
(SELECT ChildAssetID
FROM tblAssetRelations AS r
WHERE (Type = 14) AND (ChildAssetID = s.AssetID)))
ORDER BY s.AssetName