[Search for users] [Overall Top Noters] [List of all Conferences] [Download this site]

Conference iosg::all-in-1

Title:ALL-IN-1 (tm) Support Conference
Notice:Please spell ALL-IN-1 correctly - all CAPITALS!
Moderator:IOSG::PYECE
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

2670.0. "Identify least frequently used system distrib lists" by GIDDAY::LEH () Fri May 09 1997 06:29

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.RTitleUserPersonal
Name
DateLines
2670.1IOSG::PYEGraham - ALL-IN-1 Sorcerer's ApprenticeFri May 09 1997 09:538
    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.2What I doTAY2P1::HOWARDWhoever it takesFri May 09 1997 17:4426
    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