It won't be unduplicated, and it will have extra stuff you'll have to filter out, but

   query * for *@*

will produce a report of all subscribers to all lists, when issued with site postmaster authority.  The report may be returned in multiple emails, in my case there appears to be a size limit around 700kb.  You would want to select the lines beginning with "Subscription options for" and then sort that to remove dupes.  Some of those lines will have the name of the subscribed list following the address, and some won't - the report appears to impose a line-length limit.

Alternatively, if you use the super/sub-list idea already, just save the logfile for one of those distributions and extract the addresses from there - parsing them out of that would be easier than programmatically interpreting the QUERY response.  This would miss those who are NOMAIL on every list, I suspect.

>>> [log in to unmask] 02/22/03 08:37PM >>>
[Posted to LSTSRV-L and LSTOWN-L.]

Colleagues,

I have a need to easily obtain all subscribers for all lists, without
duplicated addresses (such as where a given subscriber is subscribed to two
or more lists).  The end result needs to be a single listing of email
addresses and, optionally, corresponding names, without duplicates,
representing all subscribers of all lists.

Problem:  With 150+ lists, it is inconvenient and time-consuming to issue
the typical REVIEW command for each list, and then merge and purge to
delete duplicates.

Having read all the manuals and scanned the archives, and having posted
this question some weeks ago, I am fairly well convinced that there is no
ready means to accomplish this task.  For example, for security reasons, as
I recall, LISTSERV does not have a command to do what I want.

I do plan to implement DBMS and utilize MS SQL 2000 Server as the
datastore.  Indeed, I have set up a test list that accomplishes
this.  However, given the demands on my time, it will likely be several
weeks or months before I can migrate all existing lists to SQL 2000.  At
that point I will have a number of options for pulling data out of the
database -- problem solved.  Until then, though, I find myself spending
considerable time getting the simple end-result I need:  a single listing
of subscriber email addresses for all lists, without duplicates.

Anything I'm not considering?  Is there some simple thing I'm missing?

Steve