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!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...