→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Ilyha
Engaged Sweeper II
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
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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

View solution in original post

1 REPLY 1
Hemoco
Lansweeper Alumni
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