Query for COUNT user sessions for one application

[Romanenkov_Alex]

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

[AlexanderSommer · Accepted solution]

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.

[Romanenkov_Alex]

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]

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.

[Romanenkov_Alex]

Yes, but it is drop in the ocean.

Regards,

Alexander