I 've been going through the racktables to servermon migration process again and while I 've managed to substantially diminish through a number of tricks like
* For equipment in the "decomissioned" rack, autogenerating Serial Number in case they are not known.
* For equipment in the "decomissioned" rack, assigning dummy vendor+equipment model in case they are not known
* Using SNMP to fetch Power Strip vendor, model and strip and using php to update racktables
the number of non-migratable equipment due to some info missing, there are still quite a few. The 3 data items missing are Vendor (e.g. "Dell"), EquipmentModel (e.g. Poweredge R730xd) and Serial Number (e.g. "SDF312").
The list is attached in this task. We should aim to take it down to 0 so we can finally migrate away from racktables.
Missing model:
analytics1056, analytics1057, backup-array1, cp3004, cp3005, cp3006, cp3007, cp3008, cp3009, cp3010, cp3011, cp3012, cp3013, cp3014, cp3015, cp3016, cp3017, cp3018, cp3019, cp3020, cp3021, cp3022, db1022, db1023, db1027, db1049, db1050, es1011, es1012, es1013, es1014, es1015, es1016, es1017, es1018, es1019, eventlog1001, kubernetes1002, kubernetes1003, kubernetes1004, lvs1001, lvs1002, lvs1003, lvs1004, lvs1005, lvs1006, mobile1004, mobile1005, ms-fe3002, ms6, msw-c1-pmtpa, msw-d1-eqiad, msw-d1-pmtpa, msw-d2-eqiad, msw-d2-pmtpa, msw-d3-eqiad, msw-d3-pmtpa, msw-d4-eqiad, msw-d5-eqiad, msw-d6-eqiad, msw-d7-eqiad, msw-d8-eqiad, msw-oe11-esams, mw1002, mw1016, mw1018, mw1021, mw1097, mw1099, ps1-a3-sdtpa, ps1-a4-sdtpa, ps1-oe10-esams, ps1-oe11-esams, ps1-oe12-esams, ps1-oe13-esams, scs-a8-eqiad, scs-c1-codfw, scs-c1-eqiad, scs-d1-pmtpa, tridge-array, wmf6407
backup-array1, cp3011, db1027, mobile1004, mobile1005, ms6, msw-c1-pmtpa, msw-d1-eqiad, msw-d1-pmtpa, msw-d2-eqiad, msw-d2-pmtpa, msw-d3-eqiad, msw-d3-pmtpa, msw-d4-eqiad, msw-d5-eqiad, msw-d6-eqiad, msw-d7-eqiad, msw-d8-eqiad, msw-oe11-esams, mw1002, mw1016, mw1018, mw1021, mw1097, ps1-a3-sdtpa, ps1-a4-sdtpa, ps1-oe10-esams, ps1-oe11-esams, ps1-oe12-esams, ps1-oe13-esams, scs-a8-eqiad, scs-c1-codfw, scs-c1-eqiad, scs-d1-pmtpa, tridge-array, wmf6407
Missing serial:
atlas-codfw, atlas-eqiad, atlas-ulsfo, br1-knams, cp3001, cp3002, dataset1001-array1, db1022, db1023, db1027, db2058, db2059, db2060, frdb1001, indium, labnodepool1001, mc1010, mc1011, mc1012, mc1013, mc1014, mc1015, mc1016, msw-b1-codfw, msw-b2-codfw, msw-b3-codfw, msw-b4-codfw, msw-b5-codfw, msw-b6-codfw, msw-b7-codfw, msw-b8-codfw, msw-c1-codfw, msw-c1-eqiad, msw-c2-codfw, msw-c3-codfw, msw-c4-codfw, msw-c5-codfw, msw-c6-codfw, msw-c7-codfw, msw-c8-codfw, msw-d1-codfw, msw-d2-codfw, msw-d3-codfw, msw-d4-codfw, msw-d5-codfw, msw-d6-codfw, msw-d7-codfw, msw-d8-codfw, msw1-ulsfo, msw2-ulsfo, mw1010, mw1011, mw1016, mw1018, mw1019, mw1021, mw1097, mw1099, mw1108, mw1111, mw1112, mw1120, mw1122, mw1123, mw1124, nas-array2, nas-array3, nas1, nas1-array1, nas1001, nas1001a, nas1001b, nas1001c, osm-web1001, osm-web1002, osm-web1003, osm-web1004, pc2005, ps1-a1-eqiad, ps1-a2-eqiad, ps1-a3-eqiad, ps1-a3-sdtpa, ps1-a4-eqiad, ps1-a4-sdtpa, ps1-a5-eqiad, ps1-a6-eqiad, ps1-a7-eqiad, ps1-a8-eqiad, ps1-b1-eqiad, ps1-b2-eqiad, ps1-b3-eqiad, ps1-b4-eqiad, ps1-b5-eqiad, ps1-b6-eqiad, ps1-b7-eqiad, ps1-b8-eqiad, ps2-a1-eqiad, ps2-a8-eqiad, rdb2001, rdb2002, rdb2003, rdb2004db1027, frdb1001, indium, msw-b1-codfw, msw-b2-codfw, msw-b3-codfw, msw-b4-codfw, msw-b5-codfw, msw-b6-codfw, msw-b7-codfw, msw-b8-codfw, msw-c1-codfw, msw-c1-eqiad, msw-c2-codfw, msw-c3-codfw, msw-c4-codfw, msw-c5-codfw, msw-c6-codfw, msw-c7-codfw, msw-c8-codfw, msw-d1-codfw, msw-d2-codfw, msw-d3-codfw, msw-d4-codfw, msw-d5-codfw, msw-d6-codfw, msw-d7-codfw, msw-d8-codfw, msw1-ulsfo, msw2-ulsfo, mw1010, mw1011, mw1016, mw1018, mw1019, mw1021, mw1097, mw1108, mw1111, mw1112, mw1120, mw1122, mw1123, mw1124, nas-array2, nas-array3, nas1, nas1-array1, nas1001, nas1001a, nas1001b, nas1001c, osm-web1001, osm-web1002, osm-web1003, osm-web1004, ps1-a3-sdtpa, ps1-a4-sdtpa, scs-c1-eqiad