3.png

SCSM – Adding Activities Using SMA / PowerShell Workflow

For the past couple of weeks I have been doing some automation stuff using Service Management Automation (SMA) and therefore PowerShell in conjunction with Service Manager. I like PowerShell very much, especially if I can interact with other systems. As you might know in the “old” days you would use Orchestrator and Service Manager to […]

PowerShell – Change Windows Service Login to Group Managed Service Account

Group Managed Service Accounts (gMSA) are an awesome way to have Active Directory taking care of password changes for the service accounts. How to create Group Managed Service Accounts and how to assign them to Windows services you will find plenty of articles and blog posts on the internet. Group Managed Service Accounts solve you […]

PowerShell – Create “Clean” Custom Objects From DataTable Object

I recently had a need to create “clean” PowerShell custom objects out of a DataTable object. What does that mean? Well, let me explain. When you try to get data out of SQL Server using PowerShell there are many ways to do it. Either you use Invoke-SQLCmd, SQL Server PowerShell (SQLPS), SQL Server Management Objects […]