Query open/aged tickets more than 1 month old

[Ula Fitisemanu]

How do I query all open/aged tickets that have breached SLA?

[Evgenii · Accepted solution]

Hi, @Ula Fitisemanu 

Welcome to Atlassian Community!

Your question isn't entirely clear, as different teams measure SLA in various ways — for example, by time spent in a specific status, by time since the last update, or using a dedicated SLA plugin. If you're using Jira Service Management , SLA tracking is already built in.

If you just want to filter issues that haven’t been updated in over 30 days, you can use the following JQL:  project = YOUR_PROJECT AND updated < startOfDay(-30)

Jira Service Management can track, that:

SLA is ok

"Time to resolution" = completed()

or breached

"Time to resolution" = breached()

you can track, by time left before breaching:
"Time to resolution" < remaining ("30d")

but you can't check, how long ago SLA was breached.

For other types of SLA tracking, please provide more details about your setup and what exactly you're trying to measure.

[Dwight Holman · Accepted solution]

I'm not entirely clear what you want to achieve - can you expand your question? What do you want to see...

• open tickets created > 1 month ago
• open tickets not updated for > 1 month
• open tickets exceeding SLA by more than 1 month

Perhaps the documentation on creating JQL queries for JSM would help:

https://support.atlassian.com/jira-service-management-cloud/docs/write-jql-queries-for-slas/

[Ula Fitisemanu]

Thanks for the link, will check it out.

[Alina Kurinna _SaaSJet_]

Hi @Ula Fitisemanu 

If you want an easy way to find open tickets that are older than one month and have breached SLA, I recommend trying SLA Time and Report — an app developed by my team.

With it, you can:

• Filter and sort issues by SLA status (Met / Exceeded), creation date, assignee, project, priority, and more — all in one place
• Instantly identify aged tickets with breached SLAs using the real-time SLA Grid
• Visualize SLA performance with charts and add widgets to your Jira dashboard
• Use flexible filters and sorting — without writing complex JQL

It’s a convenient way to monitor overdue issues and take action quickly.

I hope this helps! If you have any questions, feel free to reach out! 

Regards!

[Ula Fitisemanu]

Thanks very much for your response, I'll certainly try this.