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
