Analysis

Overview of imported assets, master-data health, and cross-check coverage across warranty and TNB/Trilliant serials.

Assets —

assets

Import batches —

ADF XML uploads

Warranty rows —

dp_warranty

TCM rows —

tcm_records

Last import —

Newest batch

Cross-check health

Nested asset serials matched to warranty (osdiSN) and TCM (serial_number) — same joins as Cross check.

Open Cross check

Matches —

Nested serial in warranty

Warranty not in assets —

osdiSN with no nested match

TNB/Trilliant not exist on ADF —

TCM serial not in assets

Completeness and duplicate signals across assets, warranty, and TNB/Trilliant masters.

Warranty TNB/Trilliant

Missing nested serials —

Empty nested_serial_number

Missing warranty desc —

Missing TCM comments —

Duplicate TCM serials —

Prefix / period breakdowns live on Reports.

Batch volume over the last 14 days and recent import outcomes.

Import history

Batch	File	Saved	Skipped	Status	When