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.