cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
WuGe
Champion Sweeper

I fully agree.
Absolutely annoying not to have that option.

3 REPLIES 3
Mister_Nobody
Honored Sweeper

You can use operator 'having' in query to detect empty values and show this counter for filtering:

 

 

Select Top 1000000 tblADObjects1.domain,
  tblADObjects1.sAMAccountName,
  tblADGroups.Name,
  tblADGroups.Description,
  tblADGroups.LastChanged
From tblADGroups
  Left Join tblADMembership On tblADGroups.adobjectid =
      tblADMembership.parentadobjectid
  Left Join tblADObjects On
      tblADObjects.ADObjectID = tblADMembership.ChildAdObjectID
  Inner Join tblADObjects tblADObjects1 On tblADObjects1.ADObjectID =
      tblADGroups.ADObjectID
Group By tblADGroups.Name,
  tblADGroups.Description,
  tblADGroups.LastChanged,
  tblADObjects1.domain,
  tblADObjects1.sAMAccountName
Having Count(tblADObjects.ADObjectID) = 0

 

 

PeterJG
Champion Sweeper II

how about we enhance the column searches with logic .. IF THIS THAN NOT OR AND etc.. so if column A = WHATEVER AND COLUMN C NOTEQUAL WHATEVER.. 

sometimes it would be easier to just do that then creating whole new SQL Report. 

IainCaldwell
Lansweeper Employee
Lansweeper Employee
Not a perfect solution but if the field you are interested in is available in the sort option then you can sort by that field and you'll get all the blanks at the top

New to Lansweeper?

Try Lansweeper For Free

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

Try Now