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

모든 응답

• 2009년 3월 19일 목요일 오전 3: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일 목요일 오후 2:15
  • 답변으로 제안됨Amit TankMVP, 중재자2009년 3월 19일 목요일 오전 6:06
  •  
  • 응답
  • 인용

   
• 2009년 3월 19일 목요일 오전 6: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일 목요일 오후 2:15Sandy Wood

   
  

  0

  로그인하여 투표
  Thanks again Amit. We gave it a try and it worked perfectly.

  ---

  Orange County District Attorney
  • 응답
  • 인용

   
• 2009년 3월 19일 목요일 오후 2:19Amit TankMVP, 중재자

   
  

  0

  로그인하여 투표
  My pleasure Sandy... :)

  ---

  Amit Tank | MVP - Exchange | MCITP:EMA MCSA:M | http://ExchangeShare.WordPress.com
  • 응답
  • 인용

   
• 2009년 7월 4일 토요일 오전 8: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일 월요일 오전 2:29
  •  
  • 응답
  • 인용

   
• 2009년 7월 5일 일요일 오후 5:03Andrey Zakharov

   
  

  0

  로그인하여 투표
  WOW
  
  Jim thx, it work Perfect!!! :)
  
  Thanks
  • 응답
  • 인용

   
• 2009년 7월 5일 일요일 오후 8: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

  • 응답
  • 인용