Jira Hygene

// Table of Epics 
Jira
| where issueTypeName == "Epic"
| project EpicKey = key, EpicSummary = summary);

//Oldest epics
Jira
| where projectKey == "MS"
| where statusCategoryName != "Done" and statusCategoryName != "Complete"
| extend openTime = now() - created
| project key, summary, statusCategoryName, openTime
| order by openTime desc 

//Bugs, tasks, subtasks without a parent
Jira
| where issueTypeName != "Epic"
| where parentKey == ""
| project key, summary, issueTypeName, assigneeDisplayName

Story point analysis

//Story points per epic
let _startTime = ago(90d);
let _endTime = now();
let Epics = Jira
| where issueTypeName == "Epic"
| where updated between (_startTime  .. _endTime)
| project EpicKey = key, EpicSummary = summary;
Jira
| where projectKey == "MS"
| where updated between (_startTime  .. _endTime)
| join kind=leftouter Epics on $left.parentKey == $right.EpicKey
| summarize StoryPointTotal = sum(storyPoints) by EpicSummary
| sort by StoryPointTotal

//Story point per dev
let _startTime = ago(90d);
let _endTime = now();
Jira
| where updated between (_startTime  .. _endTime)
| where assigneeDisplayName != ""
| summarize StoryPointTotal = sum(storyPoints) by assigneeDisplayName

//Story points per dev per epic
let _startTime = ago(90d);
let _endTime = now();
let Epics = Jira
| where issueTypeName == "Epic"
| where updated between (_startTime  .. _endTime)
| project EpicKey = key, EpicSummary = summary;
Jira
| where projectKey == "MS"
| where updated between (_startTime  .. _endTime)
| join kind=leftouter Epics on $left.parentKey == $right.EpicKey
| summarize StoryPointTotal = sum(storyPoints) by EpicSummary, assigneeDisplayName
| sort by EpicSummary
| project assigneeDisplayName, EpicSummary, StoryPointTotal