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!
Share the insights across the team
Once you have the visualizations you want, use SquaredUp’s Open Access feature to share your dashboard with the organization.
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
/blog/dashboard-server-working-with-the-powershell-tile/
SquaredUp 5.1 is here
/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
GET STARTED TODAY
Zero to dashboard hero in 60 seconds
Start now with hundreds of customizable dashboards.