Scripting Blog

A place to learn about PowerShell and share stories of automation

PowerTip - Scripting 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 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? Most definitely my good friend. For the file below called...

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 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 How can I easily check that my SQL Servers are all configured to meet best practices? You can use SQL Server Assessments – the latest addition to the SQLServer PowerShell module. Just Run a best practices assessment on your SQL ...

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 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? No problem at all!  You can target that information with two parameters in the ...