Location Maps and Their Assets

Find a Device's Location with Location Maps

List all location maps and the assets that are located on them. Quickly find which location has which device on it by running this report. No longer will you have to spend valuable time looking for switches, servers or other devices when they are in need of repairs, maintenance or just some hardware changes.

Location maps and assets on them

Click to Open - Location Maps and Their Assets Query
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssets.AssetName As Location,
  tblAssets1.AssetID,
  tblAssets1.AssetName,
  tblAssets1.Domain,
  tsysAssetTypes1.AssetTypename As AssetType,
  tblAssets1.Username,
  tblAssets1.Userdomain,
  tblAssets1.IPAddress,
  tsysIPLocations.IPLocation,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  Coalesce(tsysOS.OSname, tblLinuxSystem.OSRelease, tblMacOSInfo.SystemVersion)
  As OS,
  tblAssets.SP,
  tblAssets1.Lastseen,
  tblAssets1.Lasttried
From tblAssets
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblAssetRelations On
    tblAssets.AssetID = tblAssetRelations.ParentAssetID
  Inner Join tsysAssetRelationTypes On tsysAssetRelationTypes.RelationTypeID =
    tblAssetRelations.Type
  Inner Join tblAssets tblAssets1 On
    tblAssets1.AssetID = tblAssetRelations.ChildAssetID
  Inner Join tsysAssetTypes tsysAssetTypes1 On tsysAssetTypes1.AssetType =
    tblAssets1.Assettype
  Inner Join tblAssetCustom On tblAssets1.AssetID = tblAssetCustom.AssetID
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Inner Join tsysIPLocations On tsysIPLocations.LocationID =
    tblAssets1.LocationID
  Left Join tblLinuxSystem On tblAssets1.AssetID = tblLinuxSystem.AssetID
  Left Join tblMacOSInfo On tblAssets1.AssetID = tblMacOSInfo.AssetID
  Left Join tsysOS On tsysOS.OScode = tblAssets1.OScode
Where tsysAssetRelationTypes.ReverseName = 'has location of' And
  tblState.Statename = 'Active'
Order By Location,
  tblAssets1.IPNumeric,
  tblAssets1.Domain,
  tblAssets1.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting