CODEWITHSUNDEEP
dynamics-crmmicrosoft-dynamics
Callum
Callum

Reputation: 445

How to do a truly global search (across ALL ENTITIES) for a value in DynamicsCRM?

I'm trying to work out how to search for a value in DynamicsCRM that could be sitting in any hundreds of possible entities.

The standard 'global search' function is hopelessly inadequate for this task, as it limits the number of entities that can be searched at a time to 10 (That method is described here).

This is for an online (ie, NOT on-premises) CRM instance. It's a one off search that we'd like a Sys Admin to be able to do.

Help?

Thanks.

Upvotes: 0

Views: 88

Answers (1)

Nicknow
Nicknow

Reputation: 7224

Since it is online you don't have a lot of options. I would request a copy of your CRM database via Microsoft Support. Mount it in SQL Server - if you don't have a local instance of SQL Server create a SQL Server VM in Azure. Then use this answer to search across the database: https://stackoverflow.com/a/436382/394978.

The only alternative is to write a bunch of code to execute the search. The results will be the same but you have to write the code and depending on the size of your CRM database it could be hours to days to search everything.

Upvotes: 1

Related Questions