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: 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...

Automating Quser through PowerShell

August 27, 2019 Aug 27, 2019 08/27/19

Doctor Scripto

Summary: Using PowerShell to automate Quser to identify users to Logoff systems in Windows Hey Doctor Scripto! I need to log a user off every computer they’re logged into. The problem is, I don’t know which ones. How can I discover which computers they’re logged into and then log them off? That's a most excellent question! I know...

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...

Executing SQL Server Assessments from PowerShell

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

Doctor Scripto

Summary: Using the SQLServer module cmdlets to review and monitor SQL Server instance and database configuration Q: Hey, Doctor Scripto! I have loads of SQL Servers in my area of responsibility and I know they all need certain configuration settings but I'm never confident that they are all set just right so I spend a long time every ...

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 ...

May	JUN	Jul
	07
2023	2024	2025

Scripting Blog [archived]

August 2019 - Scripting Blog [archived]