→ The Lansweeper Customer Excellence Awards 2024 - Submit Your Project Now! Learn More & Enter Here
‎01-18-2016 11:51 PM
Solved! Go to Solution.
‎01-19-2016 12:02 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select Top 1000000 tblUsersInGroup.AssetID
From tblUsersInGroup Inner Join tblAssets On tblAssets.AssetID =
tblUsersInGroup.AssetID
Where tblUsersInGroup.Domainname = tblAssets.AssetName And
tblUsersInGroup.Username = 'saveme' And tblUsersInGroup.Groupname =
'administrators') And tblAssets.Domain = 'lansweeper '
Order By tblAssets.AssetName
‎01-19-2016 05:59 PM
‎01-19-2016 12:02 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
tsysAssetTypes.AssetTypeIcon10 As icon
From tblAssets
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssets.AssetID Not In (Select Top 1000000 tblUsersInGroup.AssetID
From tblUsersInGroup Inner Join tblAssets On tblAssets.AssetID =
tblUsersInGroup.AssetID
Where tblUsersInGroup.Domainname = tblAssets.AssetName And
tblUsersInGroup.Username = 'saveme' And tblUsersInGroup.Groupname =
'administrators') And tblAssets.Domain = 'lansweeper '
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now