USQL - Extract list of Page and Page group

[monitoringteam1]

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,

[Dallas]

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

[monitoringteam1]

Hello,

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

Any suggestion about that?

Thanks,

[HannahM · Accepted solution]

Does this do what you want?

SELECT distinct userevent.page from usersession

[monitoringteam1]

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

Thank you,

[HannahM]

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. 

[zietho · Accepted solution]

Will officially be available with 1.218 😉