• 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 /
  • Application Monitoring & UEM /
  • AppMon & UEM Open Q&A /
avatar image
Question by Jim M. · Jul 30, 2014 at 09:53 AM ·

Querying Error Dashlet

I am a DynaTrace 5.6 user.

I want to query the error dashlet to find out how many time a particular database exception has occurred since the start of the year.    Can anyone tell me how to do this?    I am SQL literate, but not sure how to construct an ad-hoc query in DynaTrace.

 

Jim

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 Andreas G. · Jul 30, 2014 at 05:19 PM

Hi Jim

This is something you wouldnt query by looking at the Error Dashlet but you would do this with an Exception -> Count Measure. This will be a measure that counts how often a certain exception is thrown. The benefit of the measure is that it will be stored in the Performance Warehouse which you can then chart for a very long time period. The Errors Dashlet shows data by looking at the PurePaths that you have in your storage. It is very likely that we do not keep PurePaths for a whole year.

Having said that - here are the steps

#1: Find a PurePath that contains your Exception

#2: Via the Context Menu on that Exception in the PurePath Tree select "Create Measure"

#3: The Create Measure Dialog will come up pre-filling the necessary fields. You want to give the measure a proper name before clicking OK

#4: Now create a new dashboard and add a Chart. On that Chart you can add your measure. You can set the timeframe of this chart to e.g: 365 days

This approach will start working once you have created the measure - meaning - that the measure will be calculated for new incoming PurePaths. If you want to look at historical data before you created the measure then you can have a look at the Database Exception Measure. This is an out-of-the-box Measure that counts the number of Exceptions happening within your DB Access Layer (JDBC, ADO.NET). It is not counting a particular DB Exception but at least allows you to see historical data.

I would still go with my described approach which will give you the data you need from new incoming PurePaths

Hope this helps

Comment

People who like this

0 Show 0 · 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.

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

1 Person is following this question.

avatar image

Forum Tags

dotnet mobile monitoring load iis 6.5 kubernetes mainframe rest api dashboard framework 7.0 appmon 7 health monitoring adk log monitoring services auto-detection uem webserver test automation license web performance monitoring ios nam probe collector migration mq web services knowledge sharing reports window java hybris javascript appmon sensors good to know extensions search 6.3+ server documentation easytravel web dashboard kibana system profile purelytics docker splunk 6.1 process groups account 7.2 rest dynatrace saas spa guardian appmon administration production user actions postgresql upgrade oneagent measures security Dynatrace Managed transactionflow technologies diagnostics user session monitoring unique users continuous delivery sharing configuration alerting NGINX splitting business transaction client 6.3 installation database scheduler apache mobileapp RUM php dashlet azure purepath agent 7.1 appmonsaas messagebroker nodejs 6.2 android sensor performance warehouse
  • 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