‎12-12-2014 05:00 PM
Select Top 1000000 tblADusers.Department,
tblADusers.Displayname,
tblAssets.AssetName,
tblAssets.AssetID,
tblADusers.Userdomain,
tblADusers.Username
From tblADusers
Inner Join tblAssetUserRelations On tblADusers.Username =
tblAssetUserRelations.Username And tblADusers.Userdomain =
tblAssetUserRelations.Userdomain
Inner Join tblAssets On tblAssets.AssetID = tblAssetUserRelations.AssetID
Where tblADusers.Userdomain Is Not Null And tblADusers.Username Is Not Null And
tblAssetUserRelations.Type = 200
Order By tblADusers.Department,
tblADusers.Displayname
Solved! Go to Solution.
‎01-05-2015 06:02 PM
‎01-05-2015 06:02 PM
‎01-05-2015 05:54 PM
‎01-05-2015 03:11 PM
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now