Negate Multiple IBM MQ Local Queues in the Entity Selector

[Babar_Qayyum]

Dear All,

How can we negate multiple IBM MQ local queues in the entity selector while applying automatic tagging?

Regards,

Babar

[Mohamed_Hamdy]

Hi @Babar_Qayyum ,

I suggest trying one of the following sample queries:

1. type(ibmmq:local_queue), entityName.in("queue1", "queue2"), not(entityName.in("queue3", "queue4"))
2. type(ibmmq:local_queue), not(entityName.in("queue3", "queue4"))

While I haven’t tested these with the IBM MQ extension, they worked well for me with a standard message queue. Please test these queries and let me know if they work for you.

For reference, here are similar queries using a generic QUEUE type:

1. type(QUEUE), entityName.in("queue1", "queue2"), not(entityName.in("queue3", "queue4"))
2. type(QUEUE), not(entityName.in("queue3", "queue4"))

Best Regards,

Mohamed

[Babar_Qayyum]

Hello @Mohamed_Hamdy 

I was playing around with this one not(entityName.in, but it did not work in my case. I want to eliminate backout queues as a wild mask and others as queue names. The wild mask works only with the entityName as the value operator contains, but it does not accept the multiple values.

Regards,

Babar

[Yosi_Neuman · Accepted solution]

Hו @Babar_Qayyum  & @Mohamed_Hamdy 

The follows work for me at customer site yesterday for metric selector:

ibmmq.queue.depth
:filter(in("dt.entity.ibmmq:local_queue", 
entitySelector("
    type(~"ibmmq:local_queue~"),
    queue_manager(~"AAA.XXX.QMGR~"), 
    not(entityName.startsWith(~"QL.DMZ.COMPRETAIL.TO.PORTAL.INTERNET~")),
    not(entityName.startsWith(~"QL.DMZ.COMPRETAIL.TO.RETAIL~"))
    ")))
:splitBy("dt.entity.ibmmq:local_queue")

and for Tag by entity selector 

type("ibmmq:local_queue"),
queue_manager("AAA.BBB.QMGR"),
not(entityName.startsWith("QL.DMZ.COMPRETAIL.TO.PORTAL.INTERNET")),
not(entityName.startsWith("QL.DMZ.COMPRETAIL.TO.RETAIL"))

 HTH

Yos 

[Babar_Qayyum]

Hello @Yosi_Neuman 

Thank you for your comments. It worked for me.

Regards,

Babar