RSA Admin

Filtering on NULL

Discussion created by RSA Admin Employee on Jul 15, 2010
Latest reply on Jul 27, 2010 by RSA Admin

I have report that has numerous blank lines under "Name" and I would like to filter those out of my report.  Here is the filter I am using:

 

DeviceAddress = '192.168.100.110' AND EventUser NOT LIKE '%SYSTEM' AND EventUser NOT LIKE '%rsaenvision' AND EventUser  NOT LIKE '%rtsaz_importer' AND Name NOT LIKE IS NULL

 

The report runs fine if I leave out the AND Name NOT LIKE IS NULL, but if I leave it in, my report comes up blank.  I have tried several versions NAME and IS NULL, some work (but create a blank report) or SQl does not like the statement.  I have also tried ' '

 

What do I need to add in order to filter out a line NAME is blank.

 

Thanks,

Eric

Outcomes