PowerShell integration

PowerShell is the Swiss Army Knife for modern infrastructure data. Wherever your data resides, PowerShell can probably work with it. PowerShell can work with crazy text formats, esoteric databases, and endpoints that are open on the internet. If you can access it, PowerShell can work with it. But what happens when you want to share that data across your team? With SquaredUp’s PowerShell integration, you can give your users the information they need in a format that makes sense.

Sample PowerShell Dashboard

Here’s a dashboard that uses VMware’s PowerCLI to connect to an ESX landscape. All the tiles share the same Profile and Run As account but pull back different information and run on different schedules.

And here’s a peek at the query behind one of the visualizations.

And when you click the Next button, the response data from your script is displayed so you can instantly verify if it’s the data you’re expecting.

As you can see, we’re using a PowerShell cmdlet to pull back information and then format it so that users can instantly recognize when something isn’t working. Instead of sharing plain text, now you can communicate quickly and clearly to get the job done right the first time.

Find more examples in our Dashboard Gallery!

How to visualize PowerShell data in five steps

Step ONE

Select the PowerShell tile.

Step TWO

Choose how you want to visualize your PowerShell script– a single value (scalar), a grid of data, a line graph, sparklines, bar, donut, or two different status blocks.

Step THREE

Set up your PowerShell environment by choosing a Run As account, a profile, or both.

Step FOUR

Supply your PowerShell script and validate the response data at the same time.

Step FIVE

(Optionally) Add some finishing touches like showing or hiding columns, making the rows clickable, adding a legend or labels to get the point across.

Want to learn more?

Find out more about working with the PowerShell integration in the following blog posts:

Dashboard Server: Working with the PowerShell tile
https://squaredup.com/blog/dashboard-server-working-with-the-powershell-tile/

SquaredUp 5.1 is here
https://squaredup.com/blog/squaredup-5-1-is-here/

If you want to dig a little deeper, check out these Knowledge Base articles:

How to use the PowerShell tile
See article

How to integrate and visualize your external data
See article