22 Jan 2025
09:59 AM
- last edited on
27 Jan 2025
07:13 AM
by
MaciejNeumann
Hi,
We have some applications that has "No user actions during past" besides its name, which have no traffic for a timeframe in "Frontend" page.
I used these "Query User sessions" with USQL as same timeframe as Frontend:
SELECT application, usersession.userActionCount FROM useraction WHERE usersession.userActionCount IS NULL
SELECT application, usersession.userActionCount FROM useraction WHERE usersession.userActionCount = 0
But it did not give any results.
How do I replicate the results shown in "Frontend" page?
24 Jan 2025 03:30 PM - edited 24 Jan 2025 03:31 PM
Hi Vishnu,
The USQL has user session data, which means only applications that have user sessions captured would be available here.
So you would not find the list of applications that do not have data using USQL or Data Explorer as there is no data for these.
ie. It is like trying to query for data that does not exist.
the list is visible on the "Frontend" page, where you can see the monitored and unmonitored list.
Best Regards
Kiran
27 Jan 2025 07:26 AM
Thanks @KiranSomanatti , but you have answered the half of my query.
Understood on USQL not returning it.
But how do I export the apps list that was not active for more than 7 days.
Like the ones that has "No user actions during past" after their names?
Can I somehow use a DQL to execute in Notebook, to download it as CSV?
Thanks,
Vishnu