Master TNB/Trilliant ↔ ADF Records
Nested assets missing from Master TNB that exist in Master Warranty (dp_warranty.osdiSN).
Total ADF Records
282,900
ADF not in Master TNB
493
Total records Master TNB/Trilliant
282,936
Master TNB/Trilliant not in ADF Records
530
ADF records duplicates
2
Master TNB/Trilliant duplicates
0
2 Nested duplicate rows (1 serial) · No Master TNB serial duplicates .
Showing 41 of 491 Nested (not in TNB) 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 | Warranty | Source file |
|---|---|---|---|---|
| NEQA6865424 | DPM1052510068735 | DDZ1513 | TL244403B | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6865428 | DPM1052510068766 | DDZ1513 | TL244403B | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6865430 | DPM1052510068775 | DDZ1513 | TL244403B | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10103621 | DPM1062312006726 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10103622 | DPM1062312006706 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10103625 | DPM1062312006742 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10103626 | DPM1062312006700 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10103627 | DPM1062312006705 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10103861 | DPM1062312006739 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10103862 | DPM1052312018915 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L43-47_RF_1P_20240216_43.xml |
| NJAA10103869 | DPM1062312006710 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10104093 | DPM1062312006707 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10104094 | DPM1062312006735 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106681 | DPM1062312006741 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106692 | DPM1062312006762 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106693 | DPM1062312006681 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106697 | DPM1052510068644 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10106698 | DPM1062312006709 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106703 | DPM1052510068655 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10106704 | DPM1052510068637 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10106709 | DPM1062312006744 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106711 | DPM1062312006743 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106725 | DPM1062312006701 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106739 | DPM1062312006752 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10106770 | DPM1052510068642 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10106832 | DPM1052510068635 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10106888 | DPM1062312006708 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10107167 | DPM1062312006694 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10107180 | DPM1062312006712 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10107221 | DPM1062312006702 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10107223 | DPM1062312006749 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10107229 | DPM1062312006733 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10107231 | DPM1062312006760 | DTZ1513 | Warranty Claims | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NJAA10108266 | DPM1052510068643 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108267 | DPM1052510068633 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108272 | DPM1052510068638 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108273 | DPM1052510068639 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108274 | DPM1052510068649 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108278 | DPM1052510068636 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108279 | DPM1052510068634 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NJAA10108280 | DPM1052510068640 | DDZ1513 | List from Triliant - Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |