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:
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'