Exch2003: find unused distribution lists

Hi

What's the best way to find which of our distribution lists have not
had mail sent to them recently, say the last month? We have 3 Exch
2003 Std servers, single AD domain, 3 AD sites.

Thanks,
Graeme.

0
3/20/2007 8:03:00 AM
exchange.admin 57650 articles. 2 followers. Follow

6 Replies
351 Views

Similar Articles

[PageSpeed] 45

On 20 Mar 2007 01:03:00 -0700, graeme.donaldson@gmail.com wrote:

>Hi
>
>What's the best way to find which of our distribution lists have not
>had mail sent to them recently, say the last month? We have 3 Exch
>2003 Std servers, single AD domain, 3 AD sites.
>
>Thanks,
>Graeme.

Haven't got a way of telling you from Active Directory this
information. I recall there being non MS products (NetPro, Quest etc.)
that maintain this kind of information
0
mark7219 (5666)
3/20/2007 9:03:53 AM
Glen Scales MVP has a script, I belive there's others out there as
well, if you google.

Finding and Removing Empty Distribution Lists/Groups via a script
http://gsexdev.blogspot.com/2006/05/finding-and-removing-empty.html



James Chong (MVP)
MCSE | M+, S+, MCTS, Security+
msexchangetips.blogspot.com


On Mar 20, 4:03 am, graeme.donald...@gmail.com wrote:
> Hi
>
> What's the best way to find which of our distribution lists have not
> had mail sent to them recently, say the last month? We have 3 Exch
> 2003 Std servers, single AD domain, 3 AD sites.
>
> Thanks,
> Graeme.


0
jamestechman (1266)
3/20/2007 1:50:01 PM
I think he (and I) wanted to find DLs (with members) that hadn't been used in 
months.

"Jamestechman" wrote:

> Glen Scales MVP has a script, I belive there's others out there as
> well, if you google.
> 
> Finding and Removing Empty Distribution Lists/Groups via a script
> http://gsexdev.blogspot.com/2006/05/finding-and-removing-empty.html
> 
> 
> 
> James Chong (MVP)
> MCSE | M+, S+, MCTS, Security+
> msexchangetips.blogspot.com
> 
> 
> On Mar 20, 4:03 am, graeme.donald...@gmail.com wrote:
> > Hi
> >
> > What's the best way to find which of our distribution lists have not
> > had mail sent to them recently, say the last month? We have 3 Exch
> > 2003 Std servers, single AD domain, 3 AD sites.
> >
> > Thanks,
> > Graeme.
> 
> 
> 
0
JohnDoe1 (30)
3/21/2007 2:42:03 AM
"Jamestechman" <jamestechman@gmail.com> wrote:

>Glen Scales MVP has a script, I belive there's others out there as
>well, if you google.
>
>Finding and Removing Empty Distribution Lists/Groups via a script
>http://gsexdev.blogspot.com/2006/05/finding-and-removing-empty.html

Empty != Unused

Sometimes "empty" is good.

I have several "empty" groups that have hundreds of SMTP addresses
assigned to them. They come in handy when the network guys have their
routers, managed switches, and hubs sent email to addresses that don't
exist and use a from address in a domain that doesn't exist. Oh, and
adding "test@test.com" to that list takes care of a lot of junk, too.
:-)


-- 
Rich Matheisen
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:h.pott@getronics.com
Or to these, either: mailto:h.pott@pinkroccade.com mailto:melvin.mcphucknuckle@getronics.com mailto:melvin.mcphucknuckle@pinkroccade.com
0
richnews (7316)
3/21/2007 2:54:15 AM
"Mark Arnold [MVP]" <mark@mvps.org> wrote:

>On 20 Mar 2007 01:03:00 -0700, graeme.donaldson@gmail.com wrote:
>
>>Hi
>>
>>What's the best way to find which of our distribution lists have not
>>had mail sent to them recently, say the last month? We have 3 Exch
>>2003 Std servers, single AD domain, 3 AD sites.
>>
>>Thanks,
>>Graeme.
>
>Haven't got a way of telling you from Active Directory this
>information. I recall there being non MS products (NetPro, Quest etc.)
>that maintain this kind of information

Sirana's AppAnalyzer for Exchange does that too. But it takes a while
to gather enough history about usage before you can make a decision
between "never used" and "infrequently used".

-- 
Rich Matheisen
MCSE+I, Exchange MVP
MS Exchange FAQ at http://www.swinc.com/resource/exch_faq.htm
Don't send mail to this address mailto:h.pott@getronics.com
Or to these, either: mailto:h.pott@pinkroccade.com mailto:melvin.mcphucknuckle@getronics.com mailto:melvin.mcphucknuckle@pinkroccade.com
0
richnews (7316)
3/21/2007 2:55:38 AM
100% correct, John Doe.

