Need to determine if this is possible.. SQL to Chart

dsyfer

Hello All..

I have looked around and cannot find what I am looking for, so am resorting to asking the community experts.. I have a sql query that returns six columns and 24 Rows.. The column names are ReportHour, PrevDayApproved, PrevDayDecline, Approved, DeclinedEach, reportHour1... Each Row has a value associated with the reporting hour, all from 0 to 24; that i would like plotted in a graph, showing each value. I have someone here that is able to display this date in a graph using ASP but i want to do it in SW... Any thoughts? Is this even possible?

wluther

dsyfer​ If the default/native charts within Orion do not accomplish what you need, then you can certainly use HTML/JavaScript, as well as many other methods, to implement custom charts. Here are a few examples of projects I have worked on within our Orion environment.

These use SWQL, which is basically the SolarWinds version of SQL. (Check it out, if you have not already: GitHub - solarwinds/OrionSDK: SDK for the SolarWinds Orion platform, including tools, documentation, and samples in Powe… )

Using Your Custom HTML Resource To View Events On A Timeline

Using Your Custom HTML Resource To Build A Better Way To Navigate Your Custom Views

Using Your Custom HTML Resource To Properly Display SWQL Query Results

Custom Graphing: Fun With Highcharts

The Query: Retrieving, Formatting, And Storing The Data

Simple Charts I: Graphing A Single Metric On A Single Element Over A Period Of Time

Also, here is a nice post with a bunch of links to different types of custom work.

How to do various customizations with your Solarwinds

See if any of those get you going in the correct direction, and let us know.

Thank you,

-Will