主权项 |
1. A method for identifying data synchronization problems, comprising:
retrieving, by a computer processor, planning data comprising information regarding a planned deployment of a plurality of devices from a first database (DB1), the planning data comprising: devices assigned (Dev Assign (DB1)); and consumption of devices in inventory ((Dev Cons (DB1)); retrieving, by the computer processor, deployment data comprising information regarding an actual deployment of the plurality of devices from a second database (DB2), the deployment data comprising: devices assigned (Dev Assign (DB2)); devices requested (Req Inv (DB2)); devices scheduled for deployment (Dev Sched (DB2)); and devices deployed ((Dev Dep (DB2)); generating, by the computer processor, a summary of common data, the common data comprising data that is stored in both the first and second databases, by comparing the retrieved planning data from the first database and the retrieved deployment data from the second database; determining, by the computer processor, at least one delta value for the common data between the first and second databases, the at least one delta value comprising an assignment delta value (Dev Assig Delta) determined according to: Dev Assign Delta=Dev Assign (DB1)−(Dev Assign (DB2)+Dev Req (DB2)+Dev Sched (DB2)+Dev Dep (DB2)); generating, by the computer processor, an analysis view displaying, in a single display view, the summary of the common data in the first and second databases, and the at least one delta value for the common data between the first and second databases; and identifying, by the computer processor, based on the at least one delta value, a source of a data synchronization problem between the planning data in the first database and the deployment data in the second database. |