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]
,[RecordCountSnapshotId]
,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!!
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.
ReplyDeleteHello! 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.
ReplyDeleteThank 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.
ReplyDeleteHi 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))
ReplyDeleteHi friends! Glad to read this cool article. I am also working on this topic on the site https://writer-elite.com/scholarship-essay/. If you have any questions, always contact us and we will be glad to help you.
ReplyDeleteMicrosoft dynamic CRM is kind of software that every company should have to increase their revenue.
ReplyDeleteMicrosoft dynamic CRM is simply the best software than the salesforce.
ReplyDeleteHello! 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!
ReplyDelete