topic Export Inactive Applications in RUM Using DQL Queries in DQL

Export Inactive Applications in RUM Using DQL Queries

vishnu_kumar — Thu, 18 Dec 2025 12:43:47 GMT

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?

Re: Export all inactive applications in RUM

KiranSomanatti — Fri, 24 Jan 2025 15:31:51 GMT

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

Re: Export all inactive applications in RUM

vishnu_kumar — Mon, 27 Jan 2025 07:26:22 GMT

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

Re: Export all inactive applications in RUM

IzabelaRokita — Thu, 18 Dec 2025 12:43:19 GMT

Hey @vishnu_kumar ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.