‎09-05-2015 04:34 PM
Solved! Go to Solution.
‎09-08-2015 10:34 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.Image As icon,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssetCustom.AssetID Not In (Select
tblUsersInGroup.AssetID From tblUsersInGroup
Where tblUsersInGroup.Username Like 'domain admins' And
tblUsersInGroup.Admingroup = 1) And tblAssets.Assettype = -1
Order By tblAssets.AssetName
‎09-08-2015 02:20 PM
‎09-08-2015 10:34 AM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tsysOS.Image As icon,
tblAssets.Lastseen,
tblAssets.Lasttried
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Where tblAssetCustom.State = 1 And tblAssetCustom.AssetID Not In (Select
tblUsersInGroup.AssetID From tblUsersInGroup
Where tblUsersInGroup.Username Like 'domain admins' And
tblUsersInGroup.Admingroup = 1) And tblAssets.Assettype = -1
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now