Check out http://chart.api.google.com and developers.google.com/chart for more detail
An example of a simple chart is
Just paste the above into your browser and see what happens
The trick is having this graph saved as a image file so it can then be included in your notes
The command used in the kaseya SD script would be somthing like
cmd /c "[=userprofilefolder=]\..\webpages\install\curl.exe" "chart.googleapis.com/chart|WKS|Mac|Linux|Other" -o "[=userprofilefolder=]\[$TicketId$]-Random-image.png"
As this actually runs on the Kaseya Server you need to define using the userprofile where to store the image
Then to add the file just created to your ticket note use an Add Note step with
<img src="/images/chartimages/[$TicketId$]-Random-image.png" width="300" height="225" alt="" />
This is in theory how it works .. I'm just testing it and will try and post an actual working example ( with some hard coded values for the chart)
In a real situation you need to query the SQL database for the actual values you intend to graph
Here's another link to check out as it explains how Curl.exe can be used to output to a file the content of a webpage.
i.e. using the -o option
Thank you for the extra info, I will try and look in to this over the next few days.
Just wanted to thank you again for your advise, I have now managed to implement automated graphing for all of our customers.
I found this link very useful in generating the correct chart types and URL to use with curl developers.google.com/.../chart_wizard
The following link is the VBScript I wrote to record the CPU temperature to a CSV which runs hourly and downloads a graph of the previous months CPU temperatures on the first of every month. It will also echo the current CPU temp for use in agent procedures. https://www.box.com/s/ffs8a55m44aa8rlkaice I will leave the script on box.net until I find a better location to share this file from.
The VBScript requires OpenHardwareMonitor to be running when executing the script.
Currently we only monitor 1 CPU core as I don't have time to develop the script further, but it gives us a good idea of when a customers server room is too hot.
Thanks Brad. Often we know in principal how something works .. but never find the time to actual put the theory into practice. I've download your sample VB and will step thru the Google API wizards as well.
Not sure though what you mean when you say "..requires OpenHardwareMonitor to be running.."
Is this a particular Monitorset you are using to capture the CPU data ?
Aha .. just worked out OpenHardwareMonitor is an App from openhardwaremonitor.org
What I want to do is use the Google API to retrieve data from the actual Kaseya Database ie the past 30 days % CPU time which I've gathered via a kaseya Monitor .. then turn these values into "varTempData" and pass it to Google API
This way I should be able to use the same method for any monitor set gathered historic data