One of the requirements we have from management is to be able to generate graphs from the log results that we get, so they can quickly assess and analyze trends in the test results.
The graph should show: for each error type graph error count vs. time.
So, when extracting the log information, is it better to output the results into a SQL database, or use CSV or XML or Template? The graph would probably be done from Excel.
I can play with these options but I thought I'd check to see if anyone has done this before and if there are any suggestions that will help us get what we need. Thanks!
I'd say CSV would be your best choice. Given a CSV file, you can import it directly into Excel.
Other forum members might have more experience on this, though.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm"
Well I'm doing something similar. I am querying log files from multiple replicated windows media servers. Rather then sending each row to sql I am using logparser to roll up the data into 1 hour chunks of sum, counts and averages. 5 queries all together
into 5 sql tables. This reduces the amount of network traffic greatly for example reducing 26,000 rows being sent to sql to less then a 1,000.
Then I am using chart director (an activeX charting control) to produce the charts on the fly from the sql data for web display.
if you are automating your chart production it almost doesn't matter what format you save it in as long as you can query it via ADO (ODBC/ole db) to get your ranges. I'd imagine that sql would be more efficient tho.
I've also been exploring .Net technology, and apparently there are some drawing classes that can take in XML, CSV or SQL input and produce graphs/charts from them. I will need to experiment with it more but that might be a viable way for me to accomplish
this task.
Ahh, if we only had no deadlines but time to explore and experiment to find the most efficient way to do something, that would be heavenly!
Well to save time and spend $100 on a charting object. I use chart director (http://www.advsofteng.com/) which I have found to be a very solid and well documented app. I have seen that (http://dundas.com/) also now has a chart object out. I havn't used it but
I use thier upload control in lots of web apps and it has performed very well. Either way, they are much faster then drawing
cheers dave
FYI: Log Parser 2.2 has a built-in "CHART" output format (which requires a licensed Microsoft Office installed) that can generate .gif and .jpg chart images on the fly.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Can you give us the syntax and example of the CHART output? I can't find it in the log parser 2.2 help. It sucks that you have to have office installed to use i.
Log Parser 2.2 is not yet available for release, but it will be very shortly.
I am going to check out if there is a beta available for customers.
Well, you don't really need the whole Office, but rather just a LICENSED "Office Chart Web Component" (which ships with Office). It's just a COM dll, but you can not just copy it around: you need to license it on the machine where you copy it over.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Log Parser 2.2 is not yet available for release, but it will be very shortly.
I am going to check out if there is a beta available for customers.
Well, you don't really need the whole Office, but rather just a LICENSED "Office Chart Web Component" (which ships with Office). It's just a COM dll, but you can not just copy it around: you need to license it on the machine where you copy it over.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm
Anonymous
6623 Posts
Which output target format is best to be able to generate graphs from log results?
Feb 10, 2004 05:53 PM|LINK
One of the requirements we have from management is to be able to generate graphs from the log results that we get, so they can quickly assess and analyze trends in the test results.
The graph should show: for each error type graph error count vs. time.
So, when extracting the log information, is it better to output the results into a SQL database, or use CSV or XML or Template? The graph would probably be done from Excel.
I can play with these options but I thought I'd check to see if anyone has done this before and if there are any suggestions that will help us get what we need. Thanks!
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 10, 2004 07:00 PM|LINK
I'd say CSV would be your best choice. Given a CSV file, you can import it directly into Excel.
Other forum members might have more experience on this, though.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm"
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 16, 2004 03:35 PM|LINK
Well I'm doing something similar. I am querying log files from multiple replicated windows media servers. Rather then sending each row to sql I am using logparser to roll up the data into 1 hour chunks of sum, counts and averages. 5 queries all together into 5 sql tables. This reduces the amount of network traffic greatly for example reducing 26,000 rows being sent to sql to less then a 1,000.
Then I am using chart director (an activeX charting control) to produce the charts on the fly from the sql data for web display.
if you are automating your chart production it almost doesn't matter what format you save it in as long as you can query it via ADO (ODBC/ole db) to get your ranges. I'd imagine that sql would be more efficient tho.
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 19, 2004 04:50 PM|LINK
Thanks, Dave! Good suggestion.
I've also been exploring .Net technology, and apparently there are some drawing classes that can take in XML, CSV or SQL input and produce graphs/charts from them. I will need to experiment with it more but that might be a viable way for me to accomplish this task.
Ahh, if we only had no deadlines but time to explore and experiment to find the most efficient way to do something, that would be heavenly!
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 19, 2004 05:10 PM|LINK
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 20, 2004 11:44 AM|LINK
FYI: Log Parser 2.2 has a built-in "CHART" output format (which requires a licensed Microsoft Office installed) that can generate .gif and .jpg chart images on the fly.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 20, 2004 11:50 AM|LINK
Can you give us the syntax and example of the CHART output? I can't find it in the log parser 2.2 help. It sucks that you have to have office installed to use i.
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 20, 2004 11:55 AM|LINK
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 20, 2004 02:09 PM|LINK
Log Parser 2.2 is not yet available for release, but it will be very shortly.
I am going to check out if there is a beta available for customers.
Well, you don't really need the whole Office, but rather just a LICENSED "Office Chart Web Component" (which ships with Office). It's just a COM dll, but you can not just copy it around: you need to license it on the machine where you copy it over.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm
Anonymous
6623 Posts
Re: Which output target format is best to be able to generate graphs from log results?
Feb 20, 2004 02:10 PM|LINK
Log Parser 2.2 is not yet available for release, but it will be very shortly.
I am going to check out if there is a beta available for customers.
Well, you don't really need the whole Office, but rather just a LICENSED "Office Chart Web Component" (which ships with Office). It's just a COM dll, but you can not just copy it around: you need to license it on the machine where you copy it over.
------------------------------
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at http://www.microsoft.com/info/cpyright.htm