Calculate active Sprint

[Nith1]

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 · Accepted solution]

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