Search for a missing value?

[PhillyPhoto]

I want to bring up a list of all machines that don't show email addresses. If I run a blank query, it deletes that option since you haven't specified anything. If I enter "email address is not like *" then it still returns everything (machines with AND without email addresses. I'm trying to clean up our inventory and have gotten IDs for all the machines, but not all IDs have emails in active directory.

[mm2270 · Accepted solution]

Since all email addresses should have an "@" symbol in them, have you tried doing:

Email Address | not like | "@"

I don't know of any email address that doesn't have the @ symbol in it so that should pull up any Macs that don't have an email address under the Location section.