Asset location Report !Important!

[IT-riha]

Hi there,

I Need a Report for the Asset locations, that i can see wich Asset is on a special location.

THX

[Daniel_B · Accepted solution]

If you refer only to the location field of the asset and not the IP location, then this report will list you all assets with locations. You could add a filter to find assets in a specific location.

Select Top 1000000 tblAssets.AssetID,
  tblAssets.AssetName,
  tsysAssetTypes.AssetTypename,
  tsysAssetTypes.AssetTypeIcon10 As icon,
  tblAssetCustom.Location,
  tblAssets.IPAddress,
  tblAssets.Lastseen,
  tblAssets.Lasttried
From tblAssets
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By tblAssetCustom.Location,
  tblAssets.AssetName