cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
lifo
Engaged Sweeper
So I created a custom report with all workstations and servers but I want to add a SQLVersion column but when I do it only displays the results if I have SQL installed. Can I have it display the full results and just leave that column blank if there is no SQL on that asset?
1 ACCEPTED SOLUTION
RCorbeil
Honored Sweeper II
Use a LEFT JOIN against the software instead of the default INNER JOIN.

W3 Schools links:
INNER JOIN
LEFT JOIN


View solution in original post

1 REPLY 1
RCorbeil
Honored Sweeper II
Use a LEFT JOIN against the software instead of the default INNER JOIN.

W3 Schools links:
INNER JOIN
LEFT JOIN


New to Lansweeper?

Try Lansweeper For Free

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

Try Now