I assumed you were the owner / status manager for all the projects. I am not sure of a way to view this information across all PM’s. My thoughts are a PSI tool to query the draft database, since this houses all non-published project info. Perhaps Project Experts or some other place has written something like this.