[UPDATE]
This took me over 8hs to figure out ... the filters are case sensitive ...
ISEMPTY NOT IsEmpty
I have a CSV with the fields below I am trying to reproduce but none of the filters seem to work right and cmdb_ci is over 1million records so I can't just dump the entire thing. I am looking for IP to ownership info.
Example
service-now.com/api/now/table/cmdb_ci?sysparm_display_value=all&sysparm_limit=100&sysparm_query=support_groupIsEmpty
service-now.com/api/now/table/cmdb_ci_ip_address?sysparm_display_value=all&sysparm_limit=100&sysparm_query=support_groupIsEmpty
service-now.com/api/now/table/cmdb_rel_ci?sysparm_display_value=all&sysparm_limit=100&sysparm_query=support_groupIsEmpty
Fields I got from SNOW team in a CSV file:
service_id
service_id.name
service_id.busines_criticality
service_id.owned_by
service_id.used_for
service_id. _group
ci_id
ci_id.name
ci_id.fqdn
ci_id.sys_class_name
ci_id.ip_address
ci_id.location
ci_id.dns_domain
ci_id.sys_domain
