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?
Solved! Go to Solution.
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.
you are referring to useraction.name. I am talking about Page and Page groups:
Any suggestion about that?
Does this do what you want?
SELECT distinct userevent.page from usersession
I tried that but what I get is "null" value. Is it working on your tenant?
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.
Will officially be available with 1.218 😉