Hello all,

finally the parameter ist (here Node Group selection) is shown, but has no affect on the widget. Perhaps someone has an idea about what is wrong in this query in regards to the node group parameter:

SELECT count (distinct nodeuuid) AS NumberOfNodes,

  ts AS Date,

  AVG(Avail) AS avgMaxAvailability,

  AVG(Reach) AS avgMaxReachability

FROM (

                              SELECT DISTINCT node_unique_id AS nodeuuid

                                            ,nodename

                                            ,ts

                                            ,round(avg(availUtil), 2) Avail

                                            ,round(avg(reachUtil), 2) Reach

                              FROM (

                                            SELECT chmet.node_unique_id,

                                                           chmet.node_name AS nodename,

                                                           chmet.timestamp_tz AS ts,

                                                           date_part('epoch', ${${nomcalendar:start}}::timestamp)::INT startdate,

                                                           date_part('epoch', ${${nomcalendar:end}}::timestamp)::INT enddate,

                                                           node_availability_max_pct availUtil,

                                                           node_reachability_max_pct reachUtil

                                            FROM nom_component_health_1h chmet

                                            WHERE timestamp_utc_s >= startdate AND timestamp_utc_s < enddate

                                                           AND (

                                                                          ${ 'ALL' = ${ uifnodegroup}}

                                                                          OR chmet.node_unique_id IN (

                                                                                         SELECT DISTINCT ngroup.node_unique_id

                                                                                         FROM nom_node_group_relation ngroup

                                                                                                       ,(

                                                                                                                      SELECT max(collection_timestamp_s) ngmaxtime

                                                                                                                                     ,node_unique_id

                                                                                                                      FROM nom_node_group_relation ngroup

                                                                                                                      GROUP BY node_unique_id

                                                                                                                      ) ngmax

                                                                                         WHERE ngmax.ngmaxtime = ngroup.collection_timestamp_s

                                                                                                       AND ngmax.node_unique_id = ngroup.node_unique_id

                                                                                                       AND ${ ngroup.node_group_name IN (${ uifnodegroup}) }

                                                                                         )

                                                                          )

                                            ) memutil

                              GROUP BY node_unique_id, nodename, ts

                              ) Avail

GROUP BY ts

ORDER BY ts desc

Thanks and best regards

Allessandro

Hello all,

finally the error was found:

the spaces in the variables are not correct. If they are removed, the query works:

(${ 'ALL' = ${ uifnodegroup}} must be

(${ 'ALL' = ${uifnodegroup}} and

AND ${ ngroup.node_group_name IN (${ uifnodegroup}) } must be

AND ${ngroup.node_group_name IN (${uifnodegroup}) }

This query enables the customer to show the availability and reachability over time.

Thanks to OT support.

Best regards

Allessandro