Is there not a way to filter a collection by a field that is not null? I want to find all computers where the Scan Status is not empty/blank. But there does not seem to be a way to do that easily. I found a post where someone created a collection where the entered in every possible scan status they knew about, but in most databases, there is a way to filter by whether or not there is anything in that field. For example, in Excel, there is the ISBLANK formula. In SQL, you can do something similar to "WHERE column-name IS NOT NULL". Adding filters for possible known scan statuses means that the filter will have to be reviewed for any changes in the system as updates are applied. Using a NULL variable/formula would mean that it would work regardless of the changes in possible scan statuses.
Please sign in to leave a comment.