‎04-29-2013 03:48 PM
‎05-17-2013 05:13 PM
Select Top 1000000 tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Lastseen
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Order By tblAssets.Lastseen Desc
Select Top 10 tblAssets.Username,
tblAssets.Userdomain,
Coalesce(tblADusers.Displayname, tblAssets.Username) As Displayname,
tblAssets.Lastseen,
tblAssets.AssetID,
tblAssets.AssetName,
Coalesce(tsysOS.Image, 'notscanned.png') As compimage
From tblAssets
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tblADusers On tblAssets.Userdomain = tblADusers.Userdomain And
tblAssets.Username = tblADusers.Username
Where Not (tblAssets.Username Is Null) And tblAssets.Username <> ''
Order By tblAssets.Lastseen Desc
‎04-29-2013 04:48 PM
‎04-29-2013 04:45 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now