Managing “If Null” for Published Data in Orchestrator

Anyone who has ever created a script knows that If statements are a cornerstone for error checking and decision points. You can easily check for a null value and redefine the variable with a specific value.

Fast forward to Orchestrator Runbooks.  As you have likely seen already or will see at some point, this same logic doesn’t translate natively to Runbook activities.

Consider this scenario:

You create Runbook activity to retrieve an attribute from an AD User.  In our example we’ll use the “Get Object Property Values” Activity from the “SCORCH Dev – Active Directory” IP (available on CodePlex) to retrieve the “DisplayName” property of a User:

If that attribute contains a value you’re golden! The value can be retrieved from the databus for future activities:


What if that attribute does not contain a value? What if you would like to check for a Null value and create a new Published Data entry for DisplayName that has a value of “Unknown” for example? You could certainly use a link condition to determine if the value was Null, but then what?

There is a fairly simple solution to this utilizing the Run .NET Script activity and Powershell.

Using 2 simple lines of code you simply check the Property Value, if null you set a Powershell variable with your own value:


You then publish the Powershell variable to the Databus using the Published Data tab


Snippet of what the Runbook looks like:


Very simple solution to check for Null values and redefine as needed ensuring you have a value on the databus for future activities.  😉  Would love to hear from others in the comments to see how they accomplish this.

Hope this info provides useful for others!


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s