cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Query for COUNT user sessions for one application

Hello,

There is no documentation for this at all.

How can i request very very simple request:

I need count user sessions for today only for application "some_application"

Not working this and others same variants:

SELECT * FROM usersession WHERE usersession.application.displayName = "some_application"

Regards,

Alexander


4 REPLIES 4

AlexanderSommer
Dynatrace Pro
Dynatrace Pro

select count(*) from usersession where userType = 'REAL_USER' and useraction.application = 'easyTravel Frontend'

You have to use useraction.application as a user session can cross more than one application.


Alexander, Thank you. I didn`t try useraction.application. (I think that only for user actions i need to use useraction table)

Regards,

Alexander


kulwinder_singh
Inactive

Here is the link to detailed documentation on that

https://www.dynatrace.com/support/help/how-to-use-dynatrace/real-user-monitoring/how-to-use-real-use...

regards,

Kulwinder S.


Yes, but it is drop in the ocean.

Regards,

Alexander