Data explorer: option for Code Tab exclusion

[Babar_Qayyum]

Dear All,

Is there a way to exclude a particular database or service with the data explorer Code tab?

e.g. top 10 DB connections failures except for XYZ /or top 10 service errors toral rate except XYZ

• builtin:service.dbconnections.failureRate:splitBy("dt.entity.service"):value:auto:sort(value(sum,descending)):limit(10)
• builtin:service.errors.total.rate:splitBy("dt.entity.service"):avg:auto:sort(value(avg,descending)):limit(10)

Regards,

Babar

[AgniLanka · Accepted solution]

• builtin:service.dbconnections.failureRate:filter(and(not(in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMS~")"))))):splitBy("dt.entity.service"):value:auto:sort(value(sum,descending)):limit(10)
• builtin:service.errors.total.rate:filter(and(not(in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMS~")"))))):splitBy("dt.entity.service"):avg:auto:sort(value(avg,descending)):limit(10)

[Babar_Qayyum]

Hello @AgniLanka 

Thank you for your prompt response. What is wrong with my side in the below screenshot?

Regards,

Babar

[AgniLanka]

Missing ~ after >

[Babar_Qayyum]

Hello @AgniLanka 

Thank you for the correction. What is required to modify in the below string to exclude multiple services?

builtin:service.errors.total.rate:filter(and(not(in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMS~")"))))):splitBy("dt.entity.service"):avg:auto:sort(value(avg,descending)):limit(10)

Regards,

Babar

[AgniLanka]

builtin:service.errors.total.rate:filter(

and(

not(

in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMSxxx~")"))),

not(

in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMSyyy~")")))

)

):splitBy("dt.entity.service"):avg:auto:sort(value(avg,descending)):limit(10)

[AgniLanka]

REMSxxx~ covers for you the REMSxxx123 & REMSxxx456 as well as REMSxxxABCD

i.e., ~ may be considered as an equivalent role player the way an asterisk (*) would in a typical REGEX world.

[Babar_Qayyum]

Hello @AgniLanka 

Thank you for your great support.

Can we have a little more sophisticated rule?

e.g. the top 10 dt.entity.service having failures more than 10 in a minute aggregation or 10% failure rate.

Regards,

Babar

[AgniLanka]

builtin:service.errors.total.rate:auto:sort(dimension("dt.entity.service",ascending)):rollup(auto,1m):filter(series(auto,gt(10))):filter(and(not(in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMS~")"))))):splitBy("dt.entity.service"):limit(10)

gt(10) --> 10% or more
rollup(auto,1m) --> data rolled into 1minute intervals
and(not... --> exception list where measurement isn't necessary
limit(10) --> Top 10

[AgniLanka]

...OR...


builtin:service.errors.total.rate:auto:rollup(auto,1m):filter(series(auto,gt(10))):filter(and(not(in("dt.entity.service",entitySelector("type(service),entityName(~"Database_PRD - //REMS~")"))))):splitBy("dt.entity.service"):sort(dimension("dt.entity.service",descending)):limit(10)

[Babar_Qayyum]

Hello @AgniLanka 

Getting the following:

Regards,

Babar

[AgniLanka]

rollup is limited to graph visualisation ONLY.

[Babar_Qayyum]

Hello @AgniLanka 

Can we use the same while using the arithmetic function? e.g. 

All WebSphere processes except "adminagent" and "nodeagent"

((builtin:tech.jvm.memory.pool.used:filter(and(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),softwareTechnologies(~"WEBSPHERE~")")))):avg:splitBy("dt.entity.process_group_instance")) / (builtin:tech.jvm.memory.pool.committed:filter(and(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),softwareTechnologies(~"WEBSPHERE~")")))):avg:splitBy("dt.entity.process_group_instance")) * (100)):splitBy("dt.entity.process_group_instance") 

Regards,

Babar