Kaseya Community

Service Automation - Service Desks

  • Check out http://chart.api.google.com  and  developers.google.com/chart  for more detail

    An example of a simple chart is

    https://chart.googleapis.com/chart?cht=p3&chs=250x100&chd=t:22,22,22,4,30&chl=Server|WKS|Mac|Linux|Other

    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

    ExecuteCommandShell

    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

    Paul



    [edited by: Paul Haaker at 4:23 PM (GMT -8) on Feb 3, 2013] Typos
  • 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

    curl.haxx.se/.../manual.html

  • Hi Paul,

    Thank you for the extra info, I will try and look in to this over the next few days.

    Brad

  • Hi Paul,

    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.

    Brad

  • 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 ?

    Regards

    Paul

  • 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

    Paul