Create a scheduled alert which triggers mail to some id

[chitreshakumar]

I want to create an alert .If any of the field is missing the values the search will output the table with all the values with missing particular field values .Then I need to send an mail whenever this alerts run.My requirement is run it daily and the output to the mail in csv format .
My search is returning the values when running .But the alert is not triggering when the number of result is greater than zero.

[nickhills · Accepted solution]

I think it maybe helpful if you can provide some sample data, but let me give this a go anyway:

If I have understood, you have a search which generates a table of results. You want to trigger an alert if any field in the table is empty?

<your search> |table _time <your field>

What you can do is fill empty fields with a known value, which you can then search for, so your search would now be

<your search> |table _time <your field>|fillnull value="Data Missing"|search <your field>="Data Missing"

This will now render you a table of rows only where a field is missing.
An alert >0 can now be set as a threshold