/gratuitous comment/
You've discovered the DL management is one of the many short-comings of
Microsoft's Most Poorly Designed Management Interface Ever: Exchange Server
Administrator. Viva MMC (so far).
/end gratuitous comment/
Not easily, in my opinion.
But here's my approach for 5.5 environments..
First you need some item that is common among the 200 HR mailboxes that you
can use to segregate them. For instance, have you pre-populated a field like
"office" or "department", do you use CA's like "HR", anything like that?
I'll presume you do.
So, to proceed..
1. Open a template CSV and add the "Member" field.
2. Run a DirExp to the template CSV--be sure to select each of the three
object types.
3. Open the resultant CSV in Excel.
a. Notice the DL records under the Obj-Class field.
b. Find the alias name of the DL from which you wish to remove
mailboxes.
c. Set Autofilter as "custom" to find only instances of "[alias name
of DL]"
d. Copy resultant view into a new workbook--Be certain to grab the
first row (header)
e. Replace all records under the Member field with "~DEL" (sans
tilde, 'natch..)
f. Save the file as, um, PurgeHR_Imp.csv.
4. Run a append DirImp of the PurgeHR_Imp.csv
If bad things happen, you always can run a DirImp of your original DirExp to
restore membership.
If you find instances of mbx's w/multiple DL membership (made apparent by a
separator character--like %--between the DL alias names), use Find/Replace
in Excel to remove instances of DL alias name from target mbxs, then run an
Overwrite DirImp. Nix use of ~DEL, though.
Btw, there are any number of DL mgmt utils available. But I'm cheap, and I
know Excel and Access and exchsrvr pretty well.
-----Original Message-----
From: Chris H [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, August 27, 2002 12:35 PM
To: Exchange Discussions
Subject: Bulk Removal from DL
Apologies if this hits twice . . . I have not seen it on either email addy I
am subscribed with . . .
We have a DL for every user that has a mailbox. Now they want me to take out
everyone in, say, Human Resources which is about 200 people. Is there a
bulk, or scripted way to do this based on department name?
TIA.
Chris
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
_________________________________________________________________
List posting FAQ: http://www.swinc.com/resource/exch_faq.htm
Archives: http://www.swynk.com/sitesearch/search.asp
To unsubscribe: mailto:[EMAIL PROTECTED]
Exchange List admin: [EMAIL PROTECTED]
