Print this page

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

Knowledge Article Number 000213009
Description
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.
Resolution  

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