Splunk Search

How do you get a count on the latest status of Jira tickets?

cpboothe
New Member

Hi,

I want to get a count on tickets with the latest status of "In Progress". An example of the data set is below:

alt text

In this example data set, I should be getting a count of 1 ticket in "in Progress". I have tried a number of functions and reviewed the forum on similar questions, but I can't get the search working.

Any help would be greatly appreciated.

Thanks,

Craig

Tags (2)
0 Karma
1 Solution

richgalloway
SplunkTrust
SplunkTrust

It would help if you shared your current search. However, dedup should help solve the problem. It selects the most recent entry when it finds more than one with the same value so the earlier instance of RT-3 won't be seen.

 index=foo ticket_number=* status=* last_updated_date_time=* | dedup ticket_number| search status="In Progress" | stats count
---
If this reply helps you, Karma would be appreciated.

View solution in original post

0 Karma

richgalloway
SplunkTrust
SplunkTrust

It would help if you shared your current search. However, dedup should help solve the problem. It selects the most recent entry when it finds more than one with the same value so the earlier instance of RT-3 won't be seen.

 index=foo ticket_number=* status=* last_updated_date_time=* | dedup ticket_number| search status="In Progress" | stats count
---
If this reply helps you, Karma would be appreciated.
0 Karma

cpboothe
New Member

seems to be working. thank you for your help. Appreciated

0 Karma
Get Updates on the Splunk Community!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...