Dependency Identifier

This XrmToolBox tool allows you to generate the list of dependent components for multiple tables and export it to an Excel/.csv file (developed by Danish Naglekar and contributed by Arun Vinoth Thiyagarajan and Linn Zaw Win).

Checking dependent components using out-of-the-box functionality in the solution explorer can only show dependencies for one table at a time and the list cannot be exported.
To find out the dependent components for multiple tables at one go, you can use this tool to select multiple tables to generate dependencies and export the result to an Excel file.
  • Tool Information
  • Functionalities
    • Generate the list of dependent components (Fig. 1, Pt. 2)
      • Load the list of all tables (entities) in the environment (Fig. 1, Pt. 1)
        • Filter the list of tables by schema name or display name (Fig. 1, Pt. 5)
        • Select the tables to generate dependencies (Fig. 1, Pt. 6) or select all tables in the filtered list (Fig. 1, Pt. 7)
        • View the list of selected tables (Fig. 1, Pt. 9) and clear the selection (Fig. 1, Pt. 8)
      • Select an option to generate a list of all the dependencies for the selected tables or only those that could prevent deleting the selected tables (Fig. 1, Pt. 4)
      • Generate the list of dependent components (Fig. 1, Pt. 2)
      • View the list of dependent components of the selected tables (Fig. 1, Pt. 10)
        • View the details of the dependent component in the Dependent Description column (e.g. table of the dependent column component, column display name, etc.) (Fig. 1, Pt. 11)
      • Export the result to an Excel or CSV file (Fig. 1, Pt. 3)
    • Additionally, the tool can
      • Show the number of dependent components (Fig. 1, Pt. 12)
      • Show the tables in two separate sections (Unmanaged and Managed) (Fig. 1, Pt. 13)

    Fig. 1 - Dependency Identifier

    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.

    Comments

    Popular Posts