Not a customer? Click the 'Start a free trial' link to begin a 30-day SaaS trial of our product and to join our community.
Existing Cisco AppDynamics customers should click the 'Sign In' button to authenticate to access the community
04-18-2021 04:15 AM
hello ,
I want to get active users count per region for my mobile application , I used the following query :
04-18-2021 05:22 AM
Hi Amr
Within AppD inside the Mobile App records it used the "closed" field inside the mobile_session_records to determine if a session is active or not
To view the data in a graphical over time format you can use the below, can adjust the series time depending on the timeframe.
SELECT series(eventTimestamp, "120m"), georegion, count(*) AS "Active Sessions" FROM mobile_session_records WHERE closed = false
To view it as a single count in table format
SELECT georegion, count(*) AS "Active Sessions" FROM mobile_session_records WHERE closed = false
As it uses the field "closed" to check if a session is open or not, you will only ever see the current open sessions, and it won't show you a historical view of open sessions as you see in the Session Tab
If you want that type of view, you will need to create metrics that will store the "Active Sessions" data for you to show in the dashboard
Ciao
04-18-2021 07:05 AM
hello Mario ,
Thanks a lot for your response , I really appreciate it
but it is not the case , I don't want to get the count of active sessions . I want to get the unique count of application users not sessions .
I need to know how many users install and uses the application.
for example :
I have 100 k sessions but I'm sure that users of my app are less than that as it only published for potential 20 k users , so I need to know how many users out of these 20 k uses the app
this is provided in session tab in active users widget
thanks
10-05-2022 05:27 AM
Hello ,
you can use the below query to get the active unique users
SELECT distinctcount(agentID) FROM mobile_session_records
--
kind regards
Mudassir Mir
User | Count |
---|---|
4 | |
1 | |
1 | |
1 | |
1 | |
1 |
Thank you! Your submission has been received!
Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form