Print this page

Use a Query Activity to find Subscribers on the Microsoft Dynamics CRM managed list

Knowledge Article Number 000213009
Creating a Query Activity helps you find Subscribers that are on the Microsoft Dynamics CRM (version 4) managed list within Marketing Cloud and their status.

How to find the Subscribers

1. Create a Data Extension containing fields for:
  • Email Address
  • SubscriberKey
  • Status
2. Create a Query Activity to populate the Data Extension.
3. Use the following SQL syntax in your Query Activity:
SELECT EmailAddress,SubscriberKey,[Status] FROM _Subscribers
WHERE SubscriberType in ('MS CRM Contact','MS CRM Lead','MS CRM Account'

promote demote