Report Display name user Active Directory

[Ilyha]

Hi. Report Form
Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique, tblComputers.Username, tblOperatingsystem.Description, Web40OSName.Compimage As icon From tblComputers Inner Join web40ActiveComputers On tblComputers.Computername = web40ActiveComputers.Computername Inner Join Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join tblOperatingsystem On tblComputers.Computername = tblOperatingsystem.Computername Where tblComputers.Computername In (Select tblSoftware.ComputerName From tblSoftware Where tblSoftware.softwareName Like 'Microsoft office %2003%') Order By dbo.tblComputers.Computer

You need to add user Display name, that would take the name of the name of the reportю
Sorry for bad English

[Hemoco · Accepted solution]

Please try this code

Select Top 1000000 tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Username, tblOperatingsystem.Description, Web40OSName.Compimage
As icon, tblADusers.Displayname
From tblComputers Inner Join
web40ActiveComputers On tblComputers.Computername =
web40ActiveComputers.Computername Inner Join
Web40OSName On Web40OSName.Computername = tblComputers.Computername Inner Join
tblOperatingsystem On tblComputers.Computername =
tblOperatingsystem.Computername Left Join
tblADusers On tblADusers.Username = tblComputers.Username And
tblADusers.Userdomain = tblComputers.Userdomain
Where tblComputers.Computername In (Select tblSoftware.ComputerName
From tblSoftware
Where tblSoftware.softwareName Like 'Microsoft office %2003%')
Order By dbo.tblComputers.Computer