Audit tool for Migration Completeness

Problem/Motivation

User Story: As a site administrator, I can see if there are any missing content records that have failed to be migrated so that I can ensure that the Drupal DAM actually contains all records it should.

This tool should be:

runnable from a cron process on a (TBD) basis.
runnable on demand from the command line and output a list of found records.

(Reach? Gold plating?) When run, will populate data in Drupal that can be surfaced via a view in the admin pages so that editors/administrators can see what’s missing even if no console/cli is available to them.

Steps to reproduce

Attempting to understand if everything has been imported.

Proposed resolution

Suggested approach (not triaged or discussed):

Create a tool (background script/drush command) that:
1. Gathers a list of all SystemIdentifiers in Cortex that should be available for migration.
2. Gathers list of all system identifiers in Drupal
3. Calculates an intersection of missing items from Cortex that should exist, but doesn’t.

Remaining tasks

User interface changes

Add a new report summary page?

API changes

A new API method to request all available System ID values.

Data model changes

Possibly somewhere to store/cache the results.