Connecting to Exchange Online using PowerShell

Exchange Online is part of the Office 365 Suite. The Exchange Online Management Center is used to manage and maintain the Exchange online mailboxes. Power Shell can also be used to accomplish these tasks. In order to connect to Exchange Online using Windows Power Shell, one would have to follow these steps-


  1. Run Windows Power Shell as an Administrator.
  2. Run this cmdlet Set-ExecutionPolicy RemoteSigned
  3. $UserCredential= Get-Credential
  4. A Windows PowerShell dialog box would pop up, type in your Office 365 Credentials.
  5. Then run this cmdlet $Session= New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri -Credential $UserCredential -Authentication Basic -AllowRedirectionScreenshot (117).png
  6. Import-PSSession $Session
  7. Once you have completed your work, you can close the session by Remove-PSSession $Session

Connecting to Skype for Business Online using PowerShell

Skype for Business is used by organizations as a means for communication. Management operations can be performed on the Skype for Business Admin Center. Sometimes you might need to perform bulk operations at a time. In that case one would have to use Power Shell in order to connect to Skype for Business Online and accomplish the tasks.


  1. Download and Install the Skype for Business Online, Windows PowerShell Module.
  2. Click the Start Button and Search for Windows Power Shell.
  3. Do a right click and select “Run as Administrator”
  4. Run this command set-ExecutionPolicy unrestricted
  5. Then type this cmdlet $credential= Get-Credential
  6. A Windows PowerShell Credential box would pop up. Type in your credentials.
  7. Then run $session= New-CsOnlineSession -Credential $credential
  8. Import-PSSession $session
  9. Then run Get-Module. If you see a table with 3 columns- ModuleType, Name and Exported Commands then the Skype for Business cmdlets are ready for use.Screenshot (116).png
  10. After achieving the objectives, one would have to close the Power Shell session. In order to do that, run this cmdlet Remove-PSSession $session . One must note that simply closing the Power Shell window would not terminate the Power Shell Session.

Health Insurance Terminology-Maximum Out of Pocket Costs

As we know the deadline (December 15)to update our Health Insurance application is approaching. This is a time when you can go through your application and update your Income, in case you foresee changes next year. You can also switch over to a new plan. Nonetheless everyone has to visit their Account and confirm whether they want to stick to their existing plan or switch over to a new one.


“Maximum Out of Pocket Cost” is a term which you might have encountered quite often while browsing through different plans.  It is the amount of money you pay in a year after which the Insurance Company bears 100% of the cost. For Example, Let’s say the Maximum Out of Pocket Cost for your Health Insurance Plan is $3,000 and in this year you have already spent $3,000. Now suppose you face a medical Issue where you visit a doctor and get a bill of $800. In this case, your health Insurance company would bear the full amount ie. they would pay $800. So for any medical bills till the end of the year, the Insurance company would take care of it and you won’t have to spend a single penny out of pocket.

Please visit the Health Insurance Market Place or the website of your Health Insurance provider to update your application.


This Cmdlet for Skype for Business allows you to Enable or Disable a Specific Public Provider. A public provider is an organization that provides SIP Communication services for the General public. So if the Organization enables communication with a Provider “Yahoo”, then the Organization can communicate with any Public User who has a Yahoo Account.


Set-CsTenantPublicProvider has two parameters, “Tenant” and “Provider”. Tenant is where you specify the Tenant ID and Provider is the Public Provider which you want to enable

Set-CsTenantPublicProvider -Tenant “” -Provider

For Example

Set-CsTenantPublicProvider -Tenant “123” -Provider “WindowsLive”

This would Enable the Public IM Provider WindowsLive for the Organization Tenant “123”.

Set-CsTenantPublicProvider -Tenant “123” -Provider “”

Since the Provider attribute is empty, all the public IM Providers would be disabled for the Tenant with ID 123.

Connecting to SharePoint Online using PowerShell

PowerShell allows one to perform bulk operations in a short period of time. It is much faster than doing the same operations over a GUI. In SharePoint Online if one needs to manage Site Collections, they would need to log into the SharePoint Online Admin Center. If one has to use Power Shell in SharePoint Online, they would need to download the SharePoint Online Management Shell. Here are the steps on how to connect to SharePoint Online and perform operations using Power Shell.



  1. Download the SharePoint Online Management ShellScreenshot (112).png
  2. On the Start Menu, type sharepoint.
  3. Click on the App, SharePoint Online Management Shell
  4. Then enter the following commands.
$adminUPN="<the full email address of a SharePoint Online global administrator
 account, example:>"
$orgName="<name of your Office 365 organization, example: contosotoycompany>"
$userCredential = Get-Credential -UserName $adminUPN -Message "Type the password."
Connect-SPOService -Url https://$ -Credential 

Trusted Host Location


Whenever you open a file which was downloaded from the Internet, like a Word File or an Excel file it always opens in Protected view. In this mode one cannot edit the file unless you trust it. This is the default precautionary measure taken by Windows. This is quite acceptable given the amount of Malware on the Internet.

But all files which are from the Internet are not Malware. Some files are the ones you trust especially which come from your friends and family. You would not want to open them in Compatibility Mode, Do You? Fortunately Windows has a solution for this, it is called the Trusted Host Location.

A Trusted Host Location is a path to a folder in your computer. Any files which would go into that folder are the ones you trust. When you open any file from that Folder, it would open in the Edit Mode and not in Protected View because it is coming from a location you Trust.