×

Warning message

  • Cisco Support Forums is in Read Only mode while the site is being migrated.
  • Cisco Support Forums is in Read Only mode while the site is being migrated.

Bulk Message Notification Schedule Change

Answered Question
Oct 20th, 2005
User Badges:

Jeff,


Do you have any tools available to make bulk Message Notification Schedule changes to subscribers? I need to expand the schedule from the defaults to 6am to 6pm. We were not aware of the requirements until after all the subscribers had been created, so the template did not contain the correct time. I have modified it for future users, but would like to be able to change the subscribers (1000) in bulk rather than by hand. Using Unity 4.05.


Thanks!!


Adam

Correct Answer by lindborg about 11 years 10 months ago

OK, if you mean 6am to 6pm M-F (I'm assuming weekends are off) then you can use the following query by opening up the Data Link Exporer in your Tools Depot and selecting View | Query Builder:


UPDATE NotificationRule

SET DlvruleSchedule='1f06001800'


The "1f06001800" means monday through friday 6am to 6pm - if you need all 7 days I can get you that string instead.


This will update all notification devices for everyone across the board.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 5 (1 ratings)
Loading.
lindborg Thu, 10/20/2005 - 10:54
User Badges:
  • Cisco Employee,

No, the user interface to cram schedule editing into bulk edit was too much (each device can have it's own schedule and the on/off schedule stuff is a little gnarly).


However, the scheule infromation is stored in a string (it uses tricky binary masks to pull the on/off/active info off of it) - so what you could do is setup one device with the schedule you want to apply to everyone and issue a fairly simple SQL query to update all devices in one shot using CUDLE.


If it's going to be a simple blast to update the schedules on all devices for all users, this will work - if you need to get fancier and preserve schedules on some devices for some users, this gets a lot harder.


Let me know if you can do the simple blast method and I'll post the update query here for you to use. Be aware TAC isn't going to touch this with a 10 foot pole - but it's not tough. Just get a DiRT backup before you do anything with the DB.

mwadam Thu, 10/20/2005 - 13:06
User Badges:

Jeff,


Thanks very much for the reply.


Yes I will be updating every subscriber to one schedule, 6am - 6pm. No exceptions. I can set one subscriber to the schedule and use it as the source for the update.


I understand TAC's position, but sometimes you gotta do what ya gotta do.


I will be looking forward to you posting the update query.


Thanks!!!


Adam

Correct Answer
lindborg Thu, 10/20/2005 - 14:06
User Badges:
  • Cisco Employee,

OK, if you mean 6am to 6pm M-F (I'm assuming weekends are off) then you can use the following query by opening up the Data Link Exporer in your Tools Depot and selecting View | Query Builder:


UPDATE NotificationRule

SET DlvruleSchedule='1f06001800'


The "1f06001800" means monday through friday 6am to 6pm - if you need all 7 days I can get you that string instead.


This will update all notification devices for everyone across the board.

mwadam Sat, 10/22/2005 - 11:19
User Badges:

Jeff,


Thanks, it will be next week before I can get back to work on this site, but I will implement and let you know how it goes.


I appreciate it!!


Adam

mwadam Sun, 11/13/2005 - 17:20
User Badges:

Jeff,


Sorry it has taken me so long to get back to you, just now getting time to implement the change. It worked perfectly! Not that I expected anything less. I really appreciate it! Now, just one more thing. I tested this change on my test system to make sure I wasn't going to have any problems, now all of my schedules are off. Can you give me the string to change everything back to the defaults? Again, I appreciate your help!


Thanks!!!


Adam


lindborg Mon, 11/14/2005 - 08:01
User Badges:
  • Cisco Employee,

The string for the notification rule for M-F, 8am to 5pm is "1f08001700"

Actions

This Discussion