Graeme.

On Mar 21, 4:42 am, John Doe <John...@discussions.microsoft.com>
wrote:
> I think he (and I) wanted to find DLs (with members) that hadn't been used in
> months.
>
> "Jamestechman" wrote:
> > Glen Scales MVP has a script, I belive there's others out there as
> > well, if you google.
>
> > Finding and Removing Empty Distribution Lists/Groups via a script
> >http://gsexdev.blogspot.com/2006/05/finding-and-removing-empty.html
>
> > James Chong (MVP)
> > MCSE | M+, S+, MCTS, Security+
> > msexchangetips.blogspot.com
>
> > On Mar 20, 4:03 am, graeme.donald...@gmail.com wrote:
> > > Hi
>
> > > What's the best way to find which of our distribution lists have not
> > > had mail sent to them recently, say the last month? We have 3 Exch
> > > 2003 Std servers, single AD domain, 3 AD sites.
>
> > > Thanks,
> > > Graeme.


0
3/22/2007 6:16:50 AM
Reply:

Similar Artilces:

Distribution group problem
I have over 700 address contacts that have been "tagged" into various categories. I know how to set up a new distribution group. However, when I choose "select names" the names from my list apear as first name, last name instead of last name , first name. This makes it almost impossible to scroll up and down looking for the name I want to select and add to my distribution group. Please advise of any suggestions. In Outlook XP, select Tools, Options, then click Contact Options. Change the Default File Order to Last, First. "Randal" <randal.langley@...

named cell list
Could some kind person please tell me how to list the named cells of a XL 2007 spreadsheet in a worksheet. I have just upgraded from 2003 where I used the Lotus help but cant find it in 2007. many thanks. On Sat, 29 Aug 2009 11:45:22 +1000, "Keith" <oldpos@internode.on.net> wrote: >Could some kind person please tell me how to list the named cells of a XL >2007 spreadsheet in a worksheet. I have just upgraded from 2003 where I used >the Lotus help but cant find it in 2007. > >many thanks. Have a look here: http://rhftech.com/hd/excel-print-a-list-of-n...

