lundi 17 juin 2013

CRM 2011 Outlook : Check who use the add-in


if you need to check the list of users that use the CRM 2011 Outlook Client, you can check in the SubscriptionSyncInfo table on the base <org>_MSCRM.

select c.FullName, a.SubscriptionId, case when b.SubscriptionType = 0 then 'Offline'
when b.SubscriptionType = 1 then 'Outlook'
when b.SubscriptionType = 2 then 'AddressBookProvider'
end as 'Subscription_Type', COUNT (*) as NumOfSyncs,
MAX (a.StartTime) ,
MAX (a.EndTime)
from SubscriptionSyncInfo a
join Subscription b on a.SubscriptionId = b.SubscriptionId
join SystemUserBase c on b.SystemUserId = c.SystemUserId
group by c.FullName, a.SubscriptionId, b.SubscriptionType

Aucun commentaire:

Enregistrer un commentaire