Hi,
I would like to create an anomaly detector disk alert when disk is higher than some value. I am trying it using this DQL:
timeseries t_disk = avg(dt.host.disk.used.percent),
filter: {
matchesValue(role, "ORACLE") AND
matchesValue(entityAttr(dt.entity.disk, "entity.name"), "/opt")
}, by:{dt.entity.host, dt.entity.disk}, interval: 1m
| fieldsAdd server = entityName(dt.entity.host)
| fieldsAdd disk = entityName(dt.entity.disk)
| fieldsAdd `disk_used` = arrayAvg(t_disk)
| fieldsRemove interval, t_disk
| join [
timeseries disk.used_sum = avg(dt.host.disk.used), disk.avail_sum = avg(dt.host.disk.avail), by:{dt.entity.disk}
| fieldsAdd total_disk = toLong((arrayAvg(disk.used_sum) + arrayAvg(disk.avail_sum)))
| fieldsKeep total_disk, dt.entity.disk
], on:{dt.entity.disk}
| fieldsAdd `disk_size` = right.total_disk
| fieldsRemove right.dt.entity.disk, right.total_disk
| filter `disk_size` > 5000000000
I am getting some interval error:
But I think issue is another thing. Do you have some suggestion? Have you received that error message before?
Best regards

