Search all issues with a given transition to a status

i want to fetch all issues that have a transtion to a given status.
The basic way would be searching all issues that a re not in the target status. and then get the transitions per issue and filter to any, that include a transtion to status X.

This is slow and many api calls. What other ideas do you have?

I dont have access to automation

Project + Issue Type are associated with a Workflow, which contains transitions.

Use Bulk Get Workflows to get the workflows for the Projects + Issue Types you are interested in:

https://developer.atlassian.com/cloud/jira/platform/rest/v3/api-group-workflows/#api-rest-api-3-workflows-post

Analyze the “transitions” returned to see if they contain your target transitions.

Then you know which projects + issue types to filter for in your JQL. Optionally exclude issues that already have the target status.