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
Get Updates on the Splunk Community!

Stay Connected: Your Guide to May Tech Talks, Office Hours, and Webinars!

Take a look below to explore our upcoming Community Office Hours, Tech Talks, and Webinars this month. This ...

They're back! Join the SplunkTrust and MVP at .conf24

With our highly anticipated annual conference, .conf, comes the fez-wearers you can trust! The SplunkTrust, as ...

Enterprise Security Content Update (ESCU) | New Releases

Last month, the Splunk Threat Research Team had two releases of new security content via the Enterprise ...