Filtering the Configuration Item field to display only display Operational CIs

[dianeramos]

We have started tagging our CIs with the appropriate Operational status and we would like to put a filter in place on the Configuration Item field to only display those that are not "Retired"

I tried going to configure dictionary> reference specification> Operational status IS NOT Retired, but it is still showing up.

(see attached screenshots)

Can anyone please help or provide assistance?

Thanks

[Steven Parker]

I don't know if this will fix it (although it may), but I think your OR conditions could all be AND statements.  Our's looks like this:

So it's NOT DNS Name and it's not VMWare and it's not MS SQL.  

I noticed your classes seem to be filtering out right however they use OR so that may be why they are filtering out, but it's skipping your Retired piece of the condition.

[Tony Chatfield1]

Sometimes filters do seem to have a life of their own…..

Does it work correctly if you just filter on Operational status?
As Steven indicated you may be able to change your current filter,
or perhaps build a filter on the CI table and then utilize the resulting query in an advanced condition.

[Steven Parker]

As Tony mentioned if you still have trouble, you could go to the Configuration Items table, create your filter exactly how you want it, then right click the filter and "Copy Query.  Go back to your Configuration Items dictionary page and change the Reference Qualifier from Simple to Advanced and paste your query in there.  It would look like this:

sys_class_name!=cmdb_ci_dns_name^sys_class_name!=cmdb_ci_vmware_instance^sys_class_name!=cmdb_ci_db_mssql_database^EQ

[Steven Parker]

As Tony mentioned if you still have trouble, you could go to the Configuration Items table, create your filter exactly how you want it, then right click the filter and "Copy Query".  Go back to your Configuration Item dictionary page and change the Reference Qualifier from Simple to Advanced and paste your query in there.  It would look like this:

sys_class_name!=cmdb_ci_dns_name^sys_class_name!=cmdb_ci_vmware_instance^sys_class_name!=cmdb_ci_db_mssql_database^EQ