I don't think this can be automated, but I'm not sure I really understand what you want to do.
It's possible to create a plan that will show you which pages are on the same side of the same sheet on your press which will helpp you organize how you place spot or process colors to minimize the number of plates required to output a job. It's easiest, I think, to lay out such a chart by hand, as it depends on the number of pages in your "signature," or how many pages fit on a single sheet of paper.
This screen shot is a chart I made for a school publication to show then where they could place color to have only one set of CMY plates in an eighty-page document printed in five 16-page signatures (ten sides and ten sets of plates, total, and they wanted color only on one side of one sheet). I think you can see the pattern well enough to make a similar chart for other page counts:
Thanks, I'll do it manually then. I'll se the separations and do it one-by-one.
If you just want a list of pages where classes of colors -- cmyk or spot, but not specific colors are used, setting up some custom prefligh profiles that disallow those types of colors would be a fast way to find them.