Solved: Calculate active Sprint

Nith1 · ‎03-18-2021

Hi,

How to create a query to show Active Sprint(JIRA) with Start and end date in my splunk dashboard.
I dont have fields with Sprint details
Fields which i have are
IssueCreated
IssueUpdated
ProjectID
IssueType eg; story,bug , task

Status eg:,to do,done, inprogress

Can someone help to create a splunk query for the same

scelikok · ‎03-19-2021

Hi @Nith1,

You can use below as a sample;

| search NOT Status="done"
| stats earliest(IssueCreated) as IssueCreated latest(IssueUpdated) as IssueUpdated by ProjectID IssueType

If this reply helps you an upvote and "Accept as Solution" is appreciated.

View solution in original post

scelikok · ‎03-19-2021

Hi @Nith1,

You can use below as a sample;

| search NOT Status="done"
| stats earliest(IssueCreated) as IssueCreated latest(IssueUpdated) as IssueUpdated by ProjectID IssueType

If this reply helps you an upvote and "Accept as Solution" is appreciated.

Calculate active Sprint

fields

lookup

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

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

Deep Dive: Accelerate threat investigation with Splunk’s AI Assistant in Security

Announcing Modern Navigation: A New Era of Splunk User Experience

Detection Engineering Office Hours: Real-World Troubleshooting & Q&A

Join the Conversation