Stephen C. Nill wrote:
> [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?

I guess if I needed to do that I'd just write a shell script that did a
LIST command to get all the listnames, then have it do "review all" for
all of them, then have it clean it up and dedupe it.

Regards,
Al Iverson

--
Al Iverson -- http://www.radparker.com -- Minneapolis, Minnesota, USA
Support Minnesota Jazz -- Disclaimer: All of my opinions are mine alone.