This worked perfect. A whole lot better than tryng to update 90+ users manually. Thanks!<br><br><div class="gmail_quote">On Mon, Dec 10, 2012 at 12:47 PM, Mike Wilusz (miwilusz) <span dir="ltr"><<a href="mailto:miwilusz@cisco.com" target="_blank">miwilusz@cisco.com</a>></span> wrote:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">



<div style="word-wrap:break-word">
<div>
<div>
<p style="margin:0px;padding:0px"><b><font color="#666666" face="Arial"><span style="font-size:12px;line-height:15px">Pulled from a doc I found:</span></font></b></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<br>
</p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<br>
</p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
This can only be accomplished in bulk using the Bulk Administration Tool (BAT). </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
Where it can get a bit confusing is which section of the doc to use.  Since the users exist already without a UM account assigned to them, we need to actually use the CREATE option in BAT to give the users Unified Messaging.  We're basically going to use the
 configuration for existing Unified Messaging users as a template for our new users, which will give them all the same features.</p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<b>1. Get a list of all of the subscribers' aliases on the system by doing a BAT export of "Users with Mailbox"</b></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
  <img src="cid:87642CF4-DD0A-451B-BBF6-D4C047F2CD74" type="image/png" style="color:rgb(0,0,0);font-family:Calibri,sans-serif;font-size:14px">                                              </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<b>The resulting CSV should look similar to (download from article for better readability):</b></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<font color="#FF0000" style="line-height:normal"><b>Alias</b></font>,Address,AltFirstNames,AltLastNames,BillingId,Building,City,Country,Department,DisplayName,EmailAddress,MailName,EmployeeId,EnhancedSecurityAlias,FirstName,Initials,Language,LastName,Manager,PostalCode,State,TimeZone,Title,CosDisplayName,Extension,ClientMatterCode,TransferType,TransferRings,TransferExtension,TransferAction,RnaAction,StandardTransferType,StandardTransferRings,StandardTransferExtension,StandardTransferAction,StandardRnaAction,ClosedTransferType,ClosedTransferRings,ClosedTransferExtension,ClosedTransferAction,ClosedRnaAction,MWIExtension,MWIMediaSwitchDisplayName,MaxMsgLen,playPostGreetingRecording,postGreetingRecordingDisplayName,ForcedAuthorizationCode,ListInDirectory,CreateSmtpProxyFromCorp,MediaSwitchDisplayName,PhoneNumber_HomePhone,Active_HomePhone,DisplayName_HomePhone,PhoneNumber_WorkPhone,Active_WorkPhone,DisplayName_WorkPhone,PhoneNumber_MobilePhone,Active_MobilePhone,DisplayName_MobilePhone,PhoneNumber_Pager,AfterDialDigits_Pager,Active_Pager,DisplayName_Pager,PhoneNumber_TextPager1,SmtpAddress_TextPager1,Active_TextPager1,DisplayName_TextPager1,Extension_Alt1,Extension_Alt1_Partition,Extension_Alt2,Extension_Alt2_Partition,Extension_Alt3,Extension_Alt3_Partition,Extension_Alt4,Extension_Alt4_Partition,Extension_Alt5,Extension_Alt5_Partition,Extension_Alt6,Extension_Alt6_Partition,Extension_Alt7,Extension_Alt7_Partition,Extension_Alt8,Extension_Alt8_Partition,Extension_Alt9,Extension_Alt9_Partition,CcmId,EmailAction,VoicemailAction,FaxAction,DeliveryReceiptAction,RelayAddress,SmtpProxyAddresses,LdapCcmUserId,CorporatePhoneNumber<br>

<font color="#339966" style="line-height:normal"><b>userA</b></font>,,,,,,,,,user A,,usera,,,user,,1033,A,,,,20,,Voice Mail User COS,123456123456,,0,4,123456123456,1,1,0,4,123456123456,1,1,0,4,123456123456,1,1,123456123456,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home
 Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,<br>
<font color="#339966" style="line-height:normal"><b>userB</b></font>,,,,,,,,,user A,,usera,,,user,,1033,B,,,,20,,Voice Mail User COS,123456123457,,0,4,123456123457,1,1,0,4,123456123457,1,1,0,4,123456123457,1,1,123456123457,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home
 Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,<br>
<font color="#339966" style="line-height:normal"><b>userC</b></font>,,,,,,,,,user A,,usera,,,user,,1033,C,,,,20,,Voice Mail User COS,123456123458,,0,4,123456123458,1,1,0,4,123456123458,1,1,0,4,123456123458,1,1,123456123458,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home
 Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,<br>
