SCRIPTING BLOG
-
PowerShell ConvertFrom-StringData, Turning Raw Text Into Usable Data
Today I learned something new in PowerShell. I was working on a workflow where I had to move a PowerShell object from one activity to another. The problem was, I could only pass it as a string. So I had the data as string, but not my loved object anymore 😄 That was the moment…
-
Using JSON in SQL Quicktipp
I had a situation recently where I needed to filter specific offboarding tasks from my database. Sounds simple at first, but the challenge was that the relevant information was not stored in its own column, it was inside a JSON field. In my case, the table stores requests from au2mator. Every request can have different…
-
Retrieve and Export Azure Automation Jobs with All Parameters
This PowerShell script retrieves Azure Automation jobs from the last 7 days for a specific runbook, enriches each job with missing details, normalizes all parameters, and exports everything to a CSV file for easy analysis. This can be incredibly useful for operational monitoring, auditing, and troubleshooting. In many environments, runbooks are triggered with dynamic input…
-
Input Parameters and Validation in PowerShell
When writing or re-organizing PowerShell scripts, one of the first improvements I usually make is replacing hardcoded values with input parameters. At the beginning of my PowerShell journey I often wrote scripts where usernames, server names, or paths were directly written into the script itself. This works for quick tests, but very quickly those scripts…
-
Why $ErrorActionPreference Is Important in PowerShell
Error handling is an important when writing scripts. Many automation scripts interact with external systems such as Active Directory, Azure services, databases, or REST APIs. When something goes wrong, the script should detect the error and react accordingly. PowerShell provides structured error handling through Try, Catch, and Finally blocks. However, there is an important detail…
Erhalte Benachrichtigungen über neue Inhalte direkt per E-Mail.
Powershell Works 