The mailing list for listmasters using Sympa

[Pat Allen <address@concealed>]

DUH - never mind. All I need to do is look in the spool/moderation directory.  (Some days it seems like I should stay in bed....)

---

From: "Pat Allen" <address@concealed>
To: address@concealed
Sent: Thursday, November 12, 2015 8:58:44 AM
Subject: List of moderated messages

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