Get concurrent user sessions

[ArtuD]

How can i use USQL to take concurrent user sessions from the same user and get the time the user started wich session?

[Malaik]

Hi,

What you mean by current session?

You should know that USQL can have statistics for only ended sessions, so live session will not be counted.

If you need more assistance, please tell me more.

[ArtuD]

I mean, at a specific timeframe, a person accessed a website twice simultaneously, but these two sessions have already ended. I would like to know if it is possible to identify these two simultaneous accesses from the same user using usql. 

[Malaik]

If those 2 sessions are logged 2 times in Dynatrace so Yes.

Can you show the result in Dynatrace user session?

[PacoPorro · Accepted solution]

Assuming you are already tagging your users, you can do something like this

SELECT userId, count (DISTINCT userSessionId) FROM usersession where userId is not null  group by userId  

in table mode , you can get something like