How to Find MS CRM Records without Activities using Advanced Find

Advanced Find is a great tool within Microsoft Dynamics CRM that allows users to find records that meet a set of criteria defined. One of the ways you can use the Advanced Find tool is by executing a search based on the activities associated with a specific record. However, if you need to query records that do not have any activities associated with it, you can follow this simple tip in our blog today to still get the results you are looking for. Let’s begin!

Let’s take a look at an example. Say you need to retrieve all Contacts that do not have any activities associated with them. In order to do so, follow the steps below:

1. First, create a static Marketing List.

100115 1336 HowtoFindMS1 How to Find MS CRM Records without Activities using Advanced Find

2. Click on the ‘+‘ sign next to the members grid to manage members.

3. Use Advanced Find to add all Contacts as members.

100115 1336 HowtoFindMS2 How to Find MS CRM Records without Activities using Advanced Find

4. This is what the Advanced Find query to add all active Contacts looks like.

100115 1336 HowtoFindMS3 How to Find MS CRM Records without Activities using Advanced Find

5. Next, select Add all members returned by search to the marketing list and click Add to Marketing List.

100115 1336 HowtoFindMS4 How to Find MS CRM Records without Activities using Advanced Find

6. Above the Members grid, click on ‘+’ to manage members.

100115 1336 HowtoFindMS5 How to Find MS CRM Records without Activities using Advanced Find

7. Select Remove using Advanced Find and click Continue.

100115 1336 HowtoFindMS6 How to Find MS CRM Records without Activities using Advanced Find

8. Next, build another Advanced Find query to fetch all the Contacts with activities as shown below. Click Find.

100115 1336 HowtoFindMS7 How to Find MS CRM Records without Activities using Advanced Find

9. Select Remove all members returned by the search from the marketing list and click Remove from Marketing List.

100115 1336 HowtoFindMS8 How to Find MS CRM Records without Activities using Advanced Find

The list will be updated to only include Contacts with no activities associated. You can then create an Advanced Find to locate all the Contacts that are members of this Marketing List and there you have it!

100115 1336 HowtoFindMS9 How to Find MS CRM Records without Activities using Advanced Find

Please note that since this is a static Marketing List, it can become stale after a while. You should always refresh static Marketing Lists before you use them to insure that the data is up-to-date.

That’s all for today, readers. For more information on CRM, Advanced Find, and other useful tips, feel free to contact us! Also, make sure you check out our blog weekly for the latest news and educational materials.

Until next time, happy CRM’ing!

 How to Find MS CRM Records without Activities using Advanced Find

This entry passed through the Full-Text RSS service – if this is your content and you’re reading it on someone else’s site, please read the FAQ at fivefilters.org/content-only/faq.php#publishers.

PowerObjects- Bringing Focus to Dynamics CRM