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

[dianeramos]

Thanks Steven & Tony,

I tried that route as well, built a query from the main cmdb_ci table, plugged it in Advanced reference specification,,, still no luck 😞

[Steven Parker]

You tried AND for every step of the condition right?

[Jim Coyne]

Could there be a Dictionary override for the Change Request table that is setup to override the Reference qualifier?

[Shodi Bakoev]

Hi Diane Ramos,

Like Seven mentioned above you have to go cmdb_ci.list and build your query there. You can achieve any kind of the filter you like but you need to know all the class names in your filter once you build you can copy the query by right click at the end of the filter and paste it in yours.  This is one example : 

Also, I would suggest you use dictionary override for change request table so so it will not impact the other areas. 

Let me know if that helps! Good luck!

Cheers,

SB

[Jim Coyne]

Did you find a solution to your issue?  If yes, please remember to tag the correct answer and any that were helpful.