Showing results for August 2019 - Scripting Blog [archived]

Aug 28, 2019
0
0

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

Doctor Scripto
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?" Why ...

PowerTipPowerShellregular expressions
Aug 27, 2019
0
0

Automating Quser through PowerShell

Doctor Scripto
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 just...

PowerShellregular expressionsDoctor Scripto
Aug 21, 2019
0
0

PowerTip: Identify if SQL Servers are configured to best practices

Doctor Scripto
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 Server ...

PowerTipPowerShellSQL Server
Aug 21, 2019
0
0

Executing SQL Server Assessments from PowerShell

Doctor Scripto
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 month ...

PowerShellSQL ServerDoctor Scripto
Aug 14, 2019
4
0

PowerTip: Identify Synchronized AzureAD accounts without a License assigned

Doctor Scripto
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 Get-...

PowerTipPowerShellDoctor Scripto