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

Export all inactive applications in RUM

vishnu_kumar
Participant

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?

2 REPLIES 2

KiranSomanatti
Dynatrace Participant
Dynatrace Participant

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.

KiranSomanatti_0-1737732546685.png

Best Regards

Kiran

 

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

Featured Posts