Create alert when there are no results from query

%3CLINGO-SUB%20id%3D%22lingo-sub-2812164%22%20slang%3D%22en-US%22%3ECreate%20alert%20when%20there%20are%20no%20results%20from%20query%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2812164%22%20slang%3D%22en-US%22%3E%3CP%3EHi%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20want%20to%20create%20alert%20when%20there%20are%20no%20results%20in%20the%20last%2030%20minutes%20is%20specific%20table.%3C%2FP%3E%3CP%3EHow%20can%20I%20do%20it%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Contributor

Hi,

 

I want to create alert when there are no results in the last 30 minutes is specific table.

How can I do it?

2 Replies

@MatRock345 Write the query in your Analytic rule that would return any row within the last 30 minutes and in the "Set rule logic" tab when you are creating your query  and in the "Alert threshold" section change the "Generate alert when number of query results" drop down to be "is equal to" 0

 

That way the alert will be generated when there are NO events found.