Tuesday, April 20, 2010

Who has the Outlook Client Installed

There could be times when you would want the list of User's using the CRM Client for Office Outlook. Here is a small script which you could execute on CRM's Organization database. This script will give you the machine name and user's fullname.

SELECT dbo.Subscription.MachineName,
dbo.SystemUserBase.FullName
FROM dbo.Subscription, dbo.SystemUserBase
WHERE dbo.Subscription.SystemUserId = dbo.SystemUserBase.SystemUserId