cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
MrBob
Engaged Sweeper III
Is there a technique for searching for blank fields in the List View? By that I mean when you list assets and there are search fields at the top of each column, is there any thing you can enter in the search field to find emtpy data fields?
7 REPLIES 7
WuGe
Champion Sweeper

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

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
hgiritzer
Engaged Sweeper II
+1
EMPTY and NOT EMPTY (meaning NULL or empty string) would be nice additions to [NOT] NULL
helpdesk1
Engaged Sweeper II
Hi Lansweepers!

The problem is that you don't have a massedit function in reports. Therefore, in this case, this tip is rather useless ...
So it would be really helpful if you could at least enter NULL or NOT NULL.

Best Regards
Thomas Hrusovar
Esben_D
Lansweeper Employee
Lansweeper Employee
Unfortunately there is not. You can'y use things like wildcards to filter the results of views in the web console.

Best thing you can do is create a report and add the criteria in it.