Skip to main content

Analyze

The Analyze feature in erm4sn provides a set of powerful tools for system analysis, schema consistency checks, and identifying discrepancies across ServiceNow instances. This feature helps administrators and developers ensure data integrity, detect missing elements, and optimize schema structure.

Compare Schemas​

The Schema Comparison tool allows you to compare the structure of your current ServiceNow instance with another instance. This helps identify differences in tables, columns, and attributes, ensuring consistency across environments.

How to Perform a Schema Comparison​

  1. Select a Target Instance

    • Choose a ServiceNow instance to compare your current schema against.

  2. Choose the Comparison Level

    • Attributes: Highlights table columns where attributes differ (e.g., data type, length).
    • Columns: Displays columns that exist in one instance but are missing in the other.
    • Tables: Shows missing tables on either side of the comparison.

  3. Run the Comparison

    • Click the Run button to execute the schema comparison.
    • The results will display differences in a structured format.

  4. Download the Report

    • Click Download to export the comparison results as an Excel sheet for further analysis.

Compare Schemas

Type Consistency​

The Type Consistency tool provides an overview of field type and length combinations across your schema. This helps ensure that similar attributes are consistently defined.

How to Use Type Consistency Analysis​

  1. View Type Summary

    • Browse the list of all detected type and length combinations.

  2. Analyze Specific Types

    • Click on a type name to see where this combination is used across the schema.

  3. Download the Report

    • Click Download to export the results as an Excel sheet for further evaluation.

Attribute Consistency​

The Attribute Consistency tool helps find attributes with similar names that may have been inconsistently defined across tables.

How to Use Attribute Consistency Analysis​

  1. Enable Derived Attribute Analysis (Optional)

    • Select Analyze Derived Attributes to only show attributes in the same hierarchical structure with similar names.

  2. Run the Analysis

    • Click Run to generate a list of attributes with similar names but potentially different definitions.

References​

The References tool helps identify missing or inaccessible referenced tables. This is useful for troubleshooting issues where tables are expected but not found.

How to Use the References Analysis​

  1. View Missing References

    • The tool displays a list of referenced tables that were not collected during data import.

  2. Investigate Missing Tables

    • A missing reference can indicate that the table:
      • Does not exist in ServiceNow.
      • Was not included in the data collection process.
      • Is restricted due to insufficient API credentials.

  3. Resolve Missing References

    • Verify that the table exists and is accessible in your ServiceNow instance.
    • Ensure that the REST API credentials used for data collection have sufficient privileges to read the table.