topic Re: USQL - Extract list of Page and Page group in Real User Monitoring

USQL - Extract list of Page and Page group

monitoringteam1 — Fri, 14 May 2021 13:18:04 GMT

Hello,

is it possible to extract the list of page / pagegroup using USQL? I tried a simple query like:

SELECT page FROM userevent

But I get all null values.

Am I doing anything wrong?

Thank you,

Re: USQL - Extract list of Page and Page group

Dallas — Fri, 14 May 2021 17:50:27 GMT

Hey @monitoringteam1 ,

You could extract a list of page loads from the user sessions data and apply a Distinct filter to eliminate duplicates.

Is your query returning an error or a null values? When I use the SELECT "page" it returns an error. so I used "useraction.name" instead of "page" and "useraction" instead of "userevent"

I tried a query like below:

SELECT DISTINCT useraction.name FROM useraction WHERE name STARTSWITH "Loading"

That returned all of the various page loads that the users are performing. Note: that it might differ if you have user action naming set up differently than I do.

-Dallas

Re: USQL - Extract list of Page and Page group

monitoringteam1 — Tue, 18 May 2021 15:00:26 GMT

Hello,

you are referring to useraction.name. I am talking about Page and Page groups:

Any suggestion about that?

Thanks,

Re: USQL - Extract list of Page and Page group

HannahM — Tue, 18 May 2021 15:20:44 GMT

Does this do what you want?

SELECT distinct userevent.page from usersession

Re: USQL - Extract list of Page and Page group

monitoringteam1 — Wed, 19 May 2021 13:03:20 GMT

I tried that but what I get is "null" value. Is it working on your tenant?

Thank you,

Re: USQL - Extract list of Page and Page group

HannahM — Wed, 19 May 2021 13:03:35 GMT

Yes, that worked for me locally. If you expand the time you are looking at does it return any data?

If you don't get anything still and you can see data for the same time period in Pages then I would ask on chat for assistance.

Re: USQL - Extract list of Page and Page group

zietho — Wed, 19 May 2021 13:07:11 GMT

Will officially be available with 1.218 😉