There may be a bug in the way Orchestrator matches the new line character (\n). Sometimes it just does not find the new line! After a […]
Continue readingOrchestrator – Looping on a PowerShell Object
Looping can be a little tricky if you don’t know the rules Orchestrator uses: The Exit tab specifies the conditions that will determine if the loop […]
Continue readingAdd a Tooltip using CSS and jQuery with Gradient and Round Borders
The perfect cross-browser tooltip is hard to find. You can always use the default, but it may not match your theme. Based on information I […]
Continue readingQuery for All Database Backups Within the Last Week
I was asked to retrieve a list of all database backups within the last week. Unfortunately, I forgot about the backupset table within msdb. However, […]
Continue readingOrchestrator – Check for Blank or Null
A good way to check if published data returned from an activity is blank or null is to match against the pattern ^$ (regex for […]
Continue readingOrchestrator – Fail a parent policy based on child status
Set the link from the triggered runbook to fail if the Child policy status equals failed or warning. Succeed if the Child policy status equals success. This […]
Continue readingOrchestrator – PowerShell error handling
We can use the Common Published Data “Error Summary Text” to capture the error from the PowerShell activity. Testing shows that if there are no […]
Continue readingFind the Blocking Job
Sometimes it is useful to find which job is blocking. sp_who2 will show you the running processes, but you will not know which job started […]
Continue readingUse PowerShell to Uninstall an Application – Comparing WMI vs. a Registry Scan
If you have ever scanned the list of currently installed programs using the WMI Win32_Product class, you’ve noticed that the scan runs slow! This always […]
Continue readingPowerShell command to check if a directory exists and if not, create it
I often have to look up this simple PowerShell command. The following command checks if a folder exists and if not, creates it. Works great. […]
Continue reading