Filtering on NULL
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.