SolarWinds Orion Custom Chart SQL/SWQL Help

donaldt

Hello,

I am trying to create a chart based some custom SAM components I have set up.

When I try to set up the chart I get a "Data is not available" message.

This is the SWQL query I have right now and the query is valid, as I receive results from the query.

select timestamp, maxstatisticdata from orion.apm.chartevidence2 where componentid = 108559

This is settings that I have so far.

The data is grouped by timestamp.

The Legend shows the timestamp.

Time period is the last 24 hours.

Sample interval is 10 minutes, which is a slower frequency than the SAM Component polling.

Does anyone have any ideas what I am doing wrong?

I have checked serveral thwack forums and haven't found my answer.

Thank you,

Find more posts tagged with

custom charts

sql

Accepted answers

All comments

donaldt

NVM, I figured it out.

There needs to be at minimum 3 columns to the SWQL/SQL query: a timestamp, something to group by, and the statistic data you want to chart.

My problem was I excluded the "something to group by" as I filtered it out to a single component I needed.

Here is what I got for all those struggling in the same area.

adam.beedell

Hi There,

Very few threads on this sort of question - Any other pratical advice you've come across since you were troubleshooting this?

I've got a query i'd like to graph, i've got my time column and a statistic, however I want to COUNT DISTINCT and so i've already got a rollup in place, I think this is what's causing me difficulty. Had any luck with that sort of thing?