Open Windows Powershell as Administrator.
Run the following
Install-Module SharepointPNPPowershellOnline
Type A when prompted.
To verify the version installed type the following:
Get-Module SharePointPnPPowerShell* -ListAvailable | Select-Object Name,Version | Sort-Object Version -Descending
Type the following to connect to your SharePoint Online Environment replacing <YourTenant> with your Tenancy alias, e.g alanlearnsstuff12345
Once upon a time there was a need to download an MSI and to install the SharePoint PowerShell Module that way, however, as all useful and trusted modules do one day it now can be found in the PowerShell Gallery at this link: Microsoft.
So, to install the module, run PowerShell as administrator and type …
Install-Module -Name Microsoft.Online.SharePoint.PowerShell
Then to bring it in to use by sending this command …
Import-Module -Name Microsoft.Online.SharePoint.PowerShell
Now we have the module, installed and imported to the session let’s connect …
In this example, I have an extremely simple function called MyCode. The purpose of the function is only to demonstrate us taking any PowerShell output then passing it ot the body of an email and sending that email.
Here is a look at the output:
Once we have the output from MyCode it is all about how we pass that over to the email. That is achieved by using Send-MailMessage.
Here is a script that will quickly tell you some mailbox information and some mailbox statistics for an Exchange Online such as Office 365 mailbox. This will also work with Exchange Shell on Exchange 2013 on Premises.
The data is collated from 2 different cmdlets, Get-MsolUser and Get-MailboxStatistics. The data is then used to create an advanced function called Get-UserInfo.
This post serves as a demonstration in building a hash table and a custom PSObject, one of the most important aspects of PowerShell scripting. It also serves to demonstrate the principal of gathering output from various cmdlets and bringing them together as one.
It has been assumed that you have installed the PowerShell Module called MSOnline and authenticated to Office 365 via PowerShell in the usual way.
If you were to “Dot Source” the script using PowerShell.exe then you would run it with the following :
Get-UserInfo -UPN user@mail.com -Verbose -ErrorLog
This script example will only support one UserPrincipalName input although can be easily changed to accept multiple, CSV input and accross the pipeline if required. This is outwith the scope of this post.
I found this a little tricky to lay my fingers on at first so thought it best that I document it here.
Have you ever been asked to “Get me all the users who have call recording turned on” from a Skype for Business tenant?
If you are asked that question. Here are the PowerShell commands you will require.
Get-CsOnlineUser | Where {$_.ConferencingPolicy -eq “BposSALLModality”} | Select-object DisplayName, ConferencingPolicy
Get-CsOnlineUser | Where {$_.ConferencingPolicy -eq “BposSALLModalityNoRec”} | Select-object DisplayName, ConferencingPolicy
Clearly this is almost a true false scenario so a script outputting to 2 different excel sheets may just be what you need.