• Forums
    • Public Forums
      • Community Connect
      • Dynatrace
        • Dynatrace Open Q&A
      • Application Monitoring & UEM
        • AppMon & UEM Open Q&A
      • Network Application Monitoring
        • NAM Open Q&A
  • Home /
  • Public Forums /
  • Dynatrace /
  • Dynatrace Open Q&A /
avatar image
Question by Matias V. · Jun 24, 2020 at 08:00 PM · dashboard rest api user session monitoring user actions usql

Best way to meassure people using an application

Hi community!

I'm looking for some advice from you.

I'm looking for the best, or more appropiate way to measure "how many people is using a web application".


So far I come with the idea of using USQL to get the count of user sessions through the API, and send that number to a custom metric used by a custom device through the API.

But I'm not relying in what I'm doing.

This is the USQL sentence I'm using (I'm not good at this so it may be lot of room to improve this)

SELECT COUNT (userSessionId) FROM usersession WHERE useraction.application="web app"


So I'm querying that through the API, then parcing the result to get the number of sessions and sending the numbert to a custom device.
But I feel it should be a better way to show this.

As a result I'd like to build a chart to show this information in a timeseries.


Thank you and any feedback would be much appreciated.

Comment

People who like this

0 Show 0
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

1 Reply

  • Sort: 
  • Most voted
  • Newest
  • Oldest
avatar image

Answer by Bob C. · Jun 24, 2020 at 09:00 PM

Hey Matias


Are you wanting to count Dynatrace users? If so, that can be done via the Audit Log and the API. You can extract unique users per timeframe there. Explore the API here: https://www.dynatrace.com/support/help/shortlink/api-audit-logs-get-log#parameters

If you are looking to get users in an application currently monitoring, yes that execution is what you'd need to execute. The detailed API on that is here: https://www.dynatrace.com/support/help/shortlink/api-usql-table#parameters

If you're then looking to chart users in Dynatrace, you can use a Custom Chart and save it to a dashboard. If looking to chart outside of dynatrace, you can put that USQL data into an excel sheet and chart from there.


Hope this helps.


Bob Crumley

Comment
Maciej N.

People who like this

1 Show 1 · Share
10 |2000000 characters needed characters left characters exceeded
  • Viewable by all users
  • Viewable by moderators
  • Viewable by moderators and the original poster
  • Advanced visibility
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

avatar image Matias V. · Jun 24, 2020 at 09:22 PM 1
Share

Hi @Bobby C.,


Thanks for answering!


Basically what I need is the same chart you have in the user sessions page, filtered by an application, but instead of having the bar chart, in a timeseries way, so I can use it on a dashboard.

I'm good with the completed sessions, so that is why I thought on using USQL since there's no built in metric to make a custom chart for this info.


Thanks!

How to get started

First steps in the forum
Read Community User Guide
Best practices of using forum

NAM 2019 SP5 is available


Check the RHEL support added in the latest NAM service pack.

Learn more

LIVE WEBINAR

"Performance Clinic - Monitoring as a Self Service with Dynatrace"


JANUARY 15, 3:00 PM GMT / 10:00 AM ET

Register here

Follow this Question

Answers Answers and Comments

33 People are following this question.

avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image avatar image

Related Questions

Get user apdex value via API

Create business journey dashboard by USQL

User action custom properties are being reported as null (most of the time)

We have a dashboard Key User Actions if i can get response time of Key Actions through API ?

using USQL how to show the duration in Seconds?

Forum Tags

mobile monitoring dotnet iis chat kubernetes servicenow amazon web services feedback mysql mainframe application rules rest api cassandra dashboard oneagent sdk cmc application monitoring openkit smartscape request attributes monitoring developer community user tagging log monitoring services ufo activegate auto-detection high five award uem webserver usql iib test automation license ios news migration management zones ibm mq web services notifications sso host monitoring knowledge sharing reports browser monitors java hybris sap vmware maintenance window user action naming javascript appmon ai availability tipstricks automation extensions diagnostic tools session replay permissions search davis assistant auto-update faq documentation problem detection http monitors easytravel apdex network docker tags and metadata cloud foundry google cloud platform synthetic monitoring process groups account usability dynatrace saas gui paas openshift key user actions administration production user actions postgresql synthetic locations upgrade oneagent security Dynatrace Managed user management python technologies mongodb openstack user session monitoring continuous delivery citrix configuration alerting performance monitoring NGINX action naming linux nam installation error reporting database mission control apache mobileapp RUM php azure purepath davis scripting aix nodejs android
  • Forums
  • Public Forums
    • Community Connect
    • Dynatrace
      • Dynatrace Open Q&A
    • Application Monitoring & UEM
      • AppMon & UEM Open Q&A
    • Network Application Monitoring
      • NAM Open Q&A