Resources for IT Professionals > 論壇首頁 > Admin > How can I add members to a new distribution group from a CSV file?

發問

How can I add members to a new distribution group from a CSV file?

2009年3月18日下午 05:08Sandy Wood

0
登入以投票
I'd like to import users from a CSV file to a Distribution Group. I've exported the members of an exisiting Distribtution Group to the CSV and I basically want to clone it with a different name. I can't get the Powershell to work...

I thought it should look like

Import-Csv -Path D:\ml.csv | ForEach-Object {Add-DistributionGroupMember....this is where I'm lost....
Orange County District Attorney
- 回覆
- 引述

解答

2009年7月4日下午 11:17Jim McBee - Exchange MVPMVP

1
登入以投票
Exchange Server 2003 does not have this cmdlet or an similar function. If you want to use PowerShell and you are using Exchange 2003, you could probably use the Quest Active Directory Powershell tools
http://www.quest.com/powershell/activeroles-server.aspx

You would need to install the PowerShell and then install the Quest tools. Then take a look at the Add-QADGroupMember cmdlet that Quest provides.
Jim McBee - Blog - http://mostlyexchange.blogspot.com
- 已標示為解答Amit TankMVP, 版主2009年7月6日上午 02:29
- 回覆
- 引述
2009年3月19日上午 03:18Amit TankMVP, 版主

0
登入以投票
Hey Sandy,

Try below cmdlet to import from CSV file...

Import-CSV FileName.csv | ForEach {Add-DistributionGroupMember -Identity "DG Name" -Member $_.Name}

In filename.csv file should have a column Name and the values must be in anyone of below format to add them as a member...
GUID distinguished name UPN LegacyExchangeDN Domain\Account Name SMTP Address

Add-DistributionGroupMember
http://technet.microsoft.com/en-us/library/bb124340.aspx

Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
- 已標示為解答Sandy Wood 2009年3月19日下午 02:15
- 已提議為解答Amit TankMVP, 版主2009年3月19日上午 06:06
- 回覆
- 引述

所有回覆

2009年3月19日上午 03:18Amit TankMVP, 版主

0
登入以投票
Hey Sandy,

Try below cmdlet to import from CSV file...

Import-CSV FileName.csv | ForEach {Add-DistributionGroupMember -Identity "DG Name" -Member $_.Name}

In filename.csv file should have a column Name and the values must be in anyone of below format to add them as a member...
GUID distinguished name UPN LegacyExchangeDN Domain\Account Name SMTP Address

Add-DistributionGroupMember
http://technet.microsoft.com/en-us/library/bb124340.aspx

Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
- 已標示為解答Sandy Wood 2009年3月19日下午 02:15
- 已提議為解答Amit TankMVP, 版主2009年3月19日上午 06:06
- 回覆
- 引述
2009年3月19日上午 06:48James-LuoMSFT, 版主

1
登入以投票

Good job, Amit

I tested in the lab

Step 1: Export Value of the user object you want to add into DG (Distribution Group)

Csvde -r objectclass=user -d "OU=ExTeam,DC=contoso,DC=com" -l "Name" -f C:\member.txt

Step 2: Import the file as Amit said

import-csv C:\member.txt | foreach {add-distributiongroupmember DGName -member $_.Name}

Step 3: Verify the result via EMC or EMS
- 回覆
- 引述
2009年3月19日下午 02:15Sandy Wood

0
登入以投票
Thanks again Amit. We gave it a try and it worked perfectly.
Orange County District Attorney
- 回覆
- 引述
2009年3月19日下午 02:19Amit TankMVP, 版主

0
登入以投票
My pleasure Sandy... :)
Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
- 回覆
- 引述
2009年7月4日上午 08:19Andrey Zakharov

0
登入以投票
Hi Amit,
how can i do this on exchange 2003?
I now that add-distributiongroupmember - is exchange 2007 cmdlet and is don't work on 2003.
10x
- 回覆
- 引述
2009年7月4日下午 11:17Jim McBee - Exchange MVPMVP

1
登入以投票
Exchange Server 2003 does not have this cmdlet or an similar function. If you want to use PowerShell and you are using Exchange 2003, you could probably use the Quest Active Directory Powershell tools
http://www.quest.com/powershell/activeroles-server.aspx

You would need to install the PowerShell and then install the Quest tools. Then take a look at the Add-QADGroupMember cmdlet that Quest provides.
Jim McBee - Blog - http://mostlyexchange.blogspot.com
- 已標示為解答Amit TankMVP, 版主2009年7月6日上午 02:29
- 回覆
- 引述
2009年7月5日下午 05:03Andrey Zakharov

0
登入以投票
WOW

Jim thx, it work Perfect!!! :)

Thanks
- 回覆
- 引述
2009年7月5日下午 08:39Jim McBee - Exchange MVPMVP

0
登入以投票
The Quest tools are great. I use them on all of my E2K3 servers (that I wish I could migrate to E2K7) :-)
Jim McBee - Blog - http://mostlyexchange.blogspot.com
- 回覆
- 引述
2009年7月6日上午 11:24anil-rocks

0
登入以投票
Exchange Server 2003 does not have this cmdlet or an similar function. If you want to use PowerShell and you are using Exchange 2003, you could probably use the Quest Active Directory Powershell tools
http://www.quest.com/powershell/activeroles-server.aspx

You would need to install the PowerShell and then install the Quest tools. Then take a look at the Add-QADGroupMember cmdlet that Quest provides.
Jim McBee - Blog - http://mostlyexchange.blogspot.com

Hi Amit,

I have 100+ DL's & need to add 15-30Users a memeber of it, can you please let me know how do i achieve this with VB script & a input file as csv

The CSV file will be GroupName, DN,GroupType, Memebers (User Sam A/c) with clon seperated.

Thanks

Rocks
- 回覆
- 引述