I am using Influxdb and Grafana where i am creating alerts using flux query . below is sample data on which we are writing queries and getting details.
“CPU_RAM”: 27.8 so on
If we add fields like misn id, time, date then only we are getting them in labels(preview alerts/message for alerts), problem is if we add time in Tags, alerts starts checking and generating alert for every 1 second rather than going with conditions.
How do I get time and date in my alert message? Please suggest @scott @Anaisdg
@Bhoomika_Patel What does your Flux query look like?
Ok, it looks like you’re generating the alert using Grafana’s alerting system. I wish I knew more about templating Grafana alerts, but I do not. You may try looking on the Grafana community forum.
If you were sending the alert with raw Flux, that’s something I could help out with.
Not an expert, but consider:
1 remove the aggregatewindow line in your flux query since you appear to be looking for “last”
2 remove the group by time interval - This should leave time in your result.
3 your B clause can be eliminated since your flux query will return “last” grouped by all TAGS.
If you have extraneous tags consider un-grouping in flux with: |> group()
Not sure what you’re trying to accomplish with your expression $B==1 I would think you want $B > threshold value or < some threshold.
…some of these new tools are definitely worth experimenting with. Good luck
@QuantEnabler Thank you so much for suggestions