Scotiabank not listed in Canada-version Microsoft Money 2006
I am located in Toronto, Ontario. I just bought Microsoft Money 2006- Canada version today (11/16/2006). To my amazement . . . SCOTIABANK . . . which is one of the BIGGEST banks in all of Canada is *not listed as an bank* from which I can download my checking account data directly into Microsoft Money. Scotiabank tech support says I have to contact Microsoft. How can I ad Scotiabank to MM . . . for AUTOMATIC downloads (I don't want to have to manually download data each time!) Why there#W$#@$ isn't Scotiabank on the list of banks? Help Thanks Jim (now located in Toronto) ...

Word doc. list to excell worksheet, how to?
Its great to be able to use a chart/worksheet made in excel and transfer it to a word doc. but what I really need now is a solution to how to transfer a word doc. list into a brand new worksheet. Please help. You may be able to save it as a text file and then import into Excel. It's not clear what you have in your word doc however. HTH, Barb Reinhardt "lulilo" wrote: > Its great to be able to use a chart/worksheet made in excel and transfer it > to a word doc. but what I really need now is a solution to how to transfer a > word doc. list into a brand new work...

Hide Membership in Hidden Distribution Lists
Hi there. I've got a question from one of the managers regarding showing membership in a Hidden Distribution List. The DL is hidden from the GAL, using the checkbox. We have also set the Hide Membership thru Exchange Tasks. However if you open Properties of a user, Member Of tab, you can see they're in that Hidden DL. (although if you go properties of the DL you don't see all the members). Is there a way to not display that ? And I can't check Hide from Address Book on the user either, because then they don't show up in the GAL at all. Anybody know ? ...

Advanced Find #2
Issue: The security role has been set so that it read for user. User can still see records created by other users. To recreate Set the security role on core records so that read is only for userr. Apply this role to a user. Do an advanced find. Find in activities: Field: Created by Condition: Does not equal Type:User (here you should only be able to select the current users) Enter go and the list of activities for everyone in the whole organization is return. It is my understanding that this should not occur with the role set with the core record to user. I would expect that there be no...

Problems with distribution groups in Exchange 2003
I have a small business server 2003 with SP1 for both windows and exchange server installed. It recieves mail for two domains. cleevelink.co.uk and cleevehillnursing.co.uk. There are two distribution groups setup both called info one for each domain. The problem occurs when mail is sent to info@cleevehillnursing.co.uk it is routed to the correct members, however mail sent to info@cleevelink.co.uk is routed to the members of cleevehillnursing.co.uk not the cleevlink.co.uk Any thoughts greatly recieved. On Sat, 26 Nov 2005 08:05:02 -0800, "Kevin Cook" <KevinCook@discussio...

Cannot find share.exe
I'm trying to assist a friend with re-installing Excel. He has a old version of Excel (doesn't know for sure - possibly 97) and is running Windows ME. He previously had this installed but ended up reformatting his system. He's now going back trying to re-install his software. He starts to install Excel using the licensed installation disks but gets an error, "Cannot find share.exe on system". Can anyone tell me how to fix this? Is it just a matter of getting a copy of this file? Where does it belong? Etc. Any advice would be appreciated -- Message posted...

I am setting up newsgroup in outlook but can not find the "news" .
I was told to drag the "news" command to the category "go" to set up news group...but I can not find the command "news"......can any one help please ? Thanks clement Look in tools, customize... Then got to the Programs tab in Control Panel | Internet Options and change the default newsreader to Outlook Express. If OE prompts you to make it your default newsreader the next time you launch it, click the "Don't ask me again" box and then click the No button. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours ...

adding data from one sheet to another sheet as a dropdown list bo.
I want to add a drop-down list box on a seperate worksheet that my data is on On this other sheet that holds your data, select the range that you want to use in the Data Validation list and name it via Insert - Name - Define and type in the name, like "MyList" without the quotes. Then in the cell where you want the Data Validation cell, click Data Validation, select List, and type "=MyList" without the quotes. Done. HTH Otto "gatorguy" <gatorguy@discussions.microsoft.com> wrote in message news:F7BB75E8-255D-446A-BE4B-D57E3204DF55@microsoft.com... &g...

Re: clicking on single option dropdown list in IE7 causes browser to c
It looks like any password manager will cause this issue - I am using Bio-Cert and it handles the passwords for all applications - I tried disabling it in IE7 version.13CO but did not resolve issue. Once I uninstalled the application and removed all instances in the registry, I was able to correct the Drop Down issue in IE7 version.13Co and 11.CO Hope this helps someone. -- TRamassar ...

copying list items
Ok, I have a list of names on my first sheet (list) and several sheet after it (1,2,3,etc). How do I get the first value in the list to cop into sheet 1, the second value to copy into sheet two and the thir value down to go into the thrid etc..? Say into cell C3. Any Ideas welcome Cheers Hayle -- Hru4 ----------------------------------------------------------------------- Hru48's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=2489 View this thread: http://www.excelforum.com/showthread.php?threadid=47143 ...

Entourage EWS - Send on behalf
> Ce message est au format MIME. Comme votre programme de lecture de courriers ne comprend pas ce format, il se peut que tout ou une partie de ce message soit illisible. --B_3348219359_10830351 Content-type: text/plain; charset="US-ASCII" Content-transfer-encoding: 7bit Hello, Our Entourage users want to send email on behalf of a distribution group, AD permission has been set and it work just fine with Outlook 2007. Once we add the distribution group in the delegated accounts in entourage 2008, it appears as (unconnected) in the left frame and user can't send ...

Displaying buddy list on a dialog
Hi experts I am new to MFC programming so please help me out Actually i have a dialog bases application and on that i want to display a list which consists of groups and within that group there is list of people in that group.I want to display it as that the groups should have an + icon and if i click on it it becomes minus and the list of people is displayed but i want to diplay in a vertical fashion,one below the other,all the groups and people in one vertical line,not like in CTreeCtrl in which case it is in tree like format..Something like (-)Personal Anna John Rahul (+)Home (-)O...

related records in advanced find doesn't work
Hello, I have an advanced find where I am trying to bring in some information from the 'related to' lead on an appointment. No matter what lead field I select, no data is returned for that column. Has anyone seen this behavior or had any issues with this? Thanks! The 'related to' fields work as a seach filter criteria so you are specifying here which records to include in your search. The 'edit columns' option dictate the data columns visibly returned from the query. Regards Marion "jpop" wrote: > Hello, > > I have an advanced find w...

using vlookup to find exact match
Hi, I have two spreadsheets with same field called IDs. I want to know whether the IDs in the ID column of the first sheet is in the ID column of the second. I want to create a new column on the first sheet to return Yes/No depending on the result. I think I could use vlookup formula but have no idea how. Can anyone help me? Thank you! -- Message posted via http://www.officekb.com Janice One way: =IF(ISNA(VLOOKUP(A1,Sheet2!A:A,1,FALSE)),"no","yes") and drag down. Assumes your ID column is column A on both sheets. Regards Trevor "Janice Lee via OfficeKB.com&...

CRM List Web Part
Hi, I am currently setting up sharepoint to display CRM contracts for engineers. I have built the sharepoint site, and installed and configured the List Web Part application, and now I have a page with a view of all our current contracts on, which i have filtered down using a new view in CRM. I would like to give people the ability to search via a different field than the Primary Field (in this case contract name is the primary field, and i would like to search by a newly created field.) Does anyone know how i can configure this? Ideally, I would only like to allow the option to searc...

remove small list from large list
I have two mail lists on excel. The first has 16,000 names, the second has about 6,000. I need to remove the 6,000 from the 16,000 as they all appear in the big list as well. How do I extract those 6,000 entries from the larger list? My expected result is a mailing list with 10,000 names. Chip Pearson has some techniques at: http://www.cpearson.com/excel/duplicat.htm Howie J. wrote: > > I have two mail lists on excel. The first has 16,000 names, the second has > about 6,000. I need to remove the 6,000 from the 16,000 as they all appear > in the big list as well. How do ...

Create two related list box
hi all, I don't know if I can asking questions regarding Access in this foru or not, but hopefully can get some answers. In my Access form, I want to create 2 list box where the first list bo with 3 sections (morning, afternoon, evening) and the second list box i for the time(7-8am, 8-9am, 9-10am, 10-11am, 11-12pm, 12-1pm,.......). So, when the user choose "morning" under the sections list box, the the choices he has to choose from are 7-8, 8-9, 9-10, 10-11am. Afte the time is chose, some information related are displayed out. How thi can be done :confused: ? I hope someone...

A way to list which backorders are ready to transfer to order
Hi, When items are received in PO (via a Receiving Transaction Entry) and then posted, one of the reports automatically generated is "Back-Ordered Items Received". That is good and tells us which backorders can now be fulfilled. However, what if that paper report is not printed, or it is lost? Is there another Inquiry or Report that can tell us again what was on that report? Also - is there an automated SOP function that would allow us to select only "fulfillable" (ie. there's stock on the items now) backorders and transfer them to orders? I appreciate your com...

Advanced Find Result Set
Hi, The result set from an advanced find query over multiple entities resturns the same record multiple times. For example: A user is looking for accounts, but these accounts must met some criteria of a related entitie. The results shows the same account multiple times, because the criteria of the related entity where met multiple times. It looks like the 'Group by' of the query is not working. Any ideas how to solve this?? KR, Mirella ...

find simillar variables in 2 different sheets
i have 2 different sheets with the same indentifier numbers am trying to figuer out how to get the same numbers "mohammed" wrote: > i have 2 different sheets with the same identifier numbers > am trying to figure out how to get the same numbers Just hazarding a hunch that what you're after is something to do with or which can be done with either VLOOKUP or INDEX/MATCH Try Debra Dalgleish's nice coverage on VLOOKUP or INDEX/MATCH at her: http://www.contextures.com/xlFunctions02.html VLOOKUP http://www.contextures.com/xlFunctions03.html INDEX/MATCH There&#...

finding unique records
I have a column (B) that can be anywhere from 1 to several hundred rows. In this column can be listed any three digit Project #, up to five unique Project numbers in this column. Some may be listed many times. There may be less than 5 unique records, but no more. Then in a separate summary table to the right I have expenses summed in 5 columns (J,K,L,M,N), each of the five columns corresponding to the unique records in B. If there are only 3 unique Project numbers among the 100 or so records in Col B, then only J,K,L will show summary figures. I'd like the header cells for columns ...

How do I find a lost Excel file in Windows XP
Due to problems with new Windows XP, I lost an excel file. The shortcut still points to the location of the file, but is unable to find any file with that name. I have tried a search function but still am unable to find the file Double-check your recycle bin, in case it ha been deleted. Try using partial filenames to search, such as filename.*, file*.* or *.xls in case the file has somehow been renamed. If this fails, try taking the enquiry to a Windows XP newsgroup as this is not an Excel-specific problem. -- Ian -- "m2babs" <m2babs@discussions.microsoft.com> wrote in m...

Excel Lists
A few months ago client requested I create an "Excel Database" by which she meant an Excel list. Recently she sent it back for help because the insert row (the one with the asterisk) at the bottom disappeared. For the life of me I cannot figure out what the problem is. I have not been successful in getting it to reappear either. Anyone have any advice? You need xl2003+. Select your range data|List parksgirl@gmail.com wrote: > > A few months ago client requested I create an "Excel Database" by > which she meant an Excel list. Recently she sent it back for...