System and method for managing information for a plurality of computer systems in a distributed network

• US 6,978,265 B2
• Filed: 01/15/2002
• Issued: 12/20/2005
• Est. Priority Date: 01/16/2001
• Status: Active Grant

• Current Assignee: Lakeside Software LLC
• Original Assignee: Lakeside Software, Inc.
• Inventors: Schumacher, Michael K.
• Primary Examiner(s): Rones, Charles
• Assistant Examiner(s): Ortiz, Belix M.
• Application Number:
  US10/047,866
• Publication Number:
  US 20020099690A1
• Time in Patent Office: 1,435 Days
• Field of Search: 707 1-206, 707501-513, 379/112.01, 379/114.01, 379/114
• US Class Current: 1/1
• CPC Class Codes: G06F 16/22 Indexing; Data structures therefor; Storage structures
• CPC Class Codes: G06F 16/2471 Distributed queries
• CPC Class Codes: Y10S 707/99934 Query formulation, input preparation, or translation

Abstract

A system for managing computers in a distributed computer network includes a collection agent for each computer being monitored, a local database coupled to each collection agent, one or more condensing agents coupled to the databases, and at least one console module. The condensing agent generates an index table from a source database and sends it upstream to the next level up in the hierarchy of databases. Other condensing agents may in turn act on this index table and send it up to a still further level, until a top-level master node has an index table reflecting the entire network. The console can use the index table to identify what databases contain needed data, and then make only selective connections to databases to answer queries, avoiding connections to all the local databases. The condensing agent also produces summarized data and sends it upstream as well, to be used by the console. Efficiency is improved over conventional systems. Use of the index method and the summary method can be transparent to (hid from) the user of the console, or may be made visible, with selection options.

Claims

1. A method of managing information for a plurality of computers in a distributed network comprising the steps of:

(A) collecting original data related to each computer and storing the original data in a respective database;

(B) generating an index table including index data for each computer wherein the index data is configured (i) to identify at least a portion of the contents of the original data stored in the database, and (ii) to facilitate access to the databases over the distributed network;

wherein said step of generating an index table includes the substeps of;

producing records in the table characterized by a record type selected from the group comprising a database name, a system name, a disk name, a network interface name and a user name; and

producing connection information for each database to facilitate access thereto over the distributed network; and

(C) scanning at least one of the index tables to select databases that match a user query;

(D) accessing the selected databases to retrieve original data and generate an output therefrom.

2. The method of claim 1 wherein said accessing step includes the substep of:

using respective connection information to connect to and access the corresponding database.

3. A method of managing information for a plurality of computers in a distributed network comprising the steps of:

(A) collecting original data related to each computer and storing the original data in a respective database;

(B) generating an index table including index data for each computer wherein the index data is configured (i) to identify at least a portion of the contents of the original data stored in the database, and (ii) to facilitate access to the databases over the distributed network;

(C) selecting databases by scanning index tables and determining which ones, using the index data configured to identify the contents of the original data stored in the databases, contain original data that match a user query;

(D) accessing the selected databases to retrieve original data and generate an output therefrom;

the method further comprising the step of;

producing a summarized data table for the computers, wherein said plurality of computers are organized in a tree-style hierarchy, the step of producing the summarized data table includes the substep of;

condensing original data from databases that are lower in the hierarchy to produce the summarized data and passing the summarized data upstream to databases for storage therein.

4. The method of claim 3 wherein said steps of scanning and accessing define a first mode of operation, said method further comprising the step of accessing a summarized data table at a base level in the hierarchy having the summarized data thereby avoiding access to one or more databases lower in the hierarchy.

5. The method of claim 4 wherein the summarized data table comprises at least one of application resource information or application usage information.

6. An apparatus for managing information for computers in a distributed network comprising:

a collection agent associated with each of a plurality of computers configured to acquire and store original data in a respective storage databases;

at least one condensing agent for condensing said original data into index data, said index data configured (i) to identify at least a portion of the contents of said original data, and (ii) to facilitate access to said storage databases over the distributed network;

a base database including said index data;

a console module configured to select storage databases for access thereto responsive to a user query for said contents, said console being further operative to use said index data to access said selected storage databases, retrieve original data, and generate an output;

said plurality of computers are arranged in a logical tree style hierarchy wherein said console module is configured to execute on a head end of said hierarchy, a remainder of said computers populating a subtree of said hierarchy at a plurality of levels;

wherein said base database includes an index table having a plurality of records containing said index data, each record being characterized by a record type selected from the group comprising a storage database name, a system name, a disk name, a network interface name and a user name.

7. The apparatus of claim 6 wherein each record of said index table further includes a first plurality of fields each corresponding to a level in said subtree, said first plurality of fields collectively describing one of said storage databases and a corresponding level in said subtree.

8. The apparatus of claim 6 wherein each record of said index table further includes at least one further field comprising connection information for facilitating access to said storage database identified in said first plurality of fields.

9. The apparatus of claim 8 wherein records in said index table having said record type corresponding to said storage database names identify said storage databases contained in said subtree.

10. The apparatus of claim 8 wherein said records in said index table having said record type corresponding to said system names identify systems whose original data associated therewith is included in at least one of said storage databases in said subtree.

11. The apparatus of claim 8 wherein said records in said index table having said record type corresponding to said disk names identify disks whose original data associated therewith is included in at least one of said storage databases in said subtree.

12. The apparatus of claim 8 wherein said records in said index table having said record type corresponding to said network interface names identify network interfaces whose original data associated therewith is included in at least one of said storage databases in said subtree.

13. The apparatus of claim 8 wherein said records in said index table having said record type corresponding to said user names identify users who have executed an application program and whose original data associated therewith is included in at least one of said storage databases in said subtree.

14. An apparatus for managing information for computers in a distributed network comprising:

a first database configured to store original data related to a first computer;

a condensing agent coupled to said first database and configured to generate summarized data based on said original data;

a base database having a first portion configured to store said summarized data and a second portion configured to store index data comprising at connection information of said first database; and

a console module coupled to said base database and configured for operation in (i) a first mode to generate a first output based on said summarized data and (ii) a second mode wherein said console module uses said connection information in said index data to facilitate access to said first database to generate a second output;

wherein said first portion of said base database comprises an application table having information relating to usage of application programs;

wherein a plurality of application programs are executed on said first computer by a user, said application table comprising a corresponding plurality of records, one for each application program and user combination, each record having summarized data comprising statistical information regarding such use of said application programs.

15. The apparatus of claim 14 wherein said statistical information includes one selected from the group comprising a counting indicating the number of times an executable has run, a start time when running of the executable began, a start time when running of the executable was terminated, a run duration of the executable, a CPU time indicative of an amount of time used to run said executable, and a measure of an amount of memory used by said executable.