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

[menda]

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

[Julius_Loman · Accepted solution]

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

select userid,userSessionId,useraction.* from usersession