{"id":2760,"date":"2013-10-07T00:01:00","date_gmt":"2013-10-07T00:01:00","guid":{"rendered":"https:\/\/blogs.technet.microsoft.com\/heyscriptingguy\/2013\/10\/07\/use-powershell-to-bulk-create-new-conference-rooms\/"},"modified":"2013-10-07T00:01:00","modified_gmt":"2013-10-07T00:01:00","slug":"use-powershell-to-bulk-create-new-conference-rooms","status":"publish","type":"post","link":"https:\/\/devblogs.microsoft.com\/scripting\/use-powershell-to-bulk-create-new-conference-rooms\/","title":{"rendered":"Use PowerShell to Bulk Create New Conference Rooms"},"content":{"rendered":"

Summary<\/strong>: Guest blogger, Tim Bolton, discusses how he used Windows PowerShell to create a bunch of new conference rooms.\nMicrosoft Scripting Guy, Ed Wilson, is here. Today we have another guest blog post by Tim Bolton. In one way, today’s post is a continuation of the post we published on Friday about adding carriage returns to .csv files. It would be a good idea to review that post before reading today’s:<\/p>\n

CSV: Add a Carriage Return for PowerShell Import<\/a>\nNow, without further ado, take it away Tim…\nDue to a recent physical site relocation, I was tasked with creating new conference rooms at our new location. By using Windows PowerShell, I initially created the common area phones in Microsoft Lync and assigned the applicable numbers to each. Here are the steps I followed:<\/p>\n

<#<\/p>\n

.Synopsis<\/p>\n

            Creating a Single New Lync Common Area Phone<\/p>\n

            You MUST run this on a Microsoft Lync server<\/p>\n

.Description\nTo create a new Lync common area phone, you need the Number, Display Name, and Description, as shown in the following example:<\/p>\n

.Example<\/p>\n

            PS C:> .New-CommonAreaPhone.ps1\nWhen you enter in phone number, such as  (972) 555-0185, it will be converted for LineURI and DisplayNumber:<\/p>\n

            Enter Display Name<\/p>\n

            Enter Description<\/p>\n

.Notes<\/p>\n

            NAME: New-CommonAreaPhone.ps1<\/p>\n

            VERSION: 3.1<\/p>\n

            AUTHOR: Tim Bolton \/ Brian Peacock<\/p>\n

            LASTEDIT: 09\/18\/2013<\/p>\n

           <\/p>\n

#><\/p>\n

 <\/p>\n

# Create new common area phone, Enter new phone number, display name, and description.<\/p>\n

Do {<\/p>\n

            $Phone=Read-Host “What is the New 10 digit Phone Number? – Example (972) 555-0185 “<\/p>\n

            } while ($Phone -match “^ddd-ddd-dddd$” -ne “True” )<\/p>\n

Do {<\/p>\n

            $DisplayName=Read-Host “What is the Display Name – Example Phone – BigDog – Executive Conf. Room 197 “<\/p>\n

            } while ($DisplayName.Length -le 5 )<\/p>\n

Do {<\/p>\n

            $Description=Read-Host “What is the Description – Example Something for the BigDog AD team “<\/p>\n

            } while ($Description.Length -le 5 )<\/p>\n

# Converts the number for LineURI & DisplayNumber<\/p>\n

            $LineURI= “tel:+1” + $Phone.Replace(“-“, “”)<\/p>\n

            [long]$Display=$Phone.Replace(“-“, “”)<\/p>\n

            $DisplayNumber=”{0:(###) ###-####}” -f $Display<\/p>\n

 <\/p>\n

# That generates the contact object in Active Directory. Give this about 60 seconds to bake before you run the following script against it.<\/p>\n

New-CsCommonAreaPhone -LineUri $LineURI -RegistrarPool “BD-lyncpool.Big.Dog.Com” -DisplayName $DisplayName -DisplayNumber $DisplayNumber -Description $Description -OU “OU=Contacts,OU=Users,DC=Big,DC=Dog,DC=com”<\/p>\n

 <\/p>\n

# Pause 60 Seconds for Lync Changes<\/p>\n

write-host -foregroundcolor Green “Waiting for 60 Seconds Lync Changes to propogate”<\/p>\n

Start-Sleep -s 60<\/p>\n

 <\/p>\n

# Then apply the PIN number and  policies in order.<\/p>\n

Write-Host -foregroundcolor Yellow “Configuring Lync Policies for $DisplayName “<\/p>\n

Grant-CSPINPolicy -identity $DisplayName -PolicyName “commonareapin”<\/p>\n

Grant-CsVoicePolicy -Identity $DisplayName -PolicyName “BigDog-National”<\/p>\n

Grant-CsDialPlan -Identity $DisplayName -PolicyName “BigDogPlace”<\/p>\n

Grant-CsConferencingPolicy  -Identity $DisplayName -PolicyName “commonareaconferencing”<\/p>\n

Grant-CsClientPolicy -Identity $DisplayName -PolicyName “commonareaclient-nohotdesking”<\/p>\n

 <\/p>\n

# Pause 60 Seconds for Lync Policies<\/p>\n

write-host -foregroundcolor Green “Waiting 30 Seconds Lync Policies to propogate”<\/p>\n

Start-Sleep -s 30<\/p>\n

Write-Host -foregroundcolor Yellow “Configuring Lync PIN for $DisplayName “<\/p>\n

Set-CSClientPIN -identity $LineURI -pin 123456<\/p>\n

 <\/p>\n

#Verify the application of the Policies.<\/p>\n

write-host -foregroundcolor Green “Completeing Tasks”<\/p>\n

Start-Sleep -s 10<\/p>\n

 <\/p>\n

Get-CsCommonAreaPhone –Identity $DisplayName<\/p>\n

 <\/p>\n

Exit\nThe complete script is available in the Script Center Repository: New Lync Common Area Phone<\/a>.\nAfter I created all of the phone numbers, I used a .csv file and Windows PowerShell to create the new conference rooms.  This must be completed on an Exchange Server with proper Admin credentials or by remotely using PSSession to connect to an Exchange Server.\nThe .csv file headers consist of these known values:<\/p>\n

Name, Alias, UserPrincipalName, Database, DisplayName, OrganizationalUnit, SamAccountName, RetentionPolicy, Notes, Description, Phone\nInitially, we wanted the rooms to be hidden so that users would not start booking the new conference rooms prior to them being available. To set the room to Hidden, I used the following script:<\/p>\n

Write-Host -foregroundcolor Green “Waiting 30 seconds for Replication Then will set Hidden From Exchange to $True!”<\/p>\n

Set-Mailbox -Identity $Entry.Alias -HiddenFromAddressListsEnabled $True\nAfter all of the conference rooms were created, we unhid them.\nThe default setting for the HiddenFromAddressListsEnabled<\/strong> property is $False<\/strong>, which is what I used when all of the rooms were available:<\/p>\n

Set-Mailbox -Identity $Entry.Alias -HiddenFromAddressListsEnabled $False\n~Tim\nThank you, Tim, for another interesting and useful post. Join me tomorrow when I will talk about creating virtual adapters on Hyper-V. It will be cool.\nI invite you to follow me on Twitter<\/a> and Facebook<\/a>. If you have any questions, send email to me at scripter@microsoft.com<\/a>, or post your questions on the Official Scripting Guys Forum<\/a>. See you tomorrow. Until then, peace.\nEd Wilson, Microsoft Scripting Guy<\/strong> <\/p>\n","protected":false},"excerpt":{"rendered":"

Summary: Guest blogger, Tim Bolton, discusses how he used Windows PowerShell to create a bunch of new conference rooms. Microsoft Scripting Guy, Ed Wilson, is here. Today we have another guest blog post by Tim Bolton. In one way, today’s post is a continuation of the post we published on Friday about adding carriage returns […]<\/p>\n","protected":false},"author":596,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[455,56,3,324,45],"class_list":["post-2760","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-csv","tag-guest-blogger","tag-scripting-guy","tag-tim-bolton","tag-windows-powershell"],"acf":[],"blog_post_summary":"

Summary: Guest blogger, Tim Bolton, discusses how he used Windows PowerShell to create a bunch of new conference rooms. Microsoft Scripting Guy, Ed Wilson, is here. Today we have another guest blog post by Tim Bolton. In one way, today’s post is a continuation of the post we published on Friday about adding carriage returns […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/2760","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/users\/596"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=2760"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/2760\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media\/87096"}],"wp:attachment":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/media?parent=2760"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=2760"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=2760"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}