How to use parameters in the dashboard designer?

[Legacy User]

I want to create a single layout with gauges, lines and SQL tables that would apply to different accounts. Today, each account has a "virtual" origin assigned to it (by using the qos_processor). I see there are 5 global parameters available, but I don't know how to use them. One of them is ${origins}.

I need to show bw utilization (one line widget for bits in and other for bits out), and two gauges (availiability and reachability). The thing is that I want the content to be filtered first by origin and then by matching the ifName somehow.

 

How are these parameters populated? Is it possible to fill them in with system variable values?

[Nestor Falcon Gonzalez]

Hello,

 

Parameters under the </> tab are the ones used by default on a dashboard. You can make use of them at anytime while working with your dashboard by using the ${parameter} call.

You can further customize the values of these parameter by adding a context selector.

 

HTH,

Nestor

[Legacy User]

Yes, but how do I specify a regular expression or a string for filtering, let's say, interfaces by their ifName? I know that every customer (account) can only see their devices ("filtered" by origin), but I need to use only a certain interface (FastEthernet0/4 for instance) as a source for each widget, but with different metrics.

Could I create a parameter ${ifNameWAN} which value would be FastEthernet0/4 and use that as a filter?

[Nestor Falcon Gonzalez]

Hello,

 

the parameters you define can only be used in SQL queries that feed the gauges/line charts.

Now, add a context selector to your dashboard. This will enable you to define new parameters (different than the ones defined globally). You can define parameters in 3 different ways: from URL, from SQL data source or manually.

I have defined 2 parameters manually in the image below:

 

 

 

 

The context selector will enable you to choose between the parameters you have defined, and you can even filter among them:

Now you can use these parameters in any SQL query that populates your line charts or gauges like this:

select s.sampletime, s.samplevalue from s_Qos_data d 

join s_qos_snapshot s  

on d.table_id = s.table_id 

where d.source = '${servidor}'...

 

And the data will change dynamically according to what you have selected in the context selector.

In your case you could retrieve the interfaces using a SQL query and use them as parameter in the context selector.

 

Hope this helps,

Nestor

[Legacy User]

Thanks Nestor! I've made linked-selectors also (before reading your answer). I make a query to get devices in one selector, and when I pick one device from that list, the Interfeace dropdown list is filled with the interfaces corresponding to that particular device, so you can create dynamic graphics:

 

List_equipos

select distinct source from s_Qos_Data

where probe = 'pollagent'

and origin like '${origins}'

order by source asc

 

List_interfaces

select distinct d.target from s_Qos_data d

where d.qos like '%INTERFACE%'

and d.source like '${device}'

 

[Nestor Falcon Gonzalez]

Great. Glad it helped and thanks for the feedback.

 

Nestor

[alberto rodriguez]

Is your sql line chart from the picture dynamic to the context selector? Thanks

 

A

[Legacy User]

Yes, it is