Dashboard - Chart with parameters from Selector

[Asi Aker]

Hello,

 

I define new selector with 2 context, each one of them is an SQL query.

The first one pull list of servers and the second pull from the server list of metrics.

 

Now, i create new Chart which working with SQL query based on the 2 parameters from the Selector which does not works.

 

When i replace one of the parameters by any string the query return valid result and i can see a new graph, but when there are 2 parameters Query test not return any result.

 

Any idea how to resolve it ?

[RENATO ALMEIDA DE OLIVEIRA]

Hello,

   Could you post your query?

[Asi Aker]

Hi,

 

The 2 parameters are :

'${host}'

and

'${platform}'

 

if i will replace '${platform}' with and string the query will return result.

( both selector parameters are not empty ) 

 

The query is : 

select qosdata.samplevlaue, qosdata.samplevalue, ci.ci_name

from S_QOS_DEFINITION def, S_QOS_DATA qos, CM_CONFIGURATION_ITEM_METRIC, metric, CM_CONFIGURATION_ITEM ci, RN_QOS_DATA_0003 qosdata

where def.name like 'QOS_TEMP1' and def.qos_def_id = qos.qos_def_id

and metric.ci_metric_id = qos.ci_metric_id and ci.ci_id = metric.ci_id

and qosdata.table_id = qos.table_id and qos.source = '${host}'

and ci.ci_name = '${platform}'

and qosdata.sampletime > DATEADD(DAY,-1.GETDATE())

and qosdata.table_id =  

         (select top 1 table_id from RN_QOS_DATA_0003 

            where sampletime = 

                           ( select max(sampletime) from RN_QOS_DATA_0003 where qos.table_id = table_id) 

            order by samplevalue desc )

order by 1

[RENATO ALMEIDA DE OLIVEIRA]

How do you provide data to your context selector? and have you already tested the query by replacing the parameter by a valid data on both where's ( qos.source = 'HOST_A' and ci.ci_name = 'Host_name' )?

[Abel Leyva]

Can you post the 2 SQL queries you are using in your context selector? Does the value of the 1st Query feed into the 2nd Query so that you are only pulling metrics for that server? 

 

Also I am a little curious about how you have your query structured. If you are pulling server metrics I would leverage s_qos_data and link table_id to a view.

[Asi Aker]

Thanks,

Problem resolved.

I run each query ( One by One) and check the data that i pass, there was an error with one of the column that i choose which return incorrect data for the next query.