Answered by:
CRM 2013 Online

Question
-
Hi ,
I am using CRM 2013 online what are the different ways to get records count in an entity. Is there any tool available for that
Regards,
Naveen M
Naveen Kumar
- Edited by Naveen Mits Thursday, May 29, 2014 1:10 AM
Thursday, May 29, 2014 1:05 AM
Answers
-
Hi Naveen,
You might want to try this out : http://community.dynamics.com/crm/b/crmfranklee/archive/2010/02/23/how-to-obtain-the-total-record-count-in-microsoft-dynamics-crm.aspx
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, May 29, 2014 5:09 AM
- Marked as answer by Jamie MileyModerator Tuesday, January 13, 2015 7:40 PM
Thursday, May 29, 2014 5:05 AM -
The problem is you can only pull 5000 at a time, so you could create a small .NET utility that would pull the data in 5000 record pages and keep a running count. I have done this before. That's the only way I am aware of to do this in Online. In on-prem it's an easy SQL query.
Jamie Miley
Check out RBA Today!
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Marked as answer by Jamie MileyModerator Tuesday, January 13, 2015 7:40 PM
Thursday, May 29, 2014 3:09 PMModerator
All replies
-
Hi Naveen,
You might want to try this out : http://community.dynamics.com/crm/b/crmfranklee/archive/2010/02/23/how-to-obtain-the-total-record-count-in-microsoft-dynamics-crm.aspx
- Proposed as answer by Andrii ButenkoMVP, Moderator Thursday, May 29, 2014 5:09 AM
- Marked as answer by Jamie MileyModerator Tuesday, January 13, 2015 7:40 PM
Thursday, May 29, 2014 5:05 AM -
Hi Naveen,
Using Advance find export to excel is restricted to 5000 records, so
The best way to know the total number of records for an entity would be to create a CRM system report.
Can try this for example: http://mscrmonline.wordpress.com/2010/02/28/how-to-obtain-the-total-record-count-in-microsoft-dynamics-crm/
Regards,
Abdul Raziq
Thursday, May 29, 2014 12:00 PM -
The problem is you can only pull 5000 at a time, so you could create a small .NET utility that would pull the data in 5000 record pages and keep a running count. I have done this before. That's the only way I am aware of to do this in Online. In on-prem it's an easy SQL query.
Jamie Miley
Check out RBA Today!
Check out my about.me profile!
http://mileyja.blogspot.com
Linked-In Profile
Follow Me on Twitter!- Marked as answer by Jamie MileyModerator Tuesday, January 13, 2015 7:40 PM
Thursday, May 29, 2014 3:09 PMModerator