Discussion Locked

Performance log automation

0 helpful
5 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there a way to automate the importation of performance data to a .csv file, manipulate the data into the desired chart, and have it e-mailed?

5 replies

by bill y the network guy

Scripting is probably the easiest way to get this done. If your running NT server with Option Pack 4, Windows Scripting Host is already on your machine. You can program the script to connect to remote machines, copy the performance log and replace it with a blank one. From there, there is likely a way to convert the data through scripting to .csv, though I've not done it myself. Another option is launching your graphing program (Excel, I guess) and running a macro within, better yet VB or VBA, that will import the file, convert it, add it to the cahrt, and then save the chart. The emailing could be done in the script. I know it sounds a little convoluted, but you're looking for a custom solution to a very specific problem. The best way to tackle it is through scripting and embedded VB.

Hope that helps.

This discussion is closed to new replies.