How to get the number of Tables and their records information in MSCRM On-premise?

Follow the below steps to get the volume of Tables,

Step 1: Open MSCRM SQL Database.

Step 2: Under Databases, select the required <CRM_Org_Name>_MSCRM database. Right click on it and click on Reports -> Standard Reports -> Disk Usage by Table.

Disk Usage by Table

Step 3: Disk Usage by Table report will be displayed as shown below.

Disk Usage by Table Report

Other way to do the same is,

Step 1: Select the required MSCRM database. Click on F7 or View -> Object Explorer Details.

Disk Usage by Table - View Object Explorer Details

Step 2: Object Explorer will be opened in a new window. Right click on the header to select the required data columns to be displayed as shown below.

Disk Usage by Table - Object Explorer Details

Hope you got the results successfully :):):)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.