Is there a quick way to find campaigns with a particular status?

Yes, the copy status report includes filters which enable you to control the campaigns reported on screen. If you do not have access to J-ET, your salespoint rep can check this for you.