The mailing list for listmasters using Sympa

[Pat Allen <address@concealed>]

Hi everyone,

I'm hoping that somebody out there has already solved this problem. I need to get a report of all the lists that I have on my server that have messages waiting for moderators to approve or reject.

Is there a simple database query that I can run that will give me the information or can I just do a recursive query for each list?

Any hints will be greatly appreciated.

Pat