Clearing all Activity Notifications in Infor CRM with a SQL Statement

If you’ve ever imported activities into your Infor CRM (Saleslogix) database, you’ll likely hear from users that they’ve been bombarded with notifications. In some instances, you might want to clear those notifications so newly created activity notifications don’t end up getting lost in them all. Luckily, you can do that with a single SQL statement.

The following SQL statement will clear all activity notifications prior to a certain date. In this case, all notifications before December 31, 2016 will be cleared. Obviously, you could get rid of the where clause for “activity.startdate” to just clear out all notifications, regardless of date. Additionally, you could also add a clause for “activity.userid” to clear notifications for a certain user only if you’d like as well.

update 
	user_activity
set 
	user_activity.alarm = 'F' 
from
	sysdba.user_activity

	inner join sysdba.activity 
	on user_activity.activityid = activity.activityid 
where
	activity.startdate < cast('2016-12-31 00:00:00.000' as datetime) 
	and 
	user_activity.alarm = 'T' 
go

One thing to keep in mind. Activity notifications are cached, so users will need to log out and then back in again before they see the notifications disappear (a refresh isn’t enough).