Jay Carper

PowerShell to Add a Workstation to a User’s Log On To Property

It’s easy enough to use ADUC or ADAC to change the list of computers that a user account is authorized to logon to, but sometimes (like, whenever possible!) you need to use PowerShell. Let’s start by seeing what workstations the user is allowed to logon to now… PS C:\> Get-ADUser jay.test -Properties LogonWorkstations | Format-List Name, LogonWorkstations Name : Jay Test LogonWorkstations : testpc This tells […]

Read Me Leave comment

Faster Exchange Online Message Trace via PowerShell

If you submit a message trace with a custom date via the Exchange Online admin center, you’ll see this message: From there, it can take anywhere from a few minutes to a few hours for your search results to be ready. Or… You can pop over to PowerShell and, after connecting to Exchange Online, run your trace like this: Get-MessageTrace -StartDate 3/22/2017 -EndDate 4/3/2017 -RecipientAddress email@address.com […]

Read Me Leave comment

3 Steps to Get Control of Your Local Admin Account Passwords

A few years ago, Microsoft removed the ability to store passwords in Group Policy Objects using the cPassword method that Active Directory domain administrators had been using for over a decade because it was too easy to extract the password from the GPO files on the domain controller. LAPS provides a way to securely set and retrieve a random password for local administrator accounts on […]

Read Me Leave comment

Search Filenames in PowerShell

If you want to find all files in a particular folder with “hello” in the name, you could use the search function built into Windows Explorer, but if you want to save the list for later, or to send via email, use PowerShell instead. This cmdlet will give you every file (that you have access to list) on the C:\ drive with “hello” in the […]

Read Me Leave comment

Get a Report of All Inactive Office 365 Mailbox Users

This PowerShell script will give you a report of all of your Office 365 mailbox users who haven’t logged in for any given number of days. Once you’ve saved the script to a .ps1 file on your workstation or server, you can run it with just the script name or you can include the number of days inactive as a command-line option. the command-line option is especially […]

Read Me Leave comment

Excel Files No Longer Open from Windows Explorer

If you… 1. Have Office 2007 or 2010 installed on your computer and 2. Then install Office 365 and 3. Then uninstall the old version of Office… You will probably discover that when you double-click on an Excel workbook (.xlsx, etc.) from within Windows Explorer, that Excel opens, but the spreadsheet doesn’t. You have to open the workbook from within the Excel application. Fortunately, there’s […]

Read Me Leave comment

Microsoft Domains to Trust in Your Browser Script-blocker

If you’re using some kind of script blocker in your browser–and you should be–some websites can be very difficult to configure properly. Every script blocker I’ve used will show you a list of hosts and/or domains from which the current website is attempting to load scripts. But sometimes, even though you’ve allowed every script that shows up in the list, it still won’t work unless you […]

Read Me Leave comment