→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Nick_VDB
Champion Sweeper III
Added in v.6.0.100

The report below lists all the location maps and any assets that have been added to them.

The report will only list assets that meet all of the following criteria:
  • The asset state is set to "active".
  • The asset is a ‘Location’.


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
0 REPLIES 0