Alternative for 'IS NOT ONE OF' operator

[Anurag Tripathi]

Hi,

I have a set of CIs(90) and there is no way to get them through query, it is a list and we have to just use it as is.

I have to add it to SLA definition in a way that SLA does not attach if the CI is in that list. There is no option for using the operator 'is not one of' else my life would be simple.

Any suggestions?

-Anurag

[Anurag Tripathi]

It needs to go in the SLA start condition, using 90 <IS NOT> is not an option as the condition field is 1000 characters and it is exceeding that.

[Mark Roethof]

Ahh clear!

Creating a new Dynamic Filter maybe an option? Though I don't know how the performance would be. Also the list will then be hardcoded in the Dynamic Filter which might not be what you are after.

If my answer helped you in any way, please then mark it as helpful.

Kind regards,
Mark

---

LinkedIn
Community article list

[Anurag Tripathi]

I did just that, but now the issue i ran into is, i need to exclude those 90 CIs, and the dynamic filter runs as

CI <is (dynamic)><my dynamic filter>

This would work well if i had to return a list of 90 CIs but since i have to exclude, i cannot return all CIs except those 90, it will certainly not work.

If i can achieve it this way, it would be best.

[Dubz]

Could you add a checkbox field to the cmdb_ci table, default it to false and mark each CI you need to exclude as true? Then you can exclude them based on that field.

[Anurag Tripathi]

Hi David,

Im trying to avoid creating any new field on CMDB or the task record in question. But thanks for the suggestion.

Ill put a pin in that and call it plan B.

-Anurag