Hello! I’m using Kapacitor 1.3 and InfluxDB 1.2. I would like to write a .message() an http link giving the path to a Grafana panel. The problem is the two time formats are completely different: {{ .Time }} in my TICKscript gives a time formatted like 2017-07-21 14:56:00 +0000 UTC while Grafana uses in its URL unix epoc format like 1500649601. Below the relevant part of my script: // Deadman |deadman(1.0, 2m) .id('deadman') .idTag('id') .levelTag('level') .message('http://localhost:3000/dashboard/db/tacker_alert?orgId=1&from={{ .Time }}-3h&to={{ .Time }}') .log('/tmp/deadman_alert.log') Is that possible to convert from one format to another in the TICKscript? Thanks!

It not currently possible but has been requested before. Get unix timestamp from `time` var for alert messages. opened 11:02PM - 03 Jun 16 UTC (UTC) [nathanielc] nathanielc new-feature The notification contains a link to a Grafana dashboard. Is there a way to add t…he timestamps to a link? i.e. `http://192.168.1.10:3000/dashboard/db/device_1_live?from=1462448901244&to=1462452501244` My message now: > .message('Cycle failed. Current cycle {{ index .Fields "Cycle" }}. Total cycles failed: {{ index .Fields "TestFailed" }}. Cycle failed on device Device_1. for details!') I want to know if there is a way to calculate the value of from and to using TICK. I found something here but I don't know if this is what I need. If yes can you post an example? The ideea is that I want to add a link to Grafana to see some hardware metrics when a test fails and I need the timestamps. Thanks again. From @bogdanveres in #508 I see that you just found that issue…

I’ve used following workaround to get the timestamp in unix time: using eval and lambda to create new field called timestamp and then you can reference to it as to any other field in the alert.message(): |eval(lambda: int(unixNano("time")/1000000000)) .as('timestamp') |alert() .message("Current timestamp is {{ index .Fields "timestamp" }}") Hope this saves some time to others.

Is formating time in InfluxDB/Kapacitor possible?

Systems

laeis July 21, 2017, 3:27pm 3

Ok @nathaniel thank you!
I’ll try a UDF then

Alert to detect wrong timestamp

Topic		Replies	Views
X509 Certificate time stamps Kapacitor kapacitor	5	862	November 5, 2020
Using alert time or value timestamp in message Kapacitor kapacitor	5	1511	October 23, 2018
Alert to detect wrong timestamp Kapacitor timestamp	3	56	December 11, 2024
Timestamp insert and show it on the grafana Store	1	2257	March 4, 2020
Kapacitor \| How to change alert message duration format Systems kapacitor	5	648	September 13, 2022

Is formating time in InfluxDB/Kapacitor possible?

Related topics