In my earlier post “Slicing and dicing with LogParser & VBA” I had mentioned that LogParser is really a slick Microsoft utility that can be used to obtain information on files, event logs, IIS logs etc. Continuing on the journey in LogParser I came to realize that you can also create cool charts with output of LogParser which can be either a line graph, a pie chart , a 3D pie chart a 3D bar chart etc. The options are many. So I started to play around with the utility.
To create a chart you can run the command from a LogParser prompt. Some samples are shown below
LogParser “SELECT TOP 10 TO_LOWERCASE (Name) AS NewName, Size INTO .\chart.gif, Path, LastWriteTime FROM ‘” & files & “‘ WHERE NOT Attributes LIKE ‘%D%’ AND NOT ATTRIBUTES LIKE ‘%H%’ ORDER BY Size DESC ” & “-chartType:column3D -i:FS –chartTitle: “My chart”
This will create a gif file with a 3D bar chart with the top 10 files by size
Similarly you could also create a 3D pie chart as follows
LogParser “SELECT TOP 5 Name, Size INTO c:\Chart.gif FROM C:\*.* ORDER BY Size DESC” -chartType:PieExploded3D -i:FS
However I wanted to create these charts in a HTA application and display it dynamically along with the output of LogParser. Thankfully the procedure is very similar. Here is what you need to do for this.
To do this you need to set up the environment as below. I have used VBscript.
Set objLogParser = CreateObject(“MSUtil.LogQuery”)
Set objInputFormat = CreateObject(“MSUtil.LogQuery.FileSystemInputFormat”)
Then you need to specify the chart options
Set objOutputChartFormat = CreateObject(“MSUtil.LogQuery.ChartOutputFormat”)
objOutputChartFormat.groupSize = “400×300”
objOutputChartFormat.fileType = “GIF”
objOutputChartFormat.chartType = “Column3D”
objOutputChartFormat.categories = “ON”
objOutputChartFormat.values = “ON”
objOutputChartFormat.legend = “ON”
Finally create a LogParser query and execute it as shown below where “topN” & the directory path “files” is taken as input from the user
strQuery1 = “SELECT TOP ” & topN & ” Name, Size INTO c:\tes\filesize.gif FROM ” & files & ” WHERE NOT Attributes LIKE ‘%D%’ AND NOT ATTRIBUTES LIKE ‘%H%’ ORDER BY Size DESC ”
objOutputChartFormat.config = “c:\test\FileSize.js”
Set objRecordSet1 = objLogParser.ExecuteBatch(strQuery1, objInputFormat , objOutputChartFormat )
// Set the title above the chart.
chart.HasTitle = true;
chart.Title.Caption = “Top N files by size”
// Set the border style for the chart.
chartSpace.Border.Color = “#000000”;
chartSpace.Border.Weight = 2;
// Change the background color for the plot area.
chart.PlotArea.Interior.Color = “#f0f0f0”;
// Set the font size for the chart values.
chart.SeriesCollection(0).DataLabelsCollection(0).Font.Size = 6;
// Set the caption below the chart.
chartSpace.HasChartSpaceTitle = true;
“This chart shows the Top N files by file sizes in the specified directory “;
chartSpace.ChartSpaceTitle.Font.Size = 10;
chartSpace.ChartSpaceTitle.Position = chartSpace.Constants.chTitlePositionBottom;
// Set the style and caption for the Y axis.
chart.Axes(0).Font.Size = 8;
chart.Axes(0).HasTitle = true;
chart.Axes(0).Title.Caption = “File Name”;
chart.Axes(0).Title.Font.Size = 9;
// Set the style and caption for the X axis.
chart.Axes(1).Font.Size = 7;
chart.Axes(1).HasTitle = true;
chart.Axes(1).Title.Caption = “Size in bytes”;
chart.Axes(1).Title.Font.Size = 9;
Lastly to display the chart dynamically as it is created in the HTA file do the following
imagearea.innerHTML = “”
where imagearea will be specified in the HTML portion as
where filesize.png is any image prior to the creation of the chart through LogParser.
A sample output is shown below
LogParser charts are really cool and well worth the effort!
Brewing a potion with Bluemix, PostgreSQL, Node.js in the cloud
A Bluemix recipe with MongoDB and Node.js A Cloud medley with IBM Bluemix, Cloudant DB and Node.js
Rock N’ Roll with Bluemix, Cloudant & NodeExpress
You may also like
– A crime map of India in R: Crimes against women
– What’s up Watson? Using IBM Watson’s QAAPI with Bluemix, NodeExpress – Part 1
– Bend it like Bluemix, MongoDB with autoscaling – Part 1
– Analyzing cricket’s batting legends – Through the mirage with R
– Masters of spin: Unraveling the web with R
6 thoughts on “Adventures in LogParser, HTA and charts”