Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Chad Miller

Chad Miller is a Senior Manager of Database Administration at Raymond James Financial. Chad has worked with Microsoft SQL Server since 1999 and has been automating administration tasks using Windows Powershell since 2007. Chad is the Project Coordinator/Developer of the Powershell-based Codeplex project SQL Server PowerShell Extensions (SQLPSX). Chad leads the Tampa Powershell User Group and is a frequent speaker at users groups, SQL Saturdays and Code Camps.

Powershell Charting with MS Chart Controls

Richard MacDonald's demonstrates using Microsoft Chart Controls with Powershell in his post, Charting with Powershell. The chart controls are free and work with standard Windows forms. Another nice thing is the ability data bind to any object that implements IEnumerable (arrays, hashes, data tables, etc.). This makes working with the charts particularly easy, just create a hashtable and bind it to the chart data series. Jeffery Snover provides us with a useful bit of code called ConvertTo-Hashtable which does what the name implies. Armed with this information, I thought it would interesting to take the concept of Powershell charting a few steps further and create a reusable charting library, called LibraryChart available on Poshcode. The library implements several features including:
  • Pipe the output of a Powershell command to automatically create a chart.
  • Display the chart in a Windows Form
  • Save the chart to an image file
  • Specify either bar, column, line or pie chart types
  • Display real-time automatic updating charts by passing scriptblock to the function. The scriptblock will execute at the specified interval and display chart updates (think Perfmon)
  • Works with Powershell V1

To use the Library (Note: Requires .NET 3.5 framework):

Here are a few examples:

Create a column chart of process workingset information:

Get-Process | Sort-Object -Property WS | Select-Object Name,WS -Last 5  | out-chart -xField 'name' -yField 'WS'

Save the chart to a file instead of displaying:

Get-Process | Sort-Object -Property WS | Select-Object Name,WS -Last 5 | out-chart -xField 'name' -yField 'WS' -filename 'c:\users\u00\documents\process.png'

Get-Process | Sort-Object -Property WS | Select-Object Name,WS -Last 5  | out-chart -xField 'name' -yField 'WS' -chartType 'Pie'

Produce a real-time line chart of process working set by passing a scriptblock i.e. the Powershell command between the two curly brackets. (Image note shown):

out-chart -xField 'name' -yField 'WS' -scriptBlock {Get-Process | Sort-Object -Property WS | Select-Object Name,WS -Last 1} -chartType 'line'

I'm not entirely happy with the script (uses global variable, hash generation code repeated, pie and line chart appearance could be improved), so if anyone would like to take the charting library even further go for it!

Comments

Posted by roman.zeltser on 26 July 2013

Hi Chad, I happened to search the resources for my project and found your article. I am not sure I understand how to use your solution even if I have Librarychart1.ps1. I am quite new to it. I need to build the pie charts out of the SQL database (I have ready-to-use queries) utilizing the power of PowerShell. Your assistance is greatly appreciated in advance.

Leave a Comment

Please register or log in to leave a comment.