How big is the CRM database?

As consultants, we often perform an analysis of CRM systems belonging to prospects or customers, perhaps because they have performance issues, they want to upgrade, or we need to understand more about their current implementations.

If the CRM is on-premises, it is useful to find out about which out-of-the-box CRM entities are used, custom entities if any, number of records, and size of tables. You can find out all about this easily through few clicks and without having to write any T-SQL.

Continue reading “How big is the CRM database?”

Prettify Entity Form in CRM Online

Due to popular demand, I have created a separate post for CRM Online. Please see my other post for an earlier version of CRM.

You may find the look and feel of entity forms in Online a bit too plain.

The following customisation attempts to “prettify” them using CSS loaded using JavaScript.

Continue reading “Prettify Entity Form in CRM Online”

Display and Report User Business Units, Teams, and Security Roles

If you need to produce a report to display and audit users’ Business Units, Teams, and Security Roles of your Dynamics CRM, for example to ensure the correct users are assigned correctly before the go-live, then this report may be useful.

Continue reading “Display and Report User Business Units, Teams, and Security Roles”