Assuming your DB is SQL, its hard to query on null since its by definition nothing. Try pulling in all records on that form and Filtering on a custom field case statement that sets null entries to N/A. Or maybe drop down to the view level and set the nulls to "N/A" there?
1 of 1 people found this helpful
Are you literally using "in Null"? If so, you're probably using operand In List and value Null when you should be using operand Is Null; replace those and you'll be able to prepare reports such as this one which shows how many CIs per class lack AssetID (also known as CI ID+ in class-specific AST:% forms):
`AR System Schema`.`AST:Attributes`
`AST:Attributes`.`AssetID` IS NULL
2 of 2 people found this helpful
In your case, `AST:BaseElement`.`AssetID` (labeled CI ID+ on the form) isn't mapped to CI ID in report; instead, it is mapped to `AST:BaseElement`.`Instance Id` which is local representation of `BMC.CORE:BMC_BaseElement`.`InstanceId` and every record in latter form "must" have this attribute populated (technically, its Entry Mode is set to Optional instead of Required, so it shouldn't have to, but InstanceId is functionally a translation of RequestId to UUID format and is always set in any form it is used on). In other words, SQL statement of your report contains ˙AST:BaseElement`.`Instance Id` IS NULL instead of `AST:BaseElement`.`AssetID` IS NULL; replace those and report will display CIs lacking CI ID+.