Attribute Usage Inspector

This XrmToolBox tool allows you to analyse the utilisation of the columns of a selected table (developed by Tanguy Touzard).

Sometimes, the columns added to the table according to the requirement gathering session may not be relevant anymore and become redundant because none of the users populates those columns. Sometimes, there is a requirement to migrate the system and part of that involves the identification of the columns which are actually used in the system.

To identify such unused columns, you can use this tool to select the table and load the data to see what percentage of the retrieved data has a value in a particular column and if that column is added to any of the forms.

• Tool Information
• Blog mentions
• Video Tutorial (from 15:18), Video 2
• Functionalities
• Inspect the data usage percentage for each column of the selected table (Fig. 1, Pt. 5)
• Identify which columns are added to any of the forms (Fig. 1, Pt. 4)
• Export the data to Excel to do further analysis (Fig. 1, Pt. 1) (Fig. 2)
• Additionally, the tool can
• Define how to query the data (Fig. 1, Pt. 2) (Fig. 3)
• Limit the number rows to retrieve per call (Fig. 3, Pt. 1)
• Limit the number columns to retrieve per call (Fig. 3, Pt. 2)
• Filter the columns to query for data and show (Fig. 3, Pt. 3) (Fig. 4)
• Retrieve data using SQL query for the on-premise environment (Fig. 3, Pt. 4)
• Retrieve data using FetchXML query or system/user view (Fig. 3, Pt. 5) (Fig. 5)
• Filter the table by the display name or the logical name (Fig. 1, Pt. 3)

Fig. 1 - Colour-coded Privileges with ID

Fig. 2 - Attribute Usage Inspector Excel Export

Fig. 3 - Attribute Usage Inspector Settings

Fig. 4 - Attribute Usage Inspector Filter Columns

Fig. 5- Attribute Usage Inspector Retrieve Data using FetchXML

This is part of the #TooLDR series where I test and review the tools for Power Platform. You can check out the information for the other tools on this page.