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