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

Get concurrent user sessions

ArtuD
Participant

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

 

4 REPLIES 4

Malaik
DynaMight Champion
DynaMight Champion

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.

Sharing Knowledge

 

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
DynaMight Champion
DynaMight Champion

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

Can you show the result in Dynatrace user session?

Sharing Knowledge

PacoPorro
Dynatrace Leader
Dynatrace Leader

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

PacoPorro_0-1710142047859.png

 

 

Featured Posts