Splunk AppDynamics

How to create an Analytic query that would show the top 5 Business Transactions with Error counts?

tdavison76
Path Finder

Hello,

I am trying to create an Analytic query that would show the top 5 BTs with Error counts.

e.g.

TransactionName  3

I'm not great at building SQL or Analytics queries. : )

Thanks for any help, much appreciated.

Tom 

Labels (1)
0 Karma
1 Solution

Morelz
Motivator

Hi Tom

You can do it this way

SELECT transactionName, count(*) AS "Counts" FROM transactions WHERE userExperience = "ERROR" ORDER BY Counts DESC LIMIT 5

This would be across all applications, you can put in additional filters if you want to limit it to a specific application etc.

Ciao

View solution in original post

Morelz
Motivator

Hi Tom

You can do it this way

SELECT transactionName, count(*) AS "Counts" FROM transactions WHERE userExperience = "ERROR" ORDER BY Counts DESC LIMIT 5

This would be across all applications, you can put in additional filters if you want to limit it to a specific application etc.

Ciao

tdavison76
Path Finder

Thank you very much for the Solution on this.  Very much appreciated.

Thanks,

Tom

0 Karma
Get Updates on the Splunk Community!

Demo Day: Strengthen Your SOC with Splunk Enterprise Security 8.1

Today’s threat landscape is more complex than ever. Security operation centers (SOCs) are overwhelmed with ...

Dashboards: Hiding charts while search is being executed and other uses for tokens

There are a couple of features of SimpleXML / Classic dashboards that can be used to enhance the user ...

Splunk Observability Cloud's AI Assistant in Action Series: Explaining Metrics and ...

This is the fourth post in the Splunk Observability Cloud’s AI Assistant in Action series that digs into how ...