List Collector Reference qualifier

John H1
Tera Guru

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. 

1 ACCEPTED SOLUTION

Brad Bowman
Kilo Patron
Kilo Patron

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

 

View solution in original post

1 REPLY 1

Brad Bowman
Kilo Patron
Kilo Patron

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