[influxdb] TICK Script for Disk Usage

[w***@gmail.com]

Hi,

I am creating a script that enables an alert to be send based on predicted disk utilisation in hours, The problem I am having is that I cannot used the vars disk_reamaining.value and rate. Any help would be appreciated.


var historical = batch
|query('select "used" from "telegraf"."autogen".disk limit 1')
.period(1m)
.every(1m)
.offset(5m)
.align()
.groupBy(*)
var current = batch
|query('select "used" from "telegraf"."autogen".disk limit 1')
.period(1m)
.every(1m)
.align()
.groupBy(*)
var disk_remaining = batch
|query('select "free" from "telegraf"."autogen".disk limit 1')
.period(1m)
.every(1m)
.align()
.groupBy(*)
historical
|shift(5m)
|join(current)
.as('historical', 'current')
|eval(lambda: "current.value" - "historical.value")
.as('rate')

disk_remaining
|eval(lambda: "disk_remaining.value" / "rate")
.as('fill_rate')
|eval(lambda: "fill_rate" * 5)
.as('time_to_full')
|eval(lambda: "time_to_full" / 60)
.as('time_in_hrs')

|alert()
.id('/{{ .Name }}/{{ index .Tags "sn" }}')
.details('nothing')
.info(lambda: "time_in_hrs" > 20)
.warn(lambda: "time_in_hrs" > 5)
.crit(lambda: "time_in_hrs" > 1)
.log('/tmp/disk_alert_batch.txt')