→ 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: 
Waterscorpion
Engaged Sweeper
I'm trying to generate a report that will display computer information based on Custom Field 10 having data. I thought it would be a fairly simple report, but it seems I must be missing something. I filled two computer's entries with data in this field, and the report captures those fine, but they also appear to be capturing other entries that do not have data in them. It's nowhere close to all of our entries, maybe about 30 of them, but definitely not working the way I'd like. Any advice? Here is the code:

Select Top 1000000 tblComputers.Computer, tblComputers.Username, tblCompCustom.Custom10 As Loaner, tblCompCustom.Custom1 As AssignedTo From tblComputers Inner Join tblCompCustom On tblComputers.Computername = tblCompCustom.Computername Where tblCompCustom.Custom10 Is Not Null

1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
Could you try the report below instead.

Select Top 1000000 tblComputers.Computer, tblComputers.Username,
tblCompCustom.Custom10 As Loaner, tblCompCustom.Custom1 As AssignedTo
From tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.Custom10 <> ''

View solution in original post

2 REPLIES 2
Waterscorpion
Engaged Sweeper
Awesome, it worked. Thanks 🙂
Hemoco
Lansweeper Alumni
Could you try the report below instead.

Select Top 1000000 tblComputers.Computer, tblComputers.Username,
tblCompCustom.Custom10 As Loaner, tblCompCustom.Custom1 As AssignedTo
From tblComputers Inner Join
tblCompCustom On tblComputers.Computername = tblCompCustom.Computername
Where tblCompCustom.Custom10 <> ''