The “Hey, Scripting Guys!” blog has been retired. There are many useful posts in this blog, so we keep the blog here for historical reference. However, some information might be very outdated and many of the links might not work anymore.

New PowerShell content is being posted to the PowerShell Community blog where members of the community can create posts by submitting content in the GitHub repository.

Scripting Blog [archived]

Formerly known as the "Hey, Scripting Guy!" blog

PowerTip: Read a JSON configuration file as a PowerShell object

September 4, 2019 Sep 4, 2019 09/4/19

Doctor Scripto

Summary: Using the ConvertFrom-Json Cmdlet in PowerShell to read a JSON formatted file (image) Hey, Doctor Scripto! I've seen a lot of JSON files in use in Azure. I'm not very good with editing JSON properly. Is there an easy way to read this and at least edit it with PowerShell? (image) Most definitely my good friend. For the ...

PowerTip: Using PowerShell to Convert raw Text to a Comma Separated columm

August 28, 2019 Aug 28, 2019 08/28/19

Doctor Scripto

Summary: Using PowerShell and a very simple Regular Expression to convert Random counts of spaces to a Comma (image) Hey Doctor Scripto! I have some string based output from a non PowerShell application. The output is good but I need to easily parse it. Is there a way to convert that data to something consistent like "Comma Separated...

PowerTip: Identify if SQL Servers are configured to best practices

August 21, 2019 Aug 21, 2019 08/21/19

Doctor Scripto

Summary: Using the features of the SQLServer PowerShell module to run assessments of your servers (image) How can I easily check that my SQL Servers are all configured to meet best practices? (image) You can use SQL Server Assessments – the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment...

PowerTip: Identify Synchronized AzureAD accounts without a License assigned

August 14, 2019 Aug 14, 2019 08/14/19

Doctor Scripto

Summary: Using PowerShell to identify users who are Synchronized to AzureAD but not yet licensed (image) Hey, Doctor Scripto! I'd love to be able to identify users Synchronized to AzureAD that haven't yet had their licenses assigned. Help a friend out? (image) No problem at all! You can target that information with two ...

PowerTip: Identify the last time Users changed passwords in AzureAD

August 7, 2019 Aug 7, 2019 08/7/19

Doctor Scripto

Summary: Using PowerShell to report on Users and the last time Passwords were changed (image) Hey, Doctor Scripto! I need to report on users and when they updated their passwords In AzureAD. Could you show me how ? (image) Most certainly, I love to provide a helping hand however I can. Using the Get-Msoluser Cmdlet just target ...

Scripting Blog [archived]

PowerTip - Scripting Blog [archived]