- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 09:18 AM
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.
Solved! Go to Solution.
- Labels:
-
Service Desk
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 09:51 AM
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-29-2024 09:51 AM
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