‎03-24-2015 05:31 PM
‎03-30-2015 01:29 PM
‎03-27-2015 08:07 PM
‎03-25-2015 01:22 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
Ceiling(SqRt(Power((tblDesktopMonitor.ScreenWidth /
tblDesktopMonitor.PixelsPerXLogicalInch), 2) +
Power((tblDesktopMonitor.ScreenHeight /
tblDesktopMonitor.PixelsPerYLogicalInch), 2))) As MonitorSize
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblDesktopMonitor On tblDesktopMonitor.AssetID = tblAssets.AssetID
Where tblAssets.AssetID In (Select tblMonitor.AssetID
From tblMonitor) And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now