cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

USQL - Extract list of Page and Page group

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,

6 REPLIES 6

Dallas
Dynatrace Mentor
Dynatrace Mentor

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

Hello,

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

monitoringteam1_0-1621350002722.png

Any suggestion about that?

Thanks,

 

HannahM
Dynatrace Pro
Dynatrace Pro

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?

Thank you,

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 😉