Splunk Search

How would you find trends in ticket system data.

smlrwd
Explorer

Hello everyone,

All of our service desk tickets are collected by Splunk. I want to create a search that finds trends in the incoming tickets.

For example:

The exchange server goes down unexpectedly. Multiple people open tickets for email being down.

The problems:
1) Tickets have a lot of similar field data in Splunk.
2) People don't use the same words to describe the problem. (i.e. email isn't working vs. Outlook is down)

What would be the best way to go about trying to find a trend in this type of data?

Thanks in advance.

Tags (3)
0 Karma

lguinn2
Legend

Let's assume that you have at least a couple of fields in your tickets: a category field (which could be "email" or "laptop" or other things), a timestamp and a sourcetype of "ticket". Finally, let's also assume that tickets have a field named status, which could contain "new", "closed", etc.

Here is a very simple search that will show the volume of tickets opened over time, by category.

sourcetype=ticket status="new"
| timechart count by category

The more fields that you have, the more fine-grained your possibilities for searching and graphing. But - if you don't have fields to categorize the data, it will be harder. You could use eventtypes to help build categories, but it will be a lot of work if the variation is great.
For example, I could create an eventtype based on the search "Outlook" OR "email", but that might be too broad or too narrow for the data. Tags can be helpful for categorization, too.

You can find information on tags and eventtypes in the documentation. Here is a short video tutorial on eventtypes; it is several years old, so the user interface looks different, but eventtypes are still the same.

0 Karma
Got questions? Get answers!

Join the Splunk Community Slack to learn, troubleshoot, and make connections with fellow Splunk practitioners in real time!

Meet up IRL or virtually!

Join Splunk User Groups to connect and learn in-person by region or remotely by topic or industry.

Get Updates on the Splunk Community!

Design, Compete, Win: Submit Your Best Splunk Dashboards for a .conf26 Pass

Hello Splunkers,  We’re excited to kick off a Splunk Dashboard contest! We know that dashboards are a primary ...

May 2026 Splunk Expert Sessions: Security & Observability

Level Up Your Operations: May 2026 Splunk Expert Sessions Whether you are refining your security posture or ...

Network to App: Observability Unlocked [May & June Series]

In today’s digital landscape, your environment is no longer confined to the data center. It spans complex ...