topic Re: Monthwise RUM details of an application in Dynatrace API

Monthwise RUM details of an application

Balamurugesh — Mon, 27 Mar 2023 09:24:20 GMT

hi, I am looking for an API which will provide monthwise RUM details like "apdexCategory",

"application", "avg(userActionCount)", "userType", "avg(duration)",

"count(*)", "sum(totalErrorCount)", "userExperienceScore" for an application configured in Dynatrace. I am using below curl request to get data but am not sure how to group the details in monthwise format for each application

curl --location --request GET 'https:// dynatrace.nml.com/e/abcd/api/v1/userSessionQueryLanguage/table?query=SELECT%20useraction.apdexCategory%2C%20useraction.application%2C%20%20AVG%28userActionCount%29%2C%20userType%2C%20AVG%28duration%29%2C%20COUNT%28%2A%29%2C%20SUM%28totalErrorCount%29%2C%20userExperienceScore%20FROM%20usersession%20WHERE%20useraction.application%20%3D%20%27tem_clientwebsite_preprod%27%20GROUP%20BY%20%20useraction.apdexCategory%2C%20useraction.application%2CuserExperienceScore%2C%20userType%20ORDER%20BY%20COUNT%28%2A%29%20DESC&pageSize=1000&addDeepLinkFields=false' \

--header 'accept: application/json' \

--header 'Authorization: abcd'

Re: Monthwise RUM details of an application

AntonioSousa — Sun, 04 Sep 2022 13:21:40 GMT

@Balamurugesh,

You should use the startTimestamp & endTimestamp parameters. Please check it out at:
https://www.dynatrace.com/support/help/dynatrace-api/environment-api/rum/user-sessions/table

Re: Monthwise RUM details of an application

Balamurugesh — Mon, 19 Sep 2022 17:20:51 GMT

hi Antonio,

Can you please share the sample request? i am not sure about the parmaters to be passed to get monthwise details.

Thanks,

Dingu

Re: Monthwise RUM details of an application

AntonioSousa — Mon, 27 Mar 2023 09:24:45 GMT

@Balamurugesh,

You can do it by something like the following line of curl. Please change abc12345 for your tenant and DYNATRACE.TOKEN for the auth token. As you can see, you will have to give the corresponding UTC time in milliseconds:

curl -X GET "https://abc12345.live.dynatrace.com/api/v1/userSessionQueryLanguage/table?query=select%20apdexcategory%2C%20count%28%2A%29%20from%20useraction%20group%20by%20apdexcategory&startTimestamp=1659315600000&endTimestamp=1661994000000&addDeepLinkFields=false&explain=false " -H "accept: application/json" -H "Authorization: Api-Token DYNATRACE.TOKEN"

It's easier if you test it in the UI first. Change abd12345 for your tenant and give it a try:

https://abc12345.live.dynatrace.com/rest-api-doc/index.jsp?urls.primaryName=Environment%20API%20v1#/RUM%20-%20User%20sessions/getDTAQLResultAsTable

Re: Monthwise RUM details of an application

Balamurugesh — Thu, 22 Sep 2022 14:03:18 GMT

thanks @AntonioSousa for the details. i am looking for a field which provides availability % of monitors or application from RUM API. I tried querying usersession and useraction tables but could not figure the field. Can you provide info on this?

Re: Monthwise RUM details of an application

AntonioSousa — Thu, 22 Sep 2022 18:59:06 GMT

@Balamurugesh,

Please notice that availability might be very difficult to get from RUM data, and thus USQL. Better done with synthetic monitoring, which I believe are the monitors you are referring to. For these, there is a different synthetic API, that you might use.