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
