List Collector Reference qualifier

[John H1]

I have a list collector that is based on the CMDB_CI table.

I have a need to only show CI's that are "In Production" (that's working), but I need to exclude three sys_class_xxx. IP Address, Cluster, and Application.

Any assistance would be appriciated. 

[Brad Bowman · Accepted solution]

You can manually filter a list view to meet your criteria, then right-click on the last breadcrumb and choose Copy query.  Depending on your field and value for 'In Production' it would look something like this:

install_status=1^sys_class_name!=cmdb_ci_ip_address^sys_class_name!=cmdb_ci_cluster^sys_class_name!=cmdb_ci_appl