cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
philippe_lenard
Engaged Sweeper
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
2 REPLIES 2
philippe_lenard
Engaged Sweeper
Fantastic, thanks so much for your prompt feedback.
Hemoco
Lansweeper Alumni
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

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now