Here’s a quick SQL query that will show you who has got what in the calendar:


select userid+' '+rectype, count(userid+' '+rectype) from cal group by userid+' '+rectype order by count(userid+' '+rectype) desc


It’s very simple in that it just shows the type of activity as a single letter rather than trying to translate it.

The main activity types are:

A Appointment
C call
M Email
S Sale
T Next action
O Other action
E Event

Emails with no user attached in Cal are those that are in the Trash folder.