Problem creating a custom report with the "Custom1" field

[philippe_lenard]

Hello,

I am simply trying to get a list of all my computers (computer, domain) with the "Custom1" column shown in the custom fields window

Here is mty script:
Select Top 1000000 tblComputers.ComputerUnique, tblComputers.Domain,
tblComputers.Computername, tblCompCustom.Custom1 As [Libellé UF]
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername


The result of this script is not the one I was expecting, I can only see in this result computers where the "Custom1" filed has been filled in. How can I get this list with all my computers, with even the one that do not have any info entered into this filed ?

Thanks & Regards,
Philippe

[philippe_lenard]

Fantastic, thanks so much for your prompt feedback.

[Hemoco]

philippe.lenard wrote:
How can I get this list with all my computers, with even the one that do not have any info entered into this filed ?

You must right-click on the link between tblComputers and tblCompCustom and choose "Select all rows from tblComputers".


You then get the report shown below.

Select Top 1000000 tblComputers.ComputerUnique, tblComputers.Domain,
tblComputers.Computername, tblCompCustom.Custom1 As [Libellé UF]
From tblComputers Inner Join
tblComputersystem On tblComputers.Computername =
tblComputersystem.Computername Left Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername