→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎08-19-2016 08:50 PM
Solved! Go to Solution.
‎08-22-2016 03:42 PM
‎09-02-2016 03:53 PM
‎09-01-2016 01:29 PM
Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.Username,
tblAssets.Userdomain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tblAssets.Lasttried,
tsysOS.OSname,
tblOperatingsystem.Caption As FullOSname,
tblOperatingsystem.Version
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tblOperatingsystem
On tblAssets.AssetID = tblOperatingsystem.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tsysOS.OSname = 'win 10' And tblAssetCustom.State = 1
Order By tblAssets.Domain,
tblAssets.AssetName
‎08-22-2016 03:42 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now