RSA Admin

Excluding blank username in sql statement for report

Discussion created by RSA Admin Employee on Feb 21, 2012
Hey all, We're wanting to exclude blank usernames in logon/logoff reports but I don't know the correct syntax to use. We are currently using a combination of sql statements and watchlists to get some user names excluded. This is what we were attempting to use with little success: AND UserName NOT IN (' ') Any suggestions would be great. If I need to use a "Where UserName et..." please let me know. Thanks

Outcomes