topic Re: How to iterate response from dynatrace managed user sessions api endpoint? in Real User Monitoring

How to iterate response from dynatrace managed user sessions api endpoint?

dparkar — Tue, 27 Apr 2021 15:09:54 GMT

Only first 50 rows are returned. Is there a counter or page index which can be incremented to retrieve next batch of rows?

Re: How to iterate response from dynatrace managed user sessions api endpoint?

skrystosik — Wed, 19 Dec 2018 12:06:40 GMT

How your query looks like? According to documentation you should be able to get up to 5000 results:

https://www.dynatrace.com/support/help/monitor/use...

See limitation seciont. Didn't you have any TOP function in query?

Regards,

Sebastian

Re: How to iterate response from dynatrace managed user sessions api endpoint?

dparkar — Wed, 19 Dec 2018 12:12:40 GMT

SELECT TOP(distinct(userid),2000) from usersession where useraction.application = '<App_Name_String>' group by userid order by user id

which encodes to

userSessionQueryLanguage/table?query=SELECT%20top(distinct(userid)%2C2000)FROM%20usersession%20WHERE%20useraction.application%20%3D%20'<App_Name_String>'%20group%20by%20userid%20order%20by%20userid&startTimestamp=1545202800000&endTimestamp=1545206400000

Re: How to iterate response from dynatrace managed user sessions api endpoint?

dparkar — Wed, 19 Dec 2018 12:15:25 GMT

even if I use

SELECT userid from usersession where useraction.application = 'App_Name_String'

SELECT userid from usersession

it will still return 50 rows

No attribute in response available which could allow iterating the next batch.

Re: How to iterate response from dynatrace managed user sessions api endpoint?

skrystosik — Wed, 19 Dec 2018 12:18:19 GMT

You didn't set timeframe so I assume that it can return you users from short one. maybe this is the problem.

Re: How to iterate response from dynatrace managed user sessions api endpoint?

dparkar — Wed, 19 Dec 2018 12:19:59 GMT

I did set time frame in unix timestamp

I am sure its correct and I have verified its accurate

Tried using timeframe in script as well in the api explorer

Same issue persists

Re: How to iterate response from dynatrace managed user sessions api endpoint?

skrystosik — Wed, 19 Dec 2018 14:25:21 GMT

Try it like this:

SELECT userid from usersession LIMIT 1000

In this query dynatrace not allow higher limit than 1000.

Re: How to iterate response from dynatrace managed user sessions api endpoint?

dparkar — Thu, 20 Dec 2018 07:09:09 GMT

Cool. This works. 🙂

Thanks . Well it fetches more than 5000 at once.

Re: How to iterate response from dynatrace managed user sessions api endpoint?

Dant3 — Thu, 20 Dec 2018 10:01:03 GMT

I have the same problem, No matter what i set, the response is only 50 rows max in a managed solution.

We try with this kind of query:

SELECT usersession.ip, application, name, targetUrl,usersession.userId, startTime FROM useraction WHERE usersession.userType = "REAL_USER" GROUP BY usersession.ip, application, name, targetUrl,usersession.userId,startTime ORDER BY usersession.ip, startTime

To group all users by ip and application.by default it would be the last 2 hours. that's aprox at least 10k of user actions (5k per hour) but ended only showing no more than 50 user ressults.

Re: How to iterate response from dynatrace managed user sessions api endpoint?

dparkar — Thu, 20 Dec 2018 12:11:12 GMT

Thanks Dante. Will give it a try.

Hope you are able to retrieve more than 50 rows now using LIMIT