topic Re: Problem with USQL in Real User Monitoring

Problem with USQL

radek_jasinski — Wed, 07 Feb 2024 09:58:44 GMT

Hi,

I have a USQL like this. I would like to catch information that a user has chosen a different look for the application. However, I am only interested in catching his last session (not all of them) to determine what app template they are using. Anyone know if this can be done?

SELECT COUNT(DISTINCT internalUserId) AS "Number of users", stringProperties.template_type AS "GP Type" FROM usersession GROUP BY stringProperties.template_type

Radek

Re: Problem with USQL

ChadTurner — Mon, 18 Nov 2024 00:39:29 GMT

I would add into your statement to have the end time, then filter ASC/DEC per the end time, that will give you the last session. Also keep in mind, until RUM is in grail (Right around the corner) you will only be looking at completed sessions with USQL.

Re: Problem with USQL

Peter_Youssef — Wed, 20 Nov 2024 09:03:57 GMT

Hello @radek_jasinski

PFA URL for checking the current scenario https://www.dynatrace.com/support/doc/javascriptapi/interfaces/dtrum_types.DtrumApi.html#addActionProperties

After defining the start and end actions you can create a USQL query to retrieve the target output.

Hoping it adds value.

BR,

Peter