| Cheshire Cat Computing https://steveshipway.org/forum/ |
|
| CSV files https://steveshipway.org/forum/viewtopic.php?f=21&t=4269 |
Page 1 of 1 |
| Author: | andy-e [ Tue Nov 23, 2010 10:02 pm ] |
| Post subject: | CSV files |
I am using the MRTG Bundle install on a Windows system, and it works very well! I now want to add some graphs that will be based on CSV files that are created automatically. Can you let me know how to construct a .cfg file to do this? I've tried a number of things, but none of them work... Many thanks, Andy E. |
|
| Author: | stevesh [ Wed Nov 24, 2010 10:12 am ] |
| Post subject: | Re: CSV files |
This is not the correct use of MRTG -- with MRTG, it needs to be able to ask every 5min (depending on configuration) and be given a pair of values to add to the RRD, which are then later graphed. You cannot give a whole set of values and have them processed at once. What you could do is to write aplugin for MRTG that processes a CSV file containing one timepoint's data, and have this run every 5min to add the next value. Or, you could create a 'dummy' cfg file used only by the frontend, and then omit MRTG entirely and write your own script to inject the data into the RRD directly -- although in this case, you would need ot be very careful to make sure the RRD is of the same format and configuration as an MRTG-generated one. This would require a fair amount of coding skill, though. If you just want to generate a graph from a CSV file of values, you'd probably be better off using Excel or similar... |
|
| Author: | rthiebeau [ Fri Dec 23, 2011 12:33 pm ] |
| Post subject: | Re: CSV files |
The way i set this up was: Run the perfmon.exe and have it pull the counters you want (cpu, mem, nic, iis, avg disk queue length) at 5 min lets say. Run the perl mkcfg.pl server.csv >server.cfg create a folder at the top of the .cfg etc (i always have to edit the .csv file name and 100 to 1000000) Run the perl indexmaker server.html >server.cfg edit the .html to make sure the file/src/file point to the correct locations. Created a batch file mrtgsnap.bat that has the perl mrtg server.cfg Created a scheduled task to run every 5 minutes and call that batch file which runs the perl mrtg server.cfg |
|
| Page 1 of 1 | All times are UTC + 12 hours [ DST ] |
| Powered by phpBB® Forum Software © phpBB Group http://www.phpbb.com/ |
|