→ 🚀What's New? Join Us for the Fall Product Launch! Register Now !
‎05-25-2020 10:30 PM
Solved! Go to Solution.
‎06-04-2020 11:42 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname,
tsysOS.OSname
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblUsersInGroup.Groupname = 'administrators' And
tsysOS.OSname Like '%Win 10%'
Order By tblAssets.AssetName
‎06-04-2020 11:42 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname,
tsysOS.OSname
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Where tblUsersInGroup.Groupname = 'administrators' And
tsysOS.OSname Like '%Win 10%'
Order By tblAssets.AssetName
‎06-09-2020 09:35 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now