| Title: | ALL-IN-1 (tm) Support Conference | 
| Notice: | Please spell ALL-IN-1 correctly - all CAPITALS! | 
| Moderator: | IOSG::PYE CE | 
| Created: | Fri Jul 01 1994 | 
| Last Modified: | Fri Jun 06 1997 | 
| Last Successful Update: | Fri Jun 06 1997 | 
| Number of topics: | 2716 | 
| Total number of notes: | 12169 | 
Are there ways of determining usage frequency of all system distrib lists ? One customer is having 600+ lists and would like to delete as many as possible those least frequently used ones. Thanks Hong
| T.R | Title | User | Personal Name | Date | Lines | 
|---|---|---|---|---|---|
| 2670.1 | IOSG::PYE | Graham - ALL-IN-1 Sorcerer's Apprentice | Fri May 09 1997 08:53 | 8 | |
|     I suppose you could put an ACL on each one and audit successful access,
    then analyse the audit log. I suspect that would make the system a
    little slow though...
    
    Perhaps a customisation to the address header might do it you could
    insert it at a point before the name was expanded. Something based on
    one of the previously discussed customisations to prevent SUBSCRIBERS
    being used might be a start.
 | |||||
| 2670.2 | What I do | TAY2P1::HOWARD | Whoever it takes | Fri May 09 1997 16:44 | 26 | 
|     I think a good starting point is to validate the DL's.  Check the
    editor field and the lists. What I have done in the past is to look for
    empty lists or lists whose editor is no longer valid, or which have no
    valid members.  You would be surprised how many you can find that are
    of no use to anybody.  If they haven't been edited in several years,
    they probably haven't been used.
    
    What I do is to rename the suspicious lists to a subdirectory and see
    if anybody complains.  Usually they don't.  At one site, we developed a
    set of rules for cleaning up:
    
    Size > 0 with valid editor:   Leave alone
    Size = 0 with invalid editor: Delete the list
    Size = 0 with valid editor:   Send mail to editor, ask if needed.
    Size > 0 with invalid editor: Rename - see if anybody complains
    
    This got rid of about 80% of the lists, and very few people complained.
    On the empty lists with a valid editor, we told them to add their own
    name.  
    
    I wrote procedures to make these determinations, but I don't have them
    handy, but I  will look around. Basically, you want to check the names
    against the profile and delete any local ones that don't exist.  This
    reduces a lot of lists to no names. 
    
    Ben
 | |||||