‎09-30-2014 11:33 PM
‎10-29-2014 11:42 AM
‎10-17-2014 11:01 PM
‎10-01-2014 06:39 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysOS.Image As icon,
Case tblMonitorHist.Action When 1 Then '+' When 2 Then '-' End As Change,
tblMonitorHist.MonitorModel,
tblMonitorHist.SerialNumber,
tblMonitorHist.MonitorManufacturer,
tblMonitorHist.ManufacturedDate,
tblMonitorHist.LastChanged
From tblAssets
Inner Join tblMonitorHist On tblAssets.AssetID = tblMonitorHist.AssetID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName,
tblMonitorHist.LastChanged Desc
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now