Video Screencast Help
Endpoint Management Community Blog

Cut Down on SLA Notifications

Created: 11 Jun 2007 • Updated: 11 Jun 2007 • 1 comment
jessedo's picture
0 0 Votes
Login to vote

When we first installed the Altiris Helpdesk solution we created a number of notifications to help enforce SLAs. Though this is a very useful feature of the helpdesk system, it makes for a lot of messages in your inbox every Monday.

We started looking for a way to limit the policies only to run on certain days of the week, but the shared schedules in the notification server don't allow for running on only specified days of the week. Instead, we solved the problem by making a simple modification to the WHERE clause in the SQL that controls the notification.

AND DATENAME(dw,GETDATE()) IN ('MONDAY','TUESDAY','WEDNESDAY', 'THURSDAY', 'FRIDAY')

If you haven't modified the SQL in these policies before here is a quick rundown of how to do it.

  1. Navigate to the notification policy you want to edit.
  2. Click 'Edit Query'.
  3. Add in the SQL above.
  4. Click Finish and save the policy.

Now this policy will only return data if the day it is run on matches what you specified. The days can be replaced as a parameter in your policy (as it was in the example), which makes it very easy to work with. You simply type in the days of the week when you want the policy to return data and on the other days you will not get extra notifications.

Comments 1 CommentJump to latest comment

Tenacious Geo's picture

Maybe I'm not understanding the problem correctly. But it seems to me that to have the policy run on specific days of the week you just have to use a Custom schedule, not one of the shared schedules.

-Geo

+2
Login to vote