topic Re: Setting time frame for USQL query in Real User Monitoring

Setting time frame for USQL query

fumax — Wed, 21 Aug 2024 12:45:46 GMT

I want to fetch all the xhr actions inside a web application. I am using following usql query(and sending it as a param in GET /api/v1/userSessionQueryLanguage/table

SELECT useraction.name, COUNT(*) AS action_count FROM usersession WHERE useraction.application = 'Temperstack-Local' AND useraction.type = 'Xhr' AND useraction.startTime >= $NOW - DURATION("1d") GROUP BY useraction.name ORDER BY action_count DESC

Where I am facing issue is getting result based on timeframe.
Even if I use: useraction.startTime >= 'yyyy-mm-dd', it won't work.
What works is selecting the desired timeframe in the dynatrace UI.
What exactly am I doing wrong?

Re: Setting time frame for USQL query

Mizső — Tue, 13 Aug 2024 21:26:36 GMT

Hi @fumax,

I have tired many options without any success. Maybe our synthax is woring.

This option works only form me (becuase $NOW $TIME_FRAME_START are time variables) and but I think it will not a solution for you which is similar to $NOW:

SELECT useraction.name, COUNT(*) AS action_count FROM usersession WHERE ((useraction.application='Phoenix' OR userevent.application='Phoenix' OR usererror.application='Phoenix')) AND useraction.startTime >=$TIME_FRAME_START - DURATION("1d") GROUP BY useraction.name

Next oprion was the unix time, I have not received any error message (because it a numeric number) but did not work...

SELECT useraction.name, COUNT(*) AS action_count FROM usersession WHERE ((useraction.application='Phoenix' OR userevent.application='Phoenix' OR usererror.application='Phoenix')) AND useraction.startTime >=1723327200 - DURATION("1d") GROUP BY useraction.name

Third option was where the error message clear.

Maybe other community members have any other ideas.

Best regards,

Mizső

Re: Setting time frame for USQL query

fumax — Wed, 14 Aug 2024 04:16:22 GMT

Hey @Mizső
Thank you for your valuable effort and response.

Do you know of any direct api to fetch actions from a web app instead of usql query?

Re: Setting time frame for USQL query

Mizső — Thu, 15 Aug 2024 21:00:23 GMT

Hi @fumax,

I thnik there is not such API.

You can only use the API which uses USQL.

Best regards,

Mizső