I need to get user action duration and user account count by given start and end time and user action name. When I group all the data by start time the only thing which I can get is the count of the records on a single group. I use Dynatrace Environment API2 v1 in section “User sessions” and extract it as a table.
SELECT name, starttime, endtime, duration FROM useraction
The only thing which I can get is all of the registered user actions. Here is the result, which a receive.
I would like to receive the information about the action duration, action name, start and end time of the action on some period of time. In other words I want to group all of the records in a time groups.
Solved! Go to Solution.
@Simeon V. I would recommend using the following USQL:
SELECT name, startTime, endTime, duration FROM useraction WHERE usersession.userId IS NOT NULL ORDER BY name ASC.
Also if the Json output from the API isnt helping you supply the data you are looking for in excel format, You can always copy and paste the USQL data from the UI into Excel also you can always link excel to the URL of the USQL and have excel fetch the data.