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 50 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 |
|---|---|---|---|---|
| NEQA4904656 | DPM1052312045559 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904657 | DPM1062312006722 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904658 | DPM1052312045538 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904659 | DPM1052510068641 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904660 | DPM1052510068678 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904661 | DPM1052312045516 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904665 | DPM1052307000254 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904666 | DPM1052510068689 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904707 | DPM1052312045566 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904708 | DPM1052312045542 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904710 | DPM1052312045598 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904726 | DPM1052510068684 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904729 | DPM1052312045551 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904730 | DPM1062312006793 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904731 | DPM1062312006799 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904740 | DPM1052307000323 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904765 | DPM1052209004991 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L6_RF_1P_20230626_06.xml |
| NEQA6766502 | DPM1052510068856 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766503 | DPM1052510068843 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766731 | DPM1052510068900 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766734 | DPM1052510068894 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766871 | DPM1052510068848 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766873 | DPM1052510068876 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766937 | DPM1052510068890 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766938 | DPM1052510068819 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766939 | DPM1052510068812 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766950 | DPM1052510068820 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766954 | DPM1052510068869 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766967 | DPM1052510068823 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766968 | DPM1052510068841 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766971 | DPM1052510068807 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766972 | DPM1052510068853 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766973 | DPM1052510068832 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766974 | DPM1052510068839 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766976 | DPM1052510068836 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766978 | DPM1052510068888 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766979 | DPM1052510068846 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766980 | DPM1052510068896 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766981 | DPM1052510068813 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766982 | DPM1052510068861 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766983 | DPM1052510068834 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766984 | DPM1052510068898 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766985 | DPM1052510068803 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766986 | DPM1052510068885 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766987 | DPM1052510068831 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766988 | DPM1052510068886 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766989 | DPM1052510068882 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766991 | DPM1052510068880 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766992 | DPM1052510068881 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA6766993 | DPM1052510068892 | DDZ1513 | Warranty Claims | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |