→ 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: 
danielm
Champion Sweeper II
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.
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

2 REPLIES 2
danielm
Champion Sweeper II
great. thanks
Hemoco
Lansweeper Alumni
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