Related Articles
SCSM – Set Work Item State / Activity State via PowerShell
Posted on Author stefanroth
I do currently a lot of automation and today I had a need to change state of a service request. The service request itself was “Closed” and as you might know, you cannot change anything if the work item is set to “Closed”. Because I needed to trigger the runbook activities behind the service request […]
PowerShell – Hash Table Get That Value
Posted on Author stefanroth
When writing scripts I like to use PowerShell ISE or VSCode a lot. It simplifies a lot of your daily scripting tasks like IntelliSense or Snippets. But sometimes these little helper don’t tell always the truth. Why? Well, I show you an example which is quite common. On problem there is if you are working […]
PowerShell – Create “Clean” Custom Objects From DataTable Object
Posted on Author stefanroth
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 […]