Monday, July 20, 2015

How to Easily Get Record Counts for Entitys in Microsoft Dynamics CRM

You can quickly get record counts for all of your entities if you need to using the RecordCountShapshot table in Dynamics CRM.  You aren't supposed to do select queries against  tables so I wouldn't recommend doing this in an integration or something like that.  But if you need a quick ball park of how many records are in each table, it's not a bad option.

SELECT TOP 1000 [Count]


,entityview.ObjectTypeCode, Name

FROM [TESTCRM_MSCRM].[dbo].[RecordCountSnapshot] , EntityView where entityview.ObjectTypeCode = RecordCountSnapshot.ObjectTypeCode

and count > 0 order by count desc

Here is what the results look like:

-Happy Monday!!


  1. How to write an assignment clear all your doubts regarding assignment writing. It is a daily task in each and every school and colleges. Children need help to write their assignments.

  2. Hello! Thank you for sharing this method, I just needed to get record counts for some of my entities and had no idea how to make it quickly. Using the RecordCountShapshot table in ms dynamcis CRM is really good solution.

  3. Thank you for the useful information, it is very convenient, that it is now easy to find a support in the job. I can use the various services, for example essay service or various support services. It makes our lives more lucrative and makes the job more enjoyable.

  4. Hi guys! At the moment I work part-time here. But I really like programming) I’m totally beginner to programming. I just started) I want to learn C # and now I'm learning MySQL and try to write my first requests to the database. A bit complicated, but for the time being, I can handle it. Maybe 5 - 8 years later I'll meet again working with you in Microsoft))

  5. Hi friends! Glad to read this cool article. I am also working on this topic on the site If you have any questions, always contact us and we will be glad to help you.

  6. Microsoft dynamic CRM is kind of software that every company should have to increase their revenue.

  7. Microsoft dynamic CRM is simply the best software than the salesforce.

  8. Hello! One frinds of mine recommended me to read your post. It hlped me a lot! By the way I also work for one website that help people with writing papers. As for me, it's very interetsing and cool!