X-mas Fun with PowerShell and ScriptRunner

For this project we used a NETIO-4C manageable PDU. The magical Blackbox has 4 x 230V outputs that can be controlled with several protocols (REST API, SNMP, MQTT, Modbus/TCP).

For our little demo we connected the following devices to the outputs and named the output in the web interface (fig. 1):

1. Xmas Tree
2. Disco Light
3. Santa Claus

Output #4 was not used for our project.

Fig. 1: Naming the outputs in the NETIO-4C web interface

Further, we created a “write” user with a password and assigned the corresponding API permissions.

Figure 2 shows our test setup:

Fig. 2: The test setup

Fig. 4: PowerShell output from variable $io_box

Transforming the 2 lines of code into a function and using the html formatting and shaping features of ScriptRunner (figure 5) it gives a really nice output:

Fig. 5: Using ScriptRunner we can turn the PowerShell output into an HTML report

The function below returns the inverse state of a specified output. The required parameters are:

1. Credentials, by using the type System.Management.Automation.PSCredential (the built-in credential vault of ScriptRunner can be used)
2. IP, by using the ipaddress type a built-in validation is done
3. The output which is limited from 1 to 4 as we have 4 outputs available

Wrapping this piece of code into a nice function gives us the result below:

Based on this function we create an Action in the ScriptRunner Portal. For easier handling we embed it into a web page. The new ScriptRunner Portal Widget is perfect for this.

Putting the pieces of code together in ScriptRunner and combing the interface for the IOBox with the portal widget gives us a nice overview, as can be seen in figure 6 … more can be seen on the demo video.

Fig. 6: Using a ScriptRunner Portal Widget we can now comfortably control our test setup via PowerShell

As you can see very nicely in the video, we built our own little Christmas command center with just a few steps.
If this project has inspired you, we would of course be happy if you shared your results with us, e.g. on Twitter under the hashtag #merryscriptmas.

Happy scripting & happy holidays!