Master TNB/Trilliant ↔ ADF Records

Nested assets missing from Master TNB that do not exist in Master Warranty (dp_warranty.osdiSN).

Total ADF Records 282,900

Non-empty nested serials

ADF not in Master TNB 493

In warranty 491 Not 2

Total records Master TNB/Trilliant 282,936

Non-empty serials

Master TNB/Trilliant not in ADF Records 530

In warranty 220 Not 310

ADF records duplicates 2

1 serial View

Master TNB/Trilliant duplicates 0

0 serials View

2 Nested duplicate rows (1 serial) · No Master TNB serial duplicates .

Showing 2 of 2 Nested (not in TNB) not in Master Warranty . Join: assets.nested_serial_number = tcm_records.serial_number · Warranty: osdiSN . Related: Records, Master TNB, Master Warranty, Cross check. Export builds a workbook in small chunks.

Nested / serial	Meter serial	Class	Source file
NEQA5673992	DPM1062403005999	DTZ1513	ADF_DT_DPM_L8-13_RF_3P_20240820_13.xml
NJAA10455842	DPM1062411000763	DTZ1513	ADF_DT_DPM_L1-2_RF_3P_20250206_01.xml