with Office 365.<\/p>\n
- \n
- In Getting Started with Office 365 and PowerShell<\/a>, I talked about setting up a demo environment and installing the prerequisite software to enable Windows PowerShell management of the demo environment. I also walked through the installation of the management module.<\/li>\n
- In Use PowerShell to Explore Office 365 Installation<\/a>, I talked about using Windows PowerShell to explore the settings and the capabilities of my Office 365 tenant installation.<\/li>\n
- In today’s post, I talk about finding unlicensed users, removing users, and modifying users.<\/li>\n<\/ul>\n
In some respects, as IT pros, we invest in Office 365 technology in much the same way as I invest in flowers. We hope that in the future we will receive the promised benefit. We hope that Office 365 will be more stable, easier to manage, easier to maintain, and therefore provide a promised benefit to the bottom line. One of the keys to unlocking that promise is knowing how to use Windows PowerShell.<\/p>\n
The first thing I need to do is to connect to Office 365. To do this, I am using the stored credential that I talked about in yesterday’s blog post, and then I use a cmdlet to make my connection to Office 365. The two commands are shown here:<\/p>\n
$cred = Import-Clixml C:\\fso\\cred.xml<\/p>\n
Connect-MsolService -Credential $cred<\/p>\n
When I am connected, I like to user the Get-Command<\/b> cmdlet to display available Windows PowerShell commands. This is shown in the image that follows:<\/p>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-3-26-14-01.png\" "\\"Image")
<\/a><\/p>\nBecause this is Windows PowerShell, I can use standard Windows PowerShell techniques to discover commands that I need to use. Then when I have found the cmdlet, I can use Get-Help<\/b> to find examples of use. Here are some ideas keep in mind:<\/p>\n
- \n
- Use Get-Command<\/b> to find cmdlets. The main module to use is the MSOnline module.<\/li>\n
- Use Tab expansion to expand the names of cmdlets, and also the names of modules. Hit the Tab key, and it will cycle through available options.<\/li>\n
- To find Help, use the Get-Help<\/b> cmdlet. If you are using Windows PowerShell 4.0 or Windows PowerShell 3.0, you need to first open the Windows PowerShell console with admin rights, and then use the Update-Help<\/b> cmdlet to update all the Help for modules.<\/li>\n
- Use the Get-Member<\/b> cmdlet to find object properties to use when filtering.<\/li>\n
- Use the Where-Object<\/b> cmdlet to reduce or to filter returned information.<\/li>\n
- Use the Group-Object<\/b> cmdlet to group returned objects by properties.<\/li>\n
- Use the Out-GridView<\/b> to produce a usable control that permits filtering and sorting.<\/li>\n
- Use the Show-Command<\/b> cmdlet to produce a floatable control that permits you to easily fill in options.<\/li>\n
- Use the Measure-Object<\/b> cmdlet for counting.<\/li>\n<\/ul>\n
Display and work with users<\/h2>\n
To display basic user information about the Office 365 users, use the Get-MsolUser<\/b> cmdlet. To count the number of users, use the Measure-Object<\/b> (measure<\/b> is an alias) cmdlet. The use of these two cmdlets is shown in the image that follows:<\/p>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-3-26-14-02.png\" "\\"Image")
<\/a><\/p>\nIt is pretty obvious from the previous image that I have 32 total users, but some are licensed and some are not. Therefore, I want to know how many of each type user exists. I can use the Group-Object<\/b> cmdlet to figure this out. The best way to use Group-Object<\/b> is to first sort the data and then group the data. The command is:<\/p>\n
Get-MsolUser | Sort islicensed | group islicensed<\/p>\n
This command displays the needed information, but the output is a bit clunky. This is because of the grouping information that says it is a bunch of user objects. I already knew that. Therefore, to clean up the list, I want to remove the element grouping information. To do that, I add the –noelement<\/b> switch to the command. The output from the two commands is shown here:<\/p>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-3-26-14-03.png\" "\\"Image")
<\/a><\/p>\nI want to get a good list of users that are not licensed. I can do this by piping my list of users to Where-Object<\/b> and filtering on the islicensed<\/b> property. I come up with the following command:<\/p>\n
Get-MsolUser | where {-not $_.islicensed}<\/p>\n
But then I start thinking…<\/p>\n
Dude, this is a lot of work. And not only that—it is inefficient. This is because it needs to get the list of users, and then filter them. So I use the Get-Command<\/b> cmdlet, and I find that there is a switch parameter that I can use. The command is shown here:<\/p>\n
Get-Command Get-MsolUser | select -expand Definition<\/p>\n
The output from the command is shown here:<\/p>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-3-26-14-04.png\" "\\"Image")
<\/a><\/p>\nI re-run the command using the LicenseReconciliationNeededOnly<\/b> switch parameter, and I see the output is exactly the same.<\/p>\n
Note <\/b> The switch parameter is really long, so please do not fool with trying to type it. Use Tab expansion until it appears. This will ensure that it is spelled correctly, and save at least 30 seconds of typing.<\/p>\n
The output from the two commands is shown here:<\/p>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-3-26-14-05.png\" "\\"Image")
<\/a><\/p>\nRemove unlicensed users<\/h2>\n
I know that I said Windows PowerShell is Windows PowerShell is Windows PowerShell. But not always…<\/p>\n
Unfortunately, this is not always exactly true. For example, I would have expected the Remove-MsolUser<\/b> cmdlet to implement ShouldProcess<\/b>, so that I could use the –whatif<\/b> parameter to see what a cmdlet would do. But unfortunately, it does not.<\/p>\n
What the cmdlet does do, is default to using –confirm<\/b>, but there is no –confirm<\/b> parameter available either. So when I try to run the following command, it prompts for each of the user objects:<\/p>\n
Get-MsolUser -LicenseReconciliationNeededOnly | Remove-MsolUser<\/p>\n
This is no good for automation. So I try a couple of things, and I eventually find that the cmdlet actually uses the –Force<\/b> parameter to suppress confirmation messages.<\/p>\n
So, here is the command I ended up using:<\/p>\n
Get-MsolUser -LicenseReconciliationNeededOnly | Remove-MsolUser –Force<\/p>\n
Now I check to see if the command actually worked:<\/p>\n
PS C:\\> Get-MsolUser -LicenseReconciliationNeededOnly<\/p>\n
PS C:\\><\/p>\n
Yep, they are gone.<\/p>\n
Luckily, Office 365 has a Recycle Bin, and it is easy to recover the deleted users via the admin tool. This is shown here:<\/p>\n
![\"Image](\"https:\/\/devblogs.microsoft.com\/wp-content\/uploads\/sites\/29\/2019\/02\/hsg-3-26-14-06.png\" "\\"Image")
<\/a><\/p>\nThere is also a Restore-MsolUser<\/b> cmdlet, but unfortunately, there is no obvious way to find all the users in the Recycle Bin. Therefore, I would need to know each UPN to restore the users. In this case, for me, using the GUI is easier. If I had kept a log of the user objects that I deleted, I could have more easily reactivated the users.<\/p>\n
That is all there is to using Office 365 cmdlets. Office 365 Week will continue tomorrow when I will talk about more cool stuff.<\/p>\n
I 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.<\/p>\n
Ed Wilson, Microsoft Scripting Guy<\/b><\/p>\n","protected":false},"excerpt":{"rendered":"
Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to manage Office 365 users. Microsoft Scripting Guy, Ed Wilson, is here. The weather here in Charlotte has been nearly perfect recently. I love spring. It offers hope, and it seems to be a time of renewed commitments. A quick trip to the garden center, […]<\/p>\n","protected":false},"author":595,"featured_media":87096,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[1],"tags":[49,291,3,45],"class_list":["post-1755","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-scripting","tag-office","tag-office-365","tag-scripting-guy","tag-windows-powershell"],"acf":[],"blog_post_summary":"
Summary: Microsoft Scripting Guy, Ed Wilson, talks about using Windows PowerShell to manage Office 365 users. Microsoft Scripting Guy, Ed Wilson, is here. The weather here in Charlotte has been nearly perfect recently. I love spring. It offers hope, and it seems to be a time of renewed commitments. A quick trip to the garden center, […]<\/p>\n","_links":{"self":[{"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/1755","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\/595"}],"replies":[{"embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/comments?post=1755"}],"version-history":[{"count":0,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/posts\/1755\/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=1755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/categories?post=1755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/devblogs.microsoft.com\/scripting\/wp-json\/wp\/v2\/tags?post=1755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
- In Use PowerShell to Explore Office 365 Installation<\/a>, I talked about using Windows PowerShell to explore the settings and the capabilities of my Office 365 tenant installation.<\/li>\n