topic Re: Data explorer Code tab exclusion option in Dashboarding

Data explorer: option for Code Tab exclusion

Babar_Qayyum — Tue, 30 May 2023 13:39:56 GMT

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

Re: Data explorer Code tab exclusion option

AgniLanka — Thu, 06 Jan 2022 08:25:37 GMT

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)

Re: Data explorer Code tab exclusion option

Babar_Qayyum — Thu, 06 Jan 2022 08:57:12 GMT

Hello @AgniLanka

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

Regards,

Babar

Re: Data explorer Code tab exclusion option

AgniLanka — Thu, 06 Jan 2022 09:11:37 GMT

Missing ~ after >

Re: Data explorer Code tab exclusion option

Babar_Qayyum — Thu, 06 Jan 2022 12:22:22 GMT

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

Re: Data explorer Code tab exclusion option

AgniLanka — Thu, 06 Jan 2022 12:33:19 GMT

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)

Re: Data explorer Code tab exclusion option

AgniLanka — Thu, 06 Jan 2022 12:41:45 GMT

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.

Re: Data explorer Code tab exclusion option

Babar_Qayyum — Sun, 09 Jan 2022 07:28:00 GMT

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

Re: Data explorer Code tab exclusion option

AgniLanka — Mon, 10 Jan 2022 16:26:04 GMT

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

Re: Data explorer Code tab exclusion option

AgniLanka — Mon, 10 Jan 2022 16:25:37 GMT

...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)

Re: Data explorer Code tab exclusion option

Babar_Qayyum — Tue, 11 Jan 2022 10:14:39 GMT

Hello @AgniLanka

Getting the following:

Regards,

Babar

Re: Data explorer Code tab exclusion option

AgniLanka — Tue, 11 Jan 2022 10:27:54 GMT

rollup is limited to graph visualisation ONLY.

Re: Data explorer Code tab exclusion option

Babar_Qayyum — Thu, 13 Jan 2022 08:36:27 GMT

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