In reference qualifier I have excluded CIs to not show status retired and decommisioned. But in Configuration item field when searched with CI name it shows the CI with status retired.

[sbeginner]

Hi All,

In reference qualifier I have excluded CIs to not show status retired and decommisioned. But in Configuration item field when searched with CI name it shows the CI with status retired. In field when I apply filter no records come up with status retired and decommisioned. 

Record filter shows no records with both status:

This CI shows up in field when searched even though status is retired:

[Ankur Bawiskar]

Hi,

Can you check possibly because of OR condition the records are being shown

Regards
Ankur

[sbeginner]

Hi @Ankur Bawiskar,

I have narrowed it down to Cis with only this 7 classes are showing up there. When I tried applying filter on cmdb_ci table even there filter doesn't work. Even if I say status != retired it still gives me retired in all these classes.

[Badal Khojare]

Hi @sbeginner ,

Can you once check by going to cmdb_ci table and applying filter for all the status values and then remove it for Active and Pending activation and then start removing one by one. I guess your status values are messed up and doing this will let you know what status value is giving you value for retired field.

[sbeginner]

Hi, i did this and it seems inventory status is giving me value of retired so thats why it is not working. But when i added status!= inventory as well it is not working and ci is still visible. can you help me in excluding that status.

[Badal Khojare · Accepted solution]

Hi @sbeginner In your first condition builder section just add the class of the ci below other classes with AND condition and then below other status just do another AND condition and say status is not inventory 'or' status is not 'another status'. Dont disturb the below conditions for now. Try putting this in first place as I guess the below conditions after OR might be including that CI.