cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
jhilmo
Engaged Sweeper
We need help with this query. We are looking to display all Win 7 systems, their users, and the users manager.

This is what we put together and we are missing all of the records that don't have a manager assigned. We need help adjusting the query to display all these systems even if the manager field is blank. The current query only display records where the manager field has info.


Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblAssetCustom.Model,
tblAssetCustom.Warrantydate,
tsysOS.OSname,
tblAssets.Lastseen,
tsysOS.Image As icon,
tblAssets.IPAddress,
tblAssets.Username,
tblADusers.Displayname,
tblADObjects.sAMAccountName As [Manager Name]
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADusers On tblAssets.Username = tblADusers.Username
Inner Join tblADObjects On tblADObjects.ADObjectID =
tblADusers.ManagerADObjectId
Where tsysOS.OSname = 'Win 7'
Order By tblAssets.AssetName
0 REPLIES 0