Please see what I am attempting below. In the end I'd like to be able to pull the Software by Computer report for all systems and align the user's AD email address to any system (with a user listed).... the intent is to be able to drill the report down as needed for various SWs and have the users name/ email easily available as a means to contact them... At this point the report comes back empty. Remove the user and AD reference and it works.
Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName As software,
tblSoftware.softwareVersion As version,
tblSoftwareUni.SoftwarePublisher As publisher,
tsysOS.Image As icon,
tblAssets.Description,
tblAssets.AssetName,
tblAssets.Assettype,
tblAssets.Username,
tblADusers.email,
tblADusers.Firstname,
tblADusers.Lastname
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblAssetUserRelations On tblAssets.AssetID =
tblAssetUserRelations.AssetID
Inner Join tblADusers On tblADusers.Username = tblAssetUserRelations.Username
And tblADusers.Userdomain = tblAssetUserRelations.Userdomain
Order By tblAssets.AssetName,
software,
version
