Scripting Blog

A place to learn about PowerShell and share stories of automation

August 2019 - Scripting 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 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 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 ...

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