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 |
|---|---|---|---|---|
| NEQA4904125 | DPM1052312045549 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904126 | DPM1052510068711 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904127 | DPM1052307000100 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904128 | DPM1052510068646 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904129 | DPM1062312006796 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904130 | DPM1052307001147 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L8_RF_1P_20230927_08.xml |
| NEQA4904131 | DPM1052312045579 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904132 | DPM1052312045586 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904135 | DPM1062312006782 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904136 | DPM1052307000330 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904137 | DPM1052307000357 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904138 | DPM1052312045597 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904139 | DPM1052307000364 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904141 | DPM1052510068691 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904142 | DPM1052209004996 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L6_RF_1P_20230626_06.xml |
| NEQA4904145 | DPM1052510068682 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904146 | DPM1052510068654 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904148 | DPM1062312006753 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904149 | DPM1052510068663 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904150 | DPM1052510068710 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904151 | DPM1052307000387 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904152 | DPM1052312045514 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904153 | DPM1052510068665 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904154 | DPM1052307000508 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904155 | DPM1062312006730 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904156 | DPM1052312045569 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904157 | DPM1052312045581 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904158 | DPM1052510068656 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904159 | DPM1052312045509 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904160 | DPM1052510068693 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904161 | DPM1052312045593 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904162 | DPM1052307000295 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904163 | DPM1052209004979 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L6_RF_1P_20230626_06.xml |
| NEQA4904164 | DPM1052312045574 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904165 | DPM1052312045567 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904166 | DPM1052510068677 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904168 | DPM1052307000041 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904170 | DPM1062312006777 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904173 | DPM1052510068667 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904174 | DPM1052312045541 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904196 | DPM1052307000381 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904235 | DPM1052312045511 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904262 | DPM1062312006784 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904266 | DPM1052510068675 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L151-162_RF_1P_20260507_162.xml |
| NEQA4904267 | DPM1052307002235 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L9_RF_1P_20230927_09.xml |
| NEQA4904268 | DPM1052312045512 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904269 | DPM1052307000500 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L7_RF_1P_20230927_07.xml |
| NEQA4904272 | DPM1062312006732 | DTZ1513 | Direct Purchased | ADF_DT_DPM_L5-7_RF_3P_20240216_07.xml |
| NEQA4904273 | DPM1052312045594 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |
| NEQA4904274 | DPM1052312045555 | DDZ1513 | Direct Purchased | ADF_DT_DPM_L71_RF_1P_20240322_71.xml |