Clearing User Notification Settings System Wide

Susan_Nare_(sglcuser16a_-_(deleted))

Greetings:Is it possible to clear all user notification settings system wide? I have a system that was formerly the production system. It is now being used for development. Great because it is chock full of production type data. The pain is that it has notification settings from users on it. I want to blow these settings away. Is this possible to do system wide for all users?Thank you for your time!Susan

Donna Nalls

You can delete the user records from the agentschedule table:delete from agentschedule where agentid = 9999;or to retain admin's and delete all other users:delete from agentschedule where agentid = 9999 and userid != 1000;before doing so, you might want to take a look at the records in the agentschedule table - verify that agentid is 9999.you may also want to check the LL Administration pages to purge any old messages.as with any db process like this, you may want to back up the agentschedule table before the delete, just to be sure. if you are using oracle rdbms, you can do so with:create table agentschedule_back as (select * from agentschedule);