topic Re: USQL alerting in Alerting

USQL alerting

vladislav_samoy — Fri, 06 Dec 2019 15:27:56 GMT

Hi gents

Is it possible somehow using native Dynatrace possibilities to raise the Problem (send alert) if some value, which we are getting by USQL query breaches the threshold?

The case: Unsuccessful placing order by users more than 10 per X minutes - Open the problem

It looks like now we have possibility to create custom alerts based only on timeseries data, but not on EUM data (Elastic)

Re: USQL alerting

skrystosik — Sat, 07 Dec 2019 11:41:34 GMT

So far it is not possible. You need option to create custom metric based on USQL result, than you will be able to define threshold on this value. It’s kind of point for product idea 🙂

Sebastian

Re: USQL alerting

vladislav_samoy — Mon, 09 Dec 2019 09:36:36 GMT

You know, it sounds kinda strange to write the plugin which gets some value from one Dynatrace storage location, and put it to another 🙂

Re: USQL alerting

skrystosik — Mon, 09 Dec 2019 09:50:17 GMT

Not actually, DT needs to allow such option. The same story is with making custom metrics based on transactional data from multidimensional analysis which will be available next year.

USQL results are not stored anywhere as calculated data that can be analysed by AI engine. It's calculated live while you are fetching data based on data related to user sessions.

Sebastian

Re: USQL alerting

Julius_Loman — Mon, 09 Dec 2019 20:04:41 GMT

Still, alerting on USQL results is useless unless we can query live session data with USQL. Sessions may take minutes to hours to be closed and included in the results.

Re: USQL alerting

vladislav_samoy — Tue, 10 Dec 2019 12:02:04 GMT

yes, and this is another topic. Session properties are not planned for live sessions afaik.