I am providing below a summary of my query:
"|Query for calculating the number of days in a week|append[|Macro for bringing out latest values from TicketMaster source]
|joining a primary key with another macro for calculating booked hours of respective employee|eval Email=employee+"@domain.com"|
A Search command to extract those employees from the table whose booked hours is less than working hour
note:working hours is calculated from the first statement of the query "Query for calculating the number of days in a week"."
This query gives a table which contains Employee Id,booked hours ,working hours respective domain and email id along with their supervisor's Id.This sends an alert to those employees who are mentioned in the table (which is generated by above query).
Here are my mail settings:
Expiration:after 24 hours
Severity:Critical
Schedule type : Cron
Cron Schedule:runs the alert every day except weekends "10 12 * * 1-5"
alert mode:Once Per Result
alert conditions:Always
Throttling checkbox:not checked
Alert Actions checkbox:checked
To field: $result.Email$
cc:$result.SupervisorId$
... View more