Verifying relationships

Verification for relationships queries and verifies foreign keys in all model and intersection tables.

With the repair option enabled, the verification for relationships removes child objects if a parent object does not exist in the database, and clears invalid foreign key values for relationships that are defined as being not contained. It might also delete a significant number of low-level configuration items. However, if the items do not have a parent object, they can be safely removed.

To verify relationships, run one of the following commands:

  • verify-data.sh -v ro [-a repair]
  • verify-data.bat -v ro [-a repair]