- DisplayName,Alias,RecipientType,RecipientOU,ExternalEmailAddress,Distribution Group,Distribution Group Primary SMTP address,Distribution Group Managers,Distribution Group OU,Distribution Group Type,Distribution Group Recipient Type
- John_Doe_ABC.com,John_Doe_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,John_Doe@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- SAME_Test_McTest1_ABC.com,Test_McTest1_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,Test_McTest1@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- Test_McTest1_ABC.com,Test_McTest1_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,Test_McTest1@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- Test_T_O'User1_ABC.com,Test_T_O'User1_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,Test_T_O'User1@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- Test_User1_ABC.com,Test_User1_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,Test_User1@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- Test_User2_ABC.com,Test_User2_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,Test_User2@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- Test_User4_ABC.com,Test_User4_ABC.com,MailContact,bc.com/FDO/National Projects/ABC/Contacts,Test_User4@ABC.com,bgroup_ABC_Test_Mail,bgroup_ABC_Test_Mail@bc.com,,bc.com/FDO/National Projects/ABC/Groups,Universal,MailUniversalDistributionGroup
- Test_User5_ABC.com,Test_User5_ABC.com,MailContact,bc.com/FDO/National Projects/DEF/Contacts,Test_User5@DEF.com,bgroup_DEF_Test_Mail,bgroup_DEF_Test_Mail@bc.com,,bc.com/FDO/National Projects/DEF/Groups,Universal,MailUniversalDistributionGroup
- Test_User7_DEF.com,Test_User7_DEF.com,MailContact,bc.com/FDO/National Projects/DEF/Contacts,Test_User7@DEF.com,bgroup_DEF_Test_Mail,bgroup_DEF_Test_Mail@bc.com,,,,
- Test_User8_DEF.com,Test_User8_DEF.com,MailContact,bc.com/FDO/National Projects/DEF/Contacts,Test_User8@DEF.com,bgroup_DEF_Test_Mail,bgroup_DEF_Test_Mail@bc.com,,,,
- Test_User9_DEF.com,Test_User9_DEF.com,MailContact,bc.com/FDO/National Projects/DEF/Contacts,Test_User9@DEF.com,bgroup_DEF_Test_Mail,bgroup_DEF_Test_Mail@bc.com,,,,
- Test_User10_DEF.com,Test_User10_DEF.com,MailContact,bc.com/FDO/National Projects/DEF/Contacts,Test_User10@DEF.com,bgroup_DEF_Test_Mail,bgroup_DEF_Test_Mail@bc.com,,,,
my first script (which I already have) creates contacts from the same csv file, after completion I would like to set the attribute for all contacts in that OU the same
- [[Import-CSV C:\Temp\book1.csv | ForEach-Object { New-MailContact -Name $_.DisplayName -ExternalEmailAddress $_.ExternalEmailAddress -OrganizationalUnit $_.RecipientOU]]
the csv file looks like this
Get-ADObject : Cannot validate argument on parameter 'SearchBase'. The argument is null. Provide a valid value for the argument, and then try running the command again.
At line:1 char:44
+ Get-ADObject -LDAPFilter $fltr -SearchBase $OU -SearchScope Subtree
+ ~~~
+ CategoryInfo : InvalidData: (:) [Get-ADObject], ParameterBindingValidationException
+ FullyQualifiedErrorId : ParameterArgumentValidationError,Microsoft.ActiveDirectory.Management.Commands.GetADObject
[PS] C:\ProgramData\Microsoft\Windows\Start Menu\Programs\Microsoft Exchange Server 2016>Set-ADObject -add @{msExchExtensionCustomAttribute1 = 'TEST453'}
cmdlet Set-ADObject at command pipeline position 1
Supply values for the following parameters:
Identity:
Any idea what I am missing , I am trying to incorporate the filter to only change Contacts, Rooms etc in the OU not users if there would be any.
- $OU = Import-CSV "C:\Temp\book1.csv"
- $OU = Where-Object { $_.RecipientOU }
- $fltr = '(|(objectCategory=person)' +
- '(&(objectCategory=group)' +
- '(!(groupType:1.2.840.113556.1.4.803:=2147483648)))' +
- '(msExchResourceMetaData=ResourceType:Room))'
- Get-ADObject -LDAPFilter $fltr -SearchBase $OU -SearchScope Subtree
- Set-ADObject -add @{
- msExchExtensionCustomAttribute1 = 'TEST453'
- }
Thank you for your help