Method for visualizing data backup activity from a plurality of backup devices
View Patent ↗A method and system for examining historical records of backup activity consolidated from a plurality of backup engines is disclosed. The method includes reorganizing historical records of backup activity originating from a plurality of backup engines into unique visual representations to facilitate the identification of backup activity failures. The method allows representation of many levels of data extraction relating to backup successes, partial successes, and failures. In another aspect, a method of combining summary level data (summarized by backup server) with subsequently lower levels of detail in a single report that provides the ability to expand and contract at will is provided. In another aspect, a system for associating owners of computers being backed up with respective backup charges, rearranging data extracted from the RDB consisting of historical records originating from different backup engines, and constructing Billing Reports to reflect charges relating to said backup activities.
1. A method for visually representing backup activity successes and failures for a plurality of data backup products, the method comprising:
obtaining records from one or more data backup products, the records containing data backup activity information;
inserting the information in the records into a canonical database; and
generating a visual display illustrates the backup failures and successes for one or more servers and clients and targets associated with the one or more data backup products,
wherein the visual display comprises:
a first object indicating a backup failure for a backup product;
a second object indicating a backup success for a backup product and
a third object indicating a backup partial failure for a backup product,
wherein the visual display displays the backup status of the clients and servers and targets of the data backup products; and
wherein the visual display comprises:
a first color-coded object indicating a backup failure for a client or server of a backup product,
a second color-coded object indicating a backup success for a client or a server of a backup product,
a third color-coded object indicating a backup partial failure for a client or a server of a backup product, and
a first mixed color object that indicates the partial failure of a client or server of the data backup product; and wherein the visual display indicates by the color-coded objects.
2. The method of claim 1 , wherein generating the visual display comprises selecting one or more clients and servers in order to reduce the scope of the visual display.
3. The method of claim 2 , wherein the selecting comprises generating an SQL statement in order to limit the scope of the data displayed on the visual display.
4. The method of claim 1 , wherein generating the visual display comprises generating a table having one or more columns and one or more rows including an element at the intersection of each column with each row, wherein each row represents one of a server and a client of a server, wherein each column represents a day of backup activity for all of the servers and clients and wherein each element represents the backup status for a particular client or server on a particular day.
5. The method of claim 4 , wherein generating the visual display further comprises determining the number of days being displayed on the visual display and generating the table having a number of columns corresponding to the number of days being displayed on the visual display.
6. The method of claim 4 , wherein the table comprises a server row and one or more client rows underneath the server row wherein the one or more clients are associated with the server and one or more target rows associated with a client or server corresponding to pieces of data that have been backed up.
7. The method of claim 4 , wherein generating the visual display further comprises determining the color of the object being placed into an element of the table corresponding to the status of a target on a particular day, wherein the color determining comprises changing the indicator for one of the client and server based on the indicator for a particular target associated with the element of the table.
8. A data structure embodied in computer readable media for visually representing backup activity successes and failures for a plurality of data backup products, the data structure comprising:
a table having one or more columns and one or more rows including an element at the intersection of each column with each row, wherein each row represents one of a server, a client of a server and a target associated with a client, wherein each column represents a day of backup activity for all of the servers and clients and targets and wherein each element represents the backup status for a particular client or server or target on a particular day; and
each element in the table comprises one of a first object indicating a backup failure for a backup product, a second object indicating a backup success for a backup product, a third object indicating a backup partial failure for a backup product, a first color-coded object indicating a backup failure for one of a client, a server and a target of a backup product, a second color-coded object indicating a backup success for one of a client, a server and a target of a backup product, a third color-coded object indicating a backup partial failure for one of a client, a server and a target of a backup product, and a first mixed color object that indicates the partial failure for one of a client, a server and a target of the data backup product, and wherein the visual display displays the backup status of the clients and servers of the data backup products are indicated by the color-coded objects.