Office version + domain user name query

[amits]

hi everyone - and thanks in advance for the help.

im new to lansweeper reports and got asked to do a report that shows which users have office 2003 still.

now in the default reports I can easily cut down to Microsoft office 2003(under software), but all I get in the result is the computer name.
if I hover the mouse above it I see the computer details, including the user, but I need to see the user in another column.

so - how do I add the user ?
thanks again.

[amits]

it did the trick! thanks a lot , and I can build on it also.
thanks you.

[rgross · Accepted solution]

Try this


Select Top 1000000 tblADusers.Username,
tblADusers.Displayname,
tblAssets.AssetID,
tblAssets.AssetUnique,
tblSoftwareUni.softwareName,
tblSoftware.softwareVersion
From tblAssets
Inner Join tblSoftware On tblAssets.AssetID = tblSoftware.AssetID
Inner Join tblSoftwareUni On tblSoftwareUni.SoftID = tblSoftware.softID
Left Join tblADusers On tblAssets.Username = tblADusers.Username And
tblAssets.Userdomain = tblADusers.Userdomain
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblSoftwareUni.softwareName Like '%Office 2003%' And
tblAssetCustom.State = 1
Order By tblAssets.AssetUnique