Specify availability of a useraction in Synthetic monitor

[grepei]

Hi,

Version: Managed

Is there any possibility to calculate availability (%) for a single step of a browser clickpath monitor?

Eg.: the 3rd step is visiting a card payment service with an external URL and you want to measure the availability of this service.

Adding a new synthetic test for this URL only is a good solution but the question was different...

I could not find any solution from USQL neither by creating  custom metrics. It seems availability is measure on usersession level only.

Thanks,

Gabor

[AntonPineiro]

Hi,

If you have OneAgent installed in fullstack, maybe you can check payment service discovered by OneAgent instead of Synthetics.

Best regards

[grepei]

Card payment service is an external service, OneAgent cannot be used.

Rgds,

Gabor

[HannahM]

You could calculate it using the metrics. This would be the same as the new calculation used by Grail, rather than the one used by Managed, but they are pretty close. 

Availability = ((total executions - failed executions)/total executions)*100

((builtin:synthetic.browser.event.total:filter(and(or(in("dt.entity.synthetic_test_step",entitySelector("type(synthetic_test_step),entityId(~"SYNTHETIC_TEST_STEP-123~")"))))) - builtin:synthetic.browser.event.failure:filter(and(or(in("dt.entity.synthetic_test_step",entitySelector("type(synthetic_test_step),entityId(~"SYNTHETIC_TEST_STEP-123~")")))))) / builtin:synthetic.browser.event.total:filter(and(or(in("dt.entity.synthetic_test_step",entitySelector("type(synthetic_test_step),entityId(~"SYNTHETIC_TEST_STEP-123~")"))))))*100

 I used the synthetic step id as it's unique but if you know the step name isn't used in any other monitors, you could use that. 

[grepei · Accepted solution]

Complex USQL cannot be used for custom metrics. There are limitations in syntax and aggregation.

The most convenient way is to define a separate Synthetic for the specific step only.

We are trying to push the customer towards the SaaS solution, everything could be much easier for them.