Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials
Store

Time-scale SWQL for Grafana - how to make ?

Hi !

I am totally new in SWQL so I need a little help about .

I use Grafana with a SWIS datasource connected to my SW server. It works fine, I've already made a bit of simple panels in Grafana with a data from SolarWind but I am not keen on enough in SWQL 8( so I faced with some troubles.

Shortly. I have a Cisco WLC controller with a bunch of wireless access points connected to. I get all the info about from Orion.Wireless() tables . But I am stuck with very simple task - to build the graph about a Clients amount on each AP.

I do SWQL on that way

SELECT

ap.Client,

ap.DisplayName

FROM

Orion.Wireless.AccessPoints ap

WHERE

ap.ContorllerID =($ContID) AND ap.ID=($APID)

where $ContID and $APID are two variables defined in dashboard menu and their labels seen in drop-down windows above the panel . they simple define the Controller and a particular AP in it. When I run it against a first visualiser , Table , -I get a current amount of client on a chosen AP as a table. All works fine. But when I try to apply it into a second one - Graph, it draws me nothing. No line at all. Yes, it shows the legend below (DisplayName), yes, it draws on a Y axis a limitation closer to a current value of the Clients , but no points on graph.At all . It is completely empty.

On which way shoud I change my SWQL query ? What on the earth should I use as time ? There are no time or date rows on Wireless Tables..Please, help me out to put my things in order

Thanks in advance.

Find more posts tagged with

Accepted answers

mesverrum

I imagine you can't downsample it because it's not a time series, its just a single point in time. Like i said there is no table that actually records that value historically, they just take the count of the current number of sessions and update the current stat each polling interval. In order to calculate what the "current" value was at some point in the past you would need to look at the historical table I mentioned, sum up the number of sessions that had a start time before the timestamp you want to display, and had an last updated after that time. And you'd need to calculate it for each data point you want to display. It's doable in SQL I'm sure, but it's messy so that was why I avoided it myself.

All comments

mrxinu

It sounds like you're trying to use a line graph where a bar chart would make more sense. You're just looking for the quantities for each, right?

Something like this?

mesverrum

If you want to chart it out over time then you probably need to be looking at this table instead
Orion.Packages.Wireless.HistoricalClients

There is not table actually explicitly tracking the number of connected clients, but that table does show the start and end time of client sessions.

Yours ago I wrote this query to get a fast general idea of whats happening in wifi, but its not an 100% true count since I'm only tracking based on lastupdate timestamps, its really just the number of sessions that ended in a given hour. Never had a strong enough need to actually rewrite it to account for everything correctly.

SELECT count(distinct id)as clients, SSID, DATETRUNC('hour',lastupdate) as [time]
fROM Orion.Wireless.HistoricalClients

group by ssid, DATETRUNC('hour',lastupdate)

a_ver

Hi @mrxinu and @mesverrum !

I apologize for a long time to answer, I just dug the problem down .

@mrxinu no, it isn't the thing I have searched for . I want to show to my customer a graph represents a clients amount changing during a particular time period defined by Grafana . The bar panel isn't the thing either for me

@mesverrum thanks a lot ! Sure I know about the table you noticed. But I need no info from it for now. I suppose your query will be useful for me , this is an actual task too .

So here is my result. Partial, that said

SELECT

a.LastUpdate as time

a.DisplayName

a.Clients

From Orion.Wireless.AccessPoints a

WHERE

a.ContorllerID =($ContID) AND a.ID=($APID)

So it works , but on a very curious way. It shows me on the graph only one point , which correponded to the last time sample and that's all!

When I tried to use downsample() on the way described in a Git document https://github.com/etichy/grafana-swis-datasource

----------------------------------------------------------

SELECT

downsample(a.LastUpdate) as time

a.DisplayName

a.Clients

From Orion.Wireless.AccessPoints a

WHERE

a.ContorllerID =($ContID) AND a.ID=($APID) AND ((time>$__from) or (time<$__to))

-------------------------------------------------------------------------------------

I get an error that downsample() can't parse the LastUpdateValue

And I try to find the reason why

Thanks again

mesverrum

a_ver

Thanks a lot Mark, the @mesverrum !

You are completely right , I need to transfer those data into time-scale format to have a such kind of visualisation.