UBB.threads PHP Forum Software Community Forums Resources and Customizing Admin Zone PayPal batch file for ID'ing expired and failed payment subscriptions?

I've been using automatically renewing annual subscriptions for access my forum for over a year.

I'm looking for an easier way to deal with canceled subscriptions (which did not auto renew) and subscriptions where the renewal payment failed.

Anyone know if there is a way to run a batch file that say finds everyone who successfully made a subscription payment in November 2007 but did not successfully make a subscription payment in November 2008?