topic Re: Query for COUNT user sessions for one application in Real User Monitoring

Query for COUNT user sessions for one application

Romanenkov_Alex — Tue, 16 Apr 2019 12:20:09 GMT

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 — Tue, 16 Apr 2019 12:43:37 GMT

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 — Tue, 16 Apr 2019 12:58:45 GMT

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 — Tue, 16 Apr 2019 13:09:24 GMT

Here is the link to detailed documentation on that

regards,

Kulwinder S.

Romanenkov_Alex — Tue, 16 Apr 2019 14:32:47 GMT

Yes, but it is drop in the ocean.

Regards,

Alexander