Self-correcting database based on device-reported integrity data

A system comprising:

• at least one processing unit;
• and
• memory storing instructions that, when executed by the at least one processing unit, cause the system to perform operations comprising:
• retrieving a first data record associated with a user account from a first database, wherein the first data record includes a first device list including a first set of registered on-premises devices registered to the user account in a first platform;
• retrieving a second data record associated with the user account from a second database, wherein the second data record includes a second device list including a second set of registered on-premises devices registered to the user account in a second platform;
• verifying a distribution transport network (DTN) assigned to the user account in the first data record;
• logging into a first connected on-premises device connected to the verified DTN;
• retrieving first device-reported data from the first connected on-premises device;
• updating the first data record based on the first device-reported data;
• and
• updating the second data record based on the first data record.

A method, comprising:

• retrieving a first data record associated with a user account from a first database, wherein the first data record includes a first device list including a first set of registered on-premises devices registered to the user account in a first platform;
• retrieving a second data record associated with the user account from a second database, wherein the second data record includes a second device list including a second set of registered on-premises devices registered to the user account in a second platform;
• obtaining a device identifier of a first registered on-premises device in the first set of registered on-premises devices from the first data record;
• retrieving a MAC address of the first registered on-premises device from a third database based on the device identifier of the first registered on-premises device;
• retrieving, from a fourth database, a recorded distribution transport network (DTN) identifier recorded in association with a network connection made by the first registered on-premises device via a connected DTN;
• and
• verifying a DTN assigned to the user account is the connected DTN connected to the first registered on-premises device when the recorded DTN identifier matches a DTN identifier of the DTN assigned to the user account in the first data record;
• or
• updating the DTN identifier assigned to the user account in the first data record when the recorded DTN identifier and the DTN identifier in the first data record do not match;
• logging into a first connected on-premises device connected to the verified DTN;
• retrieving first device-reported data from the first connected on-premises device;
• updating the first data record based on the first device-reported data, comprising:
• comparing a device identifier of the first connected on-premises device in the first device-reported data to a device identifier of the first registered on-premises device in the first set of registered on-premises devices;
• and
• verifying the first connected on-premises device is the first registered on-premises device when the device identifier of the first connected on-premises device matches the device identifier of the first registered on-premises device in the first set of registered on-premises devices;
• or
• updating the device identifier of the first registered on-premises device in the first data record when the device identifier of the first connected on-premises device and the device identifier of the first registered on-premises device in the first set of registered on-premises devices do not match;
• comparing a device identifier of the first registered on-premises device in the first set of registered on-premises devices to a device identifier of a second connected on-premises device connected to the first on-premises device in a wireless backhaul included in the first device-reported data;
• and
• verifying the second connected on-premises device is a second registered on-premises device in the first set of registered on-premises devices when the device identifier of the second connected on-premises device matches the device identifier of the second registered on-premises device;
• or
• updating the device identifier of the second registered on-premises device in the first data record when the device identifier of the second connected on-premises device and the device identifier of the second registered on-premises device in the first set of registered on-premises devices do not match;
• and
• updating the second data record based on the first data record.