<font color="#339966" style="line-height:normal"><b>userD</b></font>,,,,,,,,,user A,,usera,,,user,,1033,D,,,,20,,Voice Mail User COS,123456123459,,0,4,123456123459,1,1,0,4,123456123459,1,1,0,4,123456123459,1,1,123456123459,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home
 Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,<br>
<font color="#339966" style="line-height:normal"><b>userE</b></font>,,,,,,,,,user A,,usera,,,user,,1033,E,,,,20,,Voice Mail User COS,123456123450,,0,4,123456123450,1,1,0,4,123456123450,1,1,0,4,123456123450,1,1,123456123450,PhoneSystem,300,0,,,1,0,PhoneSystem,,0,Home
 Phone,,0,Work Phone,,0,Mobile Phone,,,0,Pager,,,0,SMTP,,,,,,,,,,,,,,,,,,,,1,1,1,1,,,,</p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<b>2.  Now get a list of all of the "Unified Messaging Accounts" that already exist on the system so we can use it as a template for our final CSV</b></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<img src="cid:811E0653-494D-4799-994A-A7B167D3E0BF" type="image/png"></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<b>3. Copy the alias value only (<font color="#339966" style="line-height:normal">green</font>)from the first "Users with Mailbox" CSV export who you want to enable for Unified Messaging and paste them in the "SubscriberAlias" column of the second "Unified
 Messaging Accounts" CSV export.  It will look something like this (download from article for better readability):</b></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<font color="#FF0000" style="line-height:normal"><b>SubscriberAlias</b></font>,ServiceDisplayName,OptionalServiceAccountID,UMEmailAddress,EmailAddressUseCorp,EnableCalendar,EnableMeeting,EnableMbxSynch,enableTTS,IsPrimaryMeetingService,LoginType,UserId,UserProfileNumber<br>

<font color="#339966" style="line-height:normal"><b>userD</b></font>,Exchange 2010,3194886a-d72b-4893-bbd6-15b4fe02e644,userD@co<a href="http://rp.com" target="_blank">rp.com</a>,1,0,0,1,1,0,0,,<br>
<font color="#339966" style="line-height:normal"><b>userE</b></font>,Exchange 2010,3194886a-d72b-4893-bbd6-15b4fe02e644,userE@co<a href="http://rp.com" target="_blank">rp.com</a>,1,0,0,1,1,0,0,,</p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
Since we know userA, userB, userC already had UM configured months ago, we only want to give the feature to userD and userE.  This also assumes that userD and userE are going to be assigned the same Unified Messaging account and features (all of the columns)
 as existing userA, userB, userC.  These can be manually modified too but this article just covers how to get everyone enabled for the same features in a hurry.</p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<b>4.  Create the Unified Messaging feature for your two users by providing your newly created CSV</b></p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
 </p>
<p style="line-height:15px;color:rgb(102,102,102);font-size:12px;margin:0px;font-family:Arial;padding:0px">
<img src="cid:BD5AE290-22A4-4CA8-8648-FC7063A04572" type="image/png"></p>
</div>
<div style="font-size:14px;font-family:Calibri,sans-serif">
<div><br>
</div>
</div>
</div>
<span style="font-size:14px;font-family:Calibri,sans-serif">
<div style="border-right:medium none;padding-right:0in;padding-left:0in;padding-top:3pt;text-align:left;font-size:11pt;border-bottom:medium none;font-family:Calibri;border-top:#b5c4df 1pt solid;padding-bottom:0in;border-left:medium none">

<span style="font-weight:bold">From: </span>Erick <<a href="mailto:ewellnitzvoip@gmail.com" target="_blank">ewellnitzvoip@gmail.com</a>><br>
<span style="font-weight:bold">Date: </span>Monday, December 10, 2012 12:58 PM<br>
<span style="font-weight:bold">To: </span>"<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>" <<a href="mailto:cisco-voip@puck.nether.net" target="_blank">cisco-voip@puck.nether.net</a>><br>

<span style="font-weight:bold">Subject: </span>[cisco-voip] bulk set UM account and LDAP<br>
</div>
<div><br>
</div>
<div>
<div>
<div>Is there a way to bulk update LDAP integration and UM Account for connection users?  I didn't see anything obvious in the guide with the csv fields for bulk import and COBRAS doesn't seem to have an option for either one.<br>

</div>
<div><br>
</div>
<div>Thanks in advance!</div>
</div>
</div>
</span>
</div>

</blockquote></div><br>