System for linking financial asset records with networked assets
A computer system to reconcile hard assets carried on the financial data reporting computer systems of a corporation or government entity with actual inventory assets discovered on the networks of said entity. Automatic discovery of inventory assets is performed by executing scripts specified in fingerprints of the types of machines the system can recognize. When a machine is found at a live P address, the fingerprint scripts determine the operating system type and extract data from the operating system regarding the attributes of the machine. Hard assets are then imported from the financial data reporting computer system, and automatic reconciliation rules are drafted by a user and run on the asset data to find inventory assets which match hard assets. Linking or pointer data is established to record each match. Then unmatched inventory and hard assets are displayed and manual matching occurs where in the user points to and selects inventory assets which match particular hard assets. Linking or pointer data is then generated for each manual match.
1. A method comprising:
under control of one or more computer processors configured with executable instructions,
defining automatic asset reconciliation rules via user interface tools configured for access via a user interface, wherein the automatic asset reconciliation rules match asset records from different sources, and wherein the user interface is configured to:
respond to specification of conditions associated with matching asset records, the conditions being used in the automatic asset reconciliation rules;
matching asset records using the automatic asset reconciliation rules, wherein the matched asset records represent assets across different computer systems, wherein the user interface displays summary information describing matched asset records,
and wherein matching asset records comprises:
instructing a collection process to traverse the different computer systems, and
extracting attribute data associated with the automatic asset reconciliation rules, the extracted attribute data obtained by invoking function calls or reading predetermined files associated with the traversed computer systems based on the automatic asset reconciliation rule used; and
creating linking data for every match made using the automatic asset reconciliation rules, wherein the linking data links the matched asset records of the different computer systems.
2. The method of claim 1 further comprising specifying one or more filter conditions, via user interface tools, that are used to search for unmatched asset records from a first source and that also meet the user specified filter conditions.
3. The method of claim 1 , wherein the matched assets of the different computer systems include information about a number of computing hardware assets.
4. The method of claim 3 , wherein the matched assets of the different computer systems also includes information about types of computing hardware systems.
5. The method of claim 3 , wherein the matched assets of different computer systems also includes information about an organization associated with the computer systems.
6. The method of claim 5 , wherein the information about the organization includes leases associated with the organization.
7. The method of claim 6 , wherein the information about the organization also includes contracts associated with the organization.
8. The method of claim 6 , wherein the information about the organization also includes licenses associated with the organization.
9. The method of claim 6 , wherein the information about the organization also includes maintenance agreements associated with the organization.
10. The method of claim 6 , wherein the information about the organization also includes financial statements associated with the organization.
11. The method of claim 1 , wherein matching the asset records includes scheduling when attribute data should be extracted from the different computer systems, the scheduling based on a collection calendar that defines when attribute data is collected and a refresh table that determines intervals at which attribute data is collected.
12. An asset reconciliation computer system comprising:
a data storage medium; and
a central processing unit, wherein the central processing unit is configured to execute instructions stored in the data storage medium to:
define automatic asset reconciliation rules via user interface tools configured for access via a user interface, wherein the automatic asset reconciliation rules match asset records from different sources, and wherein the user interface is configured to:
respond to specification of conditions associated with matching asset records, the conditions being used in the automatic asset reconciliation rules;
match asset records using the automatic asset reconciliation rules, wherein the matched asset records represent assets across different computer systems, wherein the user interface displays summary information describing matched asset records,
and wherein to match asset records, the central processing unit is further configured to:
instruct a collection process to traverse the different computer systems, and
extract attribute data associated with the automatic asset reconciliation rules, the extracted attribute data obtained by invoking function calls or reading predetermined files associated with the traversed computer systems based on the asset reconciliation rule used; and
create linking data for every match made using the automatic asset reconciliation rules, wherein the linking data links the matched asset records of the different computer systems.
13. The computer system of claim 12 , wherein the central processing unit further executes instructions to:
allow a user to manually select from a collection of displayed asset records from a second source via the user interface tools, wherein the asset records from the second source match an asset record from the first source; and
generate linking data links that match asset records between the first and second source.
14. The computer system of claim 12 , wherein the central processing unit further schedules when attribute data should be extracted from the different computer systems, the scheduling based on a collection calendar that defines when attribute data is collected and a refresh table that determines intervals at which attribute data is collected.
15. A non-transitory computer-readable storage medium having stored thereon computer readable instructions which, when executed by a computer performs a method comprising:
defining automatic asset reconciliation rules via user interface tools configured for access via a user interface, wherein the automatic asset reconciliation rules match asset records from different sources, and wherein the user interface is configured to:
respond to specification of conditions associated with matching asset records, the conditions being used in the automatic asset reconciliation rules;
matching asset records using the automatic asset reconciliation rules, wherein the matched asset records represent assets across different computer systems, wherein the user interface displays summary information describing matched asset records,
and wherein matching asset records comprises:
instructing a collection process to traverse the different computer systems, and
extracting attribute data associated with the automatic asset reconciliation rules, the extracted attribute data obtained by invoking function calls or reading predetermined files associated with the traversed computer systems based on the asset reconciliation rule used;
creating linking data for every match made using the automatic asset reconciliation rules, wherein the linking data links the matched asset records of the different computer systems;
allowing a user to manually select from a collection of displayed asset records from a second source via the user interface tools, wherein the asset records from the second source match an asset record from the first source; and
generating linking data links that match asset records between the first and second source.
16. The non-transitory computer-readable storage medium of claim 15 , wherein the computer performs the method further comprising scheduling when attribute data should be extracted from the different computer systems, the scheduling based on a collection calendar that defines when attribute data is collected and a refresh table that determines intervals at which attribute data is collected.