7/10/2025 8:30:33 AM
|
| |
| slxdeveloper.com Community Forums |
|
| |
|
|
The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
Forum to discuss general administration topics for SalesLogix (including LAN & remote topics). View the code of conduct for posting guidelines.
|
|
|
|
Activities (Alarms Tab)
Posted: 18 Dec 07 1:38 PM
|
In Activities section, under Alarms tab, one of our employees has thousands of the same event. I dont know how it was created, and it is odd because it has the same timing. I can right click an alarm event and click delete, and it takes about 2-3 minutes to delete one, but there are over 5000 of these. Can someone suggest how to get rid of all Alarm events for this person and start fresh.
Thank You,
Dharmesh
|
|
|
|
Re: Activities (Alarms Tab)
Posted: 18 Dec 07 5:41 PM
|
If they all have the same activity description I would do something like this:
delete FROM sysdba.ACTIVITY
WHERE DESCRIPTION ='XXXXXXXXX' and userid= 'UXXXXXXXX'
where you fill in the description and userid from your database.
Also, do you have remote databases? If so, then run this statement in the Work Group Administrator
and on all the remotes who might have access to this user's calendar.
A word of caution, this is a statement that will delete all the records in the database that match the where clause, so please run a :
select * from sysdba.ACTIVITY
WHERE DESCRIPTION ='XXXXXXXXX' and userid= 'UXXXXXXXX'
first to make sure that you want to delete those records before you run this.
Good luck!
|
|
|
| |
|
You can
subscribe to receive a daily forum digest in your
user profile. View the site code
of conduct for posting guidelines.
 Forum RSS Feed - Subscribe to the forum RSS feed to keep on top of the latest forum activity!
|
|
|
|
|
|
|
|