topic Re: Getting user actions for a given time with USQL in Real User Monitoring

Getting user actions for a given time with USQL

mkulov — Thu, 03 Sep 2020 09:24:24 GMT

Hi,

I want to get user actions for a given period of time - lets say for yesterday.

I am running the following query but I get no results:

SELECT name FROM useraction WHERE startTime < "2.09.2020"

When I set the date to be current date "3.09.2020" I am getting data as expected.

However no data is received for a given period of time other than the current date.

Any idea how to get user actions for a given period of time?

Thank you,

Martin

AlexanderSommer — Thu, 03 Sep 2020 11:01:01 GMT

Have you adjusted the global time frame selector in the header?

mkulov — Fri, 04 Sep 2020 08:15:55 GMT

Hi Alexander,

Yes, it was the timeframe selector and I was also missing startTimestamp parameter for the API call.

Thanks for your help!

Martin