Search for Blank Fields

[MrBob]

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?

[WuGe]

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

[Mister_Nobody]

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]

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]

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]

+1
EMPTY and NOT EMPTY (meaning NULL or empty string) would be nice additions to [NOT] NULL

[helpdesk1]

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]

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.