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.
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