Influx DpGroup and timerange filter
Posted: Tue Mar 16, 2021 11:48 am
Hi,
I have an issue using NGA Influx archiving and the alarm screen (3.17 patch 10).
Filtering by DpGroup or timerange is fine, but filtering by both returns no results.
eg testing the SQL queries directly:
SELECT ALERT '_alert_hdl.._text' FROM 'DPGROUP(_DpGroup00023_Public)'
-> alerts returned
SELECT ALERT '_alert_hdl.._text' FROM 'DPGROUP(_DpGroup00023_Public)' TIMERANGE("2021.03.14 18:00:00","2021.03.15 18:19:00",1,0)
-> nothing
SELECT ALERT '_alert_hdl.._text' FROM '*' TIMERANGE("2021.03.14 18:00:00","2021.03.15 18:19:00",1,0)
-> alerts returned including DPs in the DpGroup
It is also the same result when querying DPs rather than alerts.
I have an issue using NGA Influx archiving and the alarm screen (3.17 patch 10).
Filtering by DpGroup or timerange is fine, but filtering by both returns no results.
eg testing the SQL queries directly:
SELECT ALERT '_alert_hdl.._text' FROM 'DPGROUP(_DpGroup00023_Public)'
-> alerts returned
SELECT ALERT '_alert_hdl.._text' FROM 'DPGROUP(_DpGroup00023_Public)' TIMERANGE("2021.03.14 18:00:00","2021.03.15 18:19:00",1,0)
-> nothing
SELECT ALERT '_alert_hdl.._text' FROM '*' TIMERANGE("2021.03.14 18:00:00","2021.03.15 18:19:00",1,0)
-> alerts returned including DPs in the DpGroup
It is also the same result when querying DPs rather than alerts.