This solution outlines how to create a query that will show all failed Recurring Gifts, regardless of which Blackbaud Sphere initiative they were made in.
1. Go to Control > Query 2. Click New and select Payments Query 3. Expand Payments > Payment Information 4. Click Payment Source Type and click Add 5. Choose Equals and Recurring Gift 6. Click OK 7. Click Payment Status and click Add 8. Choose Equals Failed 9. Click OK 10. Click Next 11. Choose the information you want to output in the query results 12. Click Finish