It’s easy to find instructions for exporting an Outlook Contact Group to a csv file, but there’s no built in way (as of today, at least) for an end user to export the membership of a Microsoft 365 (Office 365) Group. Here are two ways it can be done, one for an Exchange Administrator via PowerShell and one for an end user via Microsoft Outlook. […]
I have a massive Powershell script that performs end user service provisioning across a number of on-premises and Microsoft 365 services. Recently, I needed to add some code for setting security options for Sharepoint sites hosted on Sharepoint Online. Since the original purpose of this script was to provision and configure Exchange mailboxes, it runs within the Exchange Management Shell. It turns out that this […]
This PowerShell one-liner will find all hidden files and folders in the current directory and turn off the Hidden attribute: Get-ChildItem -Force -Recurse | Where-Object{($_.Attributes.ToString().Split(“, “) -contains “Hidden”) -and ($_.Name -ne “thumbs.db”) -and ($_.Name -notlike “~*”) -and ($_.Name -ne “desktop.ini”) -and ($_.Name -ne “folder.ico”)} | foreach {$_.Attributes = “Archive”} I deliberately wrote this to skip thumbs.db, desktop.ini, folder.ico and Microsoft Office temporary files, because there […]
You can use PowerShell to get a list of local workstation user accounts on Windows 7 or Windows 10. (Probably Windows 8 and 8.1, but does anybody really care?) This is much easier on Windows 10, than on 7. Get-LocalUser | Select Name Not much to write about there, but most of us still have some Windows 7 computers floating around, and that won’t work […]
Many things in Exchange and Office 365 take too long to do via the admin console, but are too obscure to do routinely via PowerShell. Unless, that is, you have a script! This function will add a single sender address to your spam policy’s BlockedSenders attribute or a sender domain to the BlockedSenderDomains attribute. (If you find any errors in the code below, let me […]
Let’s say you want to create in Inbox Rule and you don’t want to (or can’t) use Outlook to do it. Who cares why, right? You just don’t. $ReasonsWhy = “Not Relevant” You can use the New-InboxRule to move, copy, delete, forward, classify…whatever…newly received messages, just like you can if you created the rule through Outlook’s wizard. You can’t do quite everything in PowerShell that can be done […]
If you use PowerShell to manage both on-prem and cloud Exchange resources, you can manage both in the same console by adding a prefix to the cmdlets of one or the other. It’s easier to add the prefix for Exchange Online cmdlets, so I’ll show you that. Simply copy and paste this code into the on-prem Exchange Management Shell to connect to Exchange Online and prefix the […]