‎09-05-2016 03:25 AM
Solved! Go to Solution.
‎10-25-2016 01:47 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname,
tblADusers.OU
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Inner Join tblADusers On tblADusers.Username = tblUsersInGroup.Username And
tblADusers.Userdomain = tblUsersInGroup.Domainname
Where tblUsersInGroup.Groupname = 'administrators'
Order By tblAssets.AssetName
‎10-25-2016 01:47 PM
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblUsersInGroup.Username,
tblUsersInGroup.Domainname,
tblUsersInGroup.Groupname,
tblADusers.OU
From tblAssets
Inner Join tblUsersInGroup On tblAssets.AssetID = tblUsersInGroup.AssetID
Inner Join tblADusers On tblADusers.Username = tblUsersInGroup.Username And
tblADusers.Userdomain = tblUsersInGroup.Domainname
Where tblUsersInGroup.Groupname = 'administrators'
Order By tblAssets.AssetName
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now