→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎06-22-2016 08:57 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssetUserRelations.Username,
tblAssetUserRelations.Lastchanged,
tblAssetCustom.Custom1 As Inventarnummer,
tblAssetCustom.Custom2 As Kostenstelle,
tblAssets.Description,
tblAssetCustom.OrderNumber,
tblAssetCustom.Serialnumber,
tblAssetCustom.Location,
tblAssets.Firstseen
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tblAssetUserRelations On tblAssets.AssetID =
tblAssetUserRelations.AssetID
Inner Join tblUsers On tblAssets.AssetID = tblUsers.AssetID
Where tblAssetCustom.State = 1
Order By tblAssetUserRelations.Lastchanged Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now