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

About the association between UserSession and UserAction extracted by User Session Query language API

menda
Guide

Hi,

I'm experimenting with the User Session Query language API.

The document contains "userActions" in the UserSession object, but the execution result of the Dynatrace Environment API doesn't include it.

[Document URL]https://www.dynatrace.com/support/help/dynatrace-api/environment/usql-api/#anchor_table

[Query]select * from Usersession

I could extract only UserAction with API, but I couldn't find a key to link UserSession and UserAction.

[Query]select * from useraction

I intend to extract UserSession and UserAction individually with User Session Query language API.

Is there a way to associate those data?

Best Regards,

Masahiko Enda


1 REPLY 1

Julius_Loman
Leader

As far as I remember, you can directly select it this way:

select userid,userSessionId,useraction.* from usersession