Problem with USQL

[radek_jasinski]

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

[ChadTurner]

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. 

[Peter_Youssef · Accepted solution]

Hello @radek_jasinski 

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

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

Hoping it adds value.

BR,

Peter