Blog Archives

Charting and Data Visualization using PowerShell – PSBUG – August 2013


As part of the PowerShell Bangalore User Group meet held yesterday, I had the chance to do my very first session. Although I was quite nervous, I was very excited to talk about PowerShell which is really close to me.

I presented about visualizing data using Microsoft Chart Controls. Most administrators understand the benefits of automation but many fail to showcase the benefits. This is where MS Chart Controls step-in. I believe a visual medium is the most effective way to drive a point; “a picture is worth a thousand words”.

Tagged with: , , , , , , , , , ,
Posted in PowerShell

Working with Perfmon CSV logs in Powershell – Part 2


Before I moved to a new topic; I thought, I would give some background on why I wrote “Working with perfmon csv logs in PowerShell – Part 1“. When you are working in a place where the PerfMon logs are collected religiously and always

Tagged with: , , , , ,
Posted in PowerShell

Working with Perfmon CSV logs in Powershell – Part 1


In this post we explore how to quickly summarize data from perfmon CSV logs using powershell. The problem can be broken down into three different steps:
1. Identify the columns you want to select
2. Restrict the selection of rows to some convenient size using either date or other selection criteria
3. Measure your selection for min, max and average properties.

Tagged with: , , , , ,
Posted in PowerShell