Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!
Copy members from one D.L. in one domain to another D.L. in another domain
Hello,
I have a CSV file with a list of distribution groups from both the new domain and the old domain. They are mapped. The CSV file contains two columns (Source, Target). I'd like to copy the members from the source domain to the target domain. The members already have the proxy addresses from the source domain so it should be possible to match a user as well based on one of the proxy addresses. Has anyone done this and/or does anyone have a sample script to get me started? I'd like to do this in Powershell.
Thanks
I have a CSV file with a list of distribution groups from both the new domain and the old domain. They are mapped. The CSV file contains two columns (Source, Target). I'd like to copy the members from the source domain to the target domain. The members already have the proxy addresses from the source domain so it should be possible to match a user as well based on one of the proxy addresses. Has anyone done this and/or does anyone have a sample script to get me started? I'd like to do this in Powershell.
Thanks
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
You can do this using CSVIDE (that's how I typically do it). Here's an example on how to do it: http://exchangeis.com/blogs/exchangeis/archive/2005/07/14/35.aspx
If you have a list in following format then try this PS script..
Sample CSV..
Sample CSV..
DGName,Proxy
TestDG,test@test.com
TestDG,test1@test.com
TestDG,test2@test.com
TestDG,test3@test.com
TestDG1,test@test.com
TestDG1,test3@test.com
TestDG1,test4@test.com
Import-CSV FileName.csv | ForEach {
$user = Get-Mailbox $_.Proxy
Add-DistributionGroupMember -Identity $_.DGName -Member $user.Name}
Thanks for both of your responses. I may have not been clear in my question.
I have a mapped file with the old name (Group1) and new name (Group345). The mapped file contains two columns. Source, Target.
From this I want to look at the Source domain, find the members proxy address and find the matching proxy address on the target domain, and add those users to the D.L.
There issue here is that both the D.L., and the Users have been renamed in the new domain, so looking up the members by proxy address instead of the DN should make finding a matching user easier.
I hope I'm explaining myself correctly.
Thanks
I have a mapped file with the old name (Group1) and new name (Group345). The mapped file contains two columns. Source, Target.
From this I want to look at the Source domain, find the members proxy address and find the matching proxy address on the target domain, and add those users to the D.L.
There issue here is that both the D.L., and the Users have been renamed in the new domain, so looking up the members by proxy address instead of the DN should make finding a matching user easier.
I hope I'm explaining myself correctly.
Thanks
$users = get-distributiongroupmembe
foreach ($user in $users)
{
Add-DistributionGroupMembe
}
I have the above powershell code so far, with just a single DL, but am receiving the following error;
--------------------------
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
--------------------------
foreach ($user in $users)
{
Add-DistributionGroupMembe
}
I have the above powershell code so far, with just a single DL, but am receiving the following error;
--------------------------
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "System.Collections.ArrayL
ayList" to type "Microsoft.Exchange.Config
eter]".
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
--------------------------
Change the variable inside the foreach to $user
is this domains from same forest?
$users = get-distributiongroupmember 'GlobalHSM' -domaincontroller w2342o.xthy.com -Credential $username | Select-Object primarysmtpaddress
foreach ($user in $users) {
Add-DistributionGroupMember -Identity '&$HYMT_GlobalHSM' -Member $user -DomainController chicago.mglobal.com
}
is this domains from same forest?
Thanks! That got me a little further with a different error.
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=john
serialized.Selected.Micros
rGroupIdParameter`1[Micros
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=cony
ed.Selected.Microsoft.Exch
Parameter`1[Microsoft.Exch
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=mary
rialized.Selected.Microsof
roupIdParameter`1[Microsof
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=joe.
ialized.Selected.Microsoft
oupIdParameter`1[Microsoft
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=well
lized.Selected.Microsoft.E
pIdParameter`1[Microsoft.E
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=john
serialized.Selected.Micros
rGroupIdParameter`1[Micros
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=cony
ed.Selected.Microsoft.Exch
Parameter`1[Microsoft.Exch
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=mary
rialized.Selected.Microsof
roupIdParameter`1[Microsof
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=joe.
ialized.Selected.Microsoft
oupIdParameter`1[Microsoft
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Cannot process argument transformation on parameter 'Member'. Cannot convert the "@{PrimarySmtpAddress=well
lized.Selected.Microsoft.E
pIdParameter`1[Microsoft.E
+ CategoryInfo : InvalidData: (:) [Add-DistributionGroupMemb
+ FullyQualifiedErrorId : ParameterArgumentTransform
Try..
$users = get-distributiongroupmember 'GlobalHSM' -domaincontroller w2342o.xthy.com -Credential $username | Select-Object primarysmtpaddress
foreach ($user in $users) {
Add-DistributionGroupMember -Identity '&$HYMT_GlobalHSM' -Member $user.PrimarySmtpAddress.tostring() -DomainController chicago.mglobal.com
}
$users = get-distributiongroupmember 'GlobalHSM' -domaincontroller w2342o.xthy.com -Credential $username | Select-Object primarysmtpaddress
foreach ($user in $users) {
Add-DistributionGroupMember -Identity '&$HYMT_GlobalHSM' -Member (Get-mailbox $user.PrimarySmtpAddress.tostring()).Name -DomainController chicago.mglobal.com
}
That worked. Thanks! Now for the final part, is there a way to have the identity of the DL on a CSV file and use that instead of manually entering a DL name?
Thanks
Thanks
Try this..
$username = Get-Credential
Import-Csv Test.csv | % {
$users = get-distributiongroupmember $_.Source -domaincontroller w2342o.xthy.com -Credential $username | Select-Object primarysmtpaddress
foreach ($user in $users) {
Add-DistributionGroupMember -Identity $_.Dest -Member $user.PrimarySmtpAddress.tostring() -DomainController chicago.mglobal.com
}
}
Source, Dest
GlobalHSM,&$HYMT_GlobalHSM
Premium Content
You need an Expert Office subscription to comment.Start Free Trial