JP7071186B2 - Management equipment, management methods and management programs - Google Patents

Description

The present invention relates to a management device, a management method and a management program.

Companies, etc. lend goods such as personal computers (PCs) to workers to carry out their work.

Therefore, various techniques for associating articles with personal and other information are known. For example, a personal identification device that reads an individual's fingerprint, converts it into a two-dimensional bar code format, attaches the two-dimensional bar code to a collation object, and collates the bar code with the fingerprint to identify the individual is known. (Patent Document 1). Further, there is known an information processing device that acquires unique information of a device connected to a network at a timing such as a bus reset and stores it in a memory, and investigates a correspondence relationship with additional information about the device stored in the memory. (Patent Document 2).

Japanese Unexamined Patent Publication No. 2004-199157 Japanese Unexamined Patent Publication No. 2001-148706

However, in a large business entity, it is not easy to track whether the rented goods are properly used by the user. For example, it is not easy to manage when the person's PC is not returned and is in use even though he / she is retired, or when the person is lent once but is rarely used.

Therefore, it is an object of the present invention to provide a management device, a management method, and a management program that can easily track the usage status of an asset.

In the first plan, the management device includes an acquisition unit, an extraction unit, a processing unit, and an update unit. The acquisition unit acquires a user ID and a user name associated with the user ID from the first database of a predetermined organization at the first timing. The extraction unit extracts the difference between the user ID and the user name stored in the second database of the predetermined organization in association with the assets managed by the organization and the user ID and the user name acquired by the acquisition unit. The processing unit processes the user ID and user name acquired by the acquisition unit based on the difference extracted by the extraction unit. The update unit updates the second database based on the processing result of the processing unit.

According to one embodiment of the present invention, the usage status of assets can be easily tracked.

FIG. 1 is a diagram showing an example of the configuration of the management system according to the first embodiment. FIG. 2 is a diagram showing an example of the configuration of information stored in the first database according to the first embodiment. FIG. 3 is a diagram showing an example of the configuration of information stored in the second database according to the first embodiment. FIG. 4 is a diagram showing an example of the configuration of information stored in the storage unit of the management device according to the first embodiment. FIG. 5 is a diagram for explaining an example of information obtained as a result of processing in the management device according to the first embodiment. FIG. 6 is a diagram showing an example of the configuration of information updated by the management device according to the first embodiment. FIG. 7 is a flowchart for explaining an example of the processing flow in the management device according to the first embodiment. FIG. 8 is a diagram showing an example of the configuration of the management system according to the second embodiment. FIG. 9 is a flowchart for explaining an example of the processing flow in the management device according to the second embodiment. FIG. 10 is a diagram for explaining an example of a computer that executes the management program according to the first to third embodiments.

Hereinafter, embodiments of the management device, management method, and management program disclosed in the present application will be described in detail with reference to the drawings. The present invention is not limited to this embodiment.

[First Embodiment]
FIG. 1 is a diagram showing an example of the configuration of the management system 1 according to the first embodiment. The management system 1 according to the first embodiment includes a management device 10, a first database 20, and a second database 30. Further, the management system 1 includes a management device 10, a network 40 that connects the first database 20 and the second database 30 so as to be communicable with each other.

The management device 10 maintains the independence of the first database 20 and the second database 30, and links the information stored in the first database 20 with the information stored in the second database 30. It is an information processing device to be realized. Although the management device 10 is shown as an independent device in FIG. 1, the management device 10 may be integrally configured with the second database 30. For example, the function of the management device 10 may be incorporated into the second database 30 as a part of the program installed in the second database 30.

The first database 20 is a database for storing the first information. The first information is, for example, information about the personnel affairs of a predetermined organization. The first database 20 is, for example, a personnel database managed by the personnel department of a company and storing information related to personnel. The first information is, for example, the name, affiliation, job title, and other personal information of a user (worker) belonging to a company.

FIG. 2 is a diagram showing an example of the configuration of information stored in the first database 20 according to the first embodiment. In the example of FIG. 2, in the first database 20, "user name", "department", "post", "address" and the like are stored in association with the "user ID". The "user ID" is an identifier (Identifier) for uniquely identifying each user. The "user ID" is, for example, a control number assigned to a worker in a company. The "user name" is the name of the user specified by the corresponding user ID. The "user name" is, for example, the name of a worker who belongs to a company. The "department" is information that identifies the department to which the user specified by the corresponding user ID belongs. The “department” is, for example, a system department (indicated by the abbreviation “SYS” in FIG. 2), a personnel department (indicated by the abbreviation “PER” in FIG. 2), and the like. The "post" is the title of the user specified by the corresponding user ID. The "position" is, for example, a "chief examiner", a "section chief", a "department manager", or the like. The "address" is the address of the user specified by the corresponding user ID. In addition, the first database 20 stores arbitrary information necessary for personnel management. Further, "NA" in FIG. 2 indicates that the corresponding information is not stored in the first database 20.

For example, in the example of FIG. 2, "user name, Tsuyoshi Katahira", "department, SYS", and "post, chief examiner" are stored in association with "user ID, S016762". This indicates that the name of the user (worker) specified by the user ID "S016762" is "Takeshi Katahira". In addition, "Takeshi Katahira" belongs to the system department (SYS) and indicates that the position is "chief examiner".

The second database 30 is a database for storing the second information. The second information is, for example, information about an asset owned or used by a given organization. The second database 20 is, for example, an asset management database managed by the asset management department of a company. The second information is, for example, information on properties such as personal computers (PCs), printers, and telephones that are lent to users (workers) in a predetermined organization or are assigned to each department.

FIG. 3 is a diagram showing an example of the configuration of information stored in the second database 30 according to the first embodiment. In the example of FIG. 3, the second database 30 stores a “host name”, a “status”, a “user”, and a “department” in association with the “property ID”. The "property ID" is an identifier for uniquely identifying each asset, that is, a property owned or used by the organization. The "host name" is an identifier for uniquely identifying the property on the network when the property is connected to the network. The "property ID" and the "host name" may be the same. "Status" is the usage status of the property. For example, if the "status" is "in use", it indicates that the property is assigned to at least one of the department or the user. On the other hand, if the "status" is "inventory", it means that the property is not assigned to any department or user at that time and is managed as inventory. "User" indicates the user name to which the property is assigned. In the example of FIG. 3, the "user" includes the "user ID" and the "user name" of FIG. “Department” indicates the department to which the user to which the property is assigned belongs.

For example, in the example of FIG. 3, "host name, HT-0001", "status, in use", "user, Tsuyoshi Katahira (S016762)", "department" are associated with "property ID, PC-0001". , SYS "is stored. This indicates that the property specified by the property ID "PC-0001" is recognized as the host name "HT-0001" on the network. Further, the property specified by the property ID "PC-0001" indicates that it is assigned to any department or user at this time. Further, it is shown that the property specified by the property ID "PC-0001" is assigned to the user "Takeshi Katahira" specified by the user ID "S016762". Further, "Takeshi Katahira" indicates that he / she belongs to the department "System Department (SYS)". In FIGS. 2, 3, 4, and 6, for convenience of explanation, the data portions referred to in the following description are shaded.

Returning to FIG. 1, the network 40 connects the management device 10, the first database 20 and the second database 30 so as to be communicable with each other. The network 40 may be, for example, the Internet, an intranet, a local area network, a wide area network, or a combination thereof. Further, the network 40 may be a wired network, a wireless network, or a combination thereof.

[An example of the configuration of the management device 10 according to the first embodiment]
An example of the configuration and function of the management device 10 will be further described with reference to FIG. The management device 10 includes a storage unit 100, a control unit 110, a communication unit 120, an input unit 130, and an output unit 140.

The storage unit 100 stores information used for processing in the management device 10 and information generated as a result of processing. The storage unit 100 is, for example, a semiconductor memory element or a storage device. Examples of the semiconductor memory element include a VRAM (Video Random Access Memory), a RAM (Random Access Memory), a ROM (Read Only Memory), and a flash memory (flash memory). Further, examples of the storage device include storage devices such as hard disks and optical disks. The information stored in the storage unit 100 will be described later.

The control unit 110 controls the operation and function of the management device 10. For example, various integrated circuits and electronic circuits can be adopted as the control unit 110. Further, a part of the functional unit included in the control unit 110 can be used as another integrated circuit or electronic circuit. For example, an integrated circuit includes an ASIC (Application Specific Integrated Circuit). Further, examples of the electronic circuit include a CPU (Central Processing Unit) and an MPU (Micro Processing Unit). The function and configuration of the control unit 110 will be described later.

The communication unit 120 is a functional unit that realizes communication with other devices and the like via the network 40. The communication unit 120 includes, for example, a router, a switch, a modem, a port, and the like.

The input unit 130 is a functional unit that realizes the input of information from the outside to the management device 10. The input unit 130 includes, for example, a keyboard, a mouse, a touch panel, a microphone, and peripheral circuits thereof.

The output unit 140 is a functional unit that realizes the output of information from the management device 10 to the outside. The output unit 140 includes, for example, a screen, a speaker, a printer, peripheral circuits thereof, and the like.

[Example of information stored in the storage unit 100]
The storage unit 100 has a first table storage unit 101, a second table storage unit 102, and a third table storage unit 103. FIG. 4 is a diagram showing an example of the configuration of information stored in the storage unit 100 of the management device 10 according to the first embodiment.

The first table storage unit 101 stores a first table including a user ID and a user name acquired from the first database 20 at the first timing. The first table contains information about items stored in both the first database 20 and the second database 30. The first table may include information other than the user ID and the user name. The information stored in the first table storage unit 101 is overwritten each time the first timing arrives. The first timing is not particularly limited. The first timing is, for example, a time zone during which no other operation on the first database 20 is being executed. The first timing is, for example, a predetermined time of the day. For example, the first timing is 24:00 every day.

FIG. 4A is an example of the configuration of the first table stored in the first table storage unit 101. In the example of (A) of FIG. 4, the first table includes a "user ID", a "user name", and a "department". Each item in the first table is the same as each item of information stored in the first database 20.

The second table storage unit 102 stores a second table including a user ID and a user name stored in the second database 30 when the first timing arrives. The second table, like the first table, contains information about items stored in both the first database 20 and the second database 30. However, the second table may include information other than the user ID and the user name.

FIG. 4B is an example of the second table stored in the second table storage unit 102. In the example of (B) of FIG. 4, the second table includes "user" and "department". Each item and information in the second table is obtained from the second database 30.

The third table storage unit 103 stores a third table showing the difference between the first table and the second table. FIG. 4C is an example of the third table stored in the third table storage unit 103. In the example of (C) of FIG. 4, the third table includes a "user ID", a "user name", and a "department". The "user ID", "user name", and "department" are the same as the information stored in the first database 20. However, in the example of FIG. 4C, the changed contents of the items changed between the first table and the second table are stored. For example, in FIG. 4C, in association with "user ID, S016674", "user name, (1: NA) (second: Hanako Efu)", "department, (1: NA)". (2nd: DEV) ”is stored. This indicates that the user name stored in association with the user ID "S016674" does not exist in the first table, but is "Hanako Efu" in the second table. Further, the department stored in association with the user ID "S016674" does not exist in the first table, but indicates that it is "DEV (development department)" in the second table.

In the first embodiment, the first table, the second table, and the third table are updated every time the first timing arrives.

[Example of function and configuration of control unit 110]
The control unit 110 includes an acquisition unit 111, an extraction unit 112, a processing unit 113, an update unit 114, and an output control unit 115.

The acquisition unit 111 acquires a user ID and a user name associated with the user ID from the first database 20 at the first timing. The user ID and the user name acquired by the acquisition unit 111 are stored in the first table storage unit 101 of the storage unit 100. In addition, the acquisition unit 111 may acquire information on predetermined items from the first database 20.

The extraction unit 112 extracts the difference between the user ID and the user name stored in the second database 30 in association with the asset and the user ID and the user name acquired by the acquisition unit 111. For example, when the acquisition unit 111 stores the first table in the first table storage unit 101, the extraction unit 112 extracts the user ID and the user name stored in association with the assets from the second database 30, and the second one. 2 Stored in the table storage unit 102. Then, the extraction unit 112 compares the first table and the second table, and stores the extracted difference in the third table storage unit 103.

The processing unit 113 refers to the third table storage unit 103, and processes the user ID and the user name acquired by the acquisition unit 111 based on the difference extracted by the extraction unit 112. For example, the processing unit 113 adds information indicating the type of difference (hereinafter, also referred to as difference information) to the user ID and user name acquired by the acquisition unit 111. For example, when the information existing in the second table does not exist in the first table, the processing unit 113 adds the information indicating "deletion". Further, for example, when the information existing in the second table is changed in the first table, the processing unit 113 adds the information indicating "change". Further, the processing unit 113 adds the deleted or changed information.

FIG. 5 is a diagram for explaining an example of information obtained as a result of processing in the management device 10 according to the first embodiment. For example, in the example of FIG. 4, the user name "Hanako Efu" associated with the user ID "S016674" existing in the second table is "NA" in the first table. Then, in the third table, the user name "(1: NA) (second: Hanako Efu)" is stored in association with the "user ID, S016674". In this case, the processing unit 113 determines that the user name "Hanako Efu" has been deleted, and adds information indicating "deletion" to the "user name". Further, the processing unit 113 adds the deleted user name to the information indicating "deletion". Further, the processing unit 113 adds the date and time corresponding to the date and time when the first table is stored, for example, the date and time corresponding to the extraction of the difference to the "user name". For example, as a result of processing, the processing unit 113 generates "Deleted: 20171203 Hanako Efu" as a "user name" as shown in FIG. This means that in the information of the first database 20 acquired at the first timing, the "user name, Hanako Efu" is eliminated as compared with the information stored in the second database 30. show. Further, it is shown that the date and time corresponding to the extraction of the difference of deleting the user name is December 3, 2017. The processing unit 113 can process information on other items in the same manner.

The update unit 114 updates the second database 30 based on the processing result of the processing unit 113.

For example, the updating unit 114 generates the information shown in FIG. 6 by updating the information shown in FIG. 3 with the information shown in FIG. FIG. 6 is a diagram showing an example of the configuration of information updated by the management device 10 according to the first embodiment. Comparing FIG. 6 and FIG. 3, the information stored in the "user" column is changed from "Hanako Efu (S016674)" in FIG. 3 to "(Deleted: Hanako Efu) (S016674) in FIG. It has been updated to.

Assuming that the information stored in the second database 30 is simply updated with the information stored in the first database 20, "(NA) (S016674)" is stored in the "user" column. Will be done. In addition, "NA" is stored in the "department" column. In this case, even if the information stored in the second database 30 after the update is referred to, the administrator can determine to whom in which department the property specified by the property ID "PC-0004" is assigned. I can't know. On the other hand, when the second database 30 is updated using the information processed by the processing unit 113, the administrator receives the information "Hanako Efu" stored corresponding to the "user" in 2017. You can see that it was deleted on December 3, 2014. In addition, the administrator can know that the information "DEV" stored corresponding to the "department" has been deleted on December 3, 2017.

The output control unit 115 outputs the information in which the difference occurs among the information stored in the second database 30 updated by the update unit 114 to the outside. For example, the output control unit 115 outputs to the outside the portion of the information stored in the second database 30 that corresponds to the information processed by the processing unit 113. For example, the output control unit 115 causes the output unit 140 to output the information of the line corresponding to the “property ID, PC-0004” in FIG. When there is a plurality of information in which the difference has occurred, the output control unit 115 lists the information in which the difference has occurred and outputs the information to the output unit 140.

[An example of the processing flow of the management device according to the first embodiment]
FIG. 7 is a flowchart for explaining an example of the processing flow in the management device 10 according to the first embodiment. First, the acquisition unit 111 of the management device 10 determines whether or not the first timing has arrived (step S71). If it is determined that the first timing has not arrived (step S71, No), the acquisition unit 111 repeats step S71. On the other hand, when it is determined that the first timing has arrived (step S71, Yes), the acquisition unit 111 acquires the user ID and the user name associated with the user ID from the first database 20 (step S72). ). The acquisition unit 111 stores the acquired user ID and user name in the first table storage unit 101. Next, the extraction unit 112 extracts the user ID and the user name stored in the second database 30 in association with the asset and stores them in the second table storage unit 102. The extraction unit 112 collates the first table with the second table and extracts the difference (step S73). The extraction unit 112 stores the extracted difference in the third table storage unit 103. Next, the processing unit 113 refers to the third table and determines the presence or absence of the difference (step S74). If it is determined that there is no difference (step S74, No), for example, if it is determined that the information is not stored in the third table, the machining unit 113 proceeds to step S76. On the other hand, when it is determined that there is a difference (step S74, Yes), the processing unit 113 processes the information acquired in step S72 (step S75). For example, the processing unit 113 adds a date and time corresponding to the difference to the user ID and the user name acquired in step S72 based on the difference. The date and time corresponding to the difference is the date and time corresponding to the extraction of the difference. For example, the date on which the difference was extracted, or the closing date for asset management including the date on which the difference was extracted. Further, the processing unit 113 adds the difference information to the user ID and the user name acquired in step S72 based on the difference. Then, the updating unit 114 updates the second database 30 based on the information processed by the processing unit 113 (see FIG. 5) (step S76). Then, the output control unit 115 outputs a list of assets to which the difference information is associated in the updated second database 30 (step S77). This completes the processing in the management device 10.

[Effect of the first embodiment]
As described above, the management device according to the first embodiment includes an acquisition unit, an extraction unit, a processing unit, and an update unit. The acquisition unit acquires a user ID and a user name associated with the user ID from the first database of a predetermined organization at the first timing. The extraction unit extracts the difference between the user ID and the user name stored in the second database of the predetermined organization in association with the assets managed by the organization and the user ID and the user name acquired by the acquisition unit. The processing unit processes the user ID and user name acquired by the acquisition unit based on the difference extracted by the extraction unit. The update unit updates the second database based on the processing result of the processing unit. Therefore, the management device according to the first embodiment can easily track the usage status of the assets. For example, if the first database is a personnel database managed by the personnel department, the user name of the user is deleted from the first database when the user leaves the database. In this case, the first database does not have a user name corresponding to the predetermined user ID, and the second database stores the user name corresponding to the predetermined user ID. In such a case, if the corresponding part of the second database is overwritten with the information of the first database, it is not possible to specify on the second database which user the asset is assigned to. For this reason, the asset management department cannot identify where the asset is located. However, as in the first embodiment described above, if the information in the first database is processed in a predetermined manner and then reflected in the second database, the information required on the second database is required. Can be retained. Further, in order to realize the processing adapted to the second database, the information on the first database is not affected, and the independence of each of the first database and the second database can be maintained. .. As described above, the management device according to the first embodiment can realize visualization of changes in information without impairing the independence of the information stored in each of the first database and the second database. .. Further, the management device according to the first embodiment specifies the type of difference and adds information only to the portion where the difference occurs between the first database and the second database. Therefore, the management device according to the first embodiment can suppress the processing load and quickly update the second database.

Further, in the management device according to the first embodiment, when the information acquired by the acquisition unit does not include the user name and the information stored in the second database includes the user name, the processing unit uses the acquisition unit. The date and time corresponding to the extraction of the user name and the difference are added to the acquired information. Therefore, the management device can identify and record the time when the difference occurs between the information stored in the first database and the information stored in the second database. Therefore, based on the information stored in the second database, the administrator can easily estimate when the asset has become a surplus asset, when it has been improperly used, and the like. ..

Further, the management device according to the first embodiment further includes an output control unit that outputs the user ID and the user name processed by the processing unit and the asset corresponding to the user ID to the output unit. Therefore, the administrator can estimate which asset is assigned to the retired user based on the information output from the output unit. Therefore, the manager can quickly and appropriately rearrange the assets based on the output from the management device. Further, when the information associated with the user ID is other than the user name, the management device can promote the rapid discovery of the surplus assets generated by the change of the organization. For example, when many department names stored in association with the user ID are changed at the same time, the administrator presumes that the organization has been reorganized or integrated based on the output of the management device, and is quick. You can take action.

[Modification example]
In the first embodiment, for convenience of explanation, the first table, the second table, and the third table are described as being stored on the management device 10. However, the present invention is not limited to this, and the management device 10 may be configured to store the first table and then extract the difference while referring to the second database. That is, the management device 10 may be configured not to include the second table storage unit 102. Further, for example, when the management device 10 is integrally configured with the second database 30, the first table to the third table may be stored in the second database 30.

Further, in the first embodiment, the personnel database and the asset management database have been described as examples of the first database and the second database. Not limited to this, the management device according to the first embodiment can be arranged between a plurality of arbitrary databases that independently manage the same information associated with specific information (user ID, etc.). ..

[Second Embodiment]
In the first embodiment described above, a configuration for maintaining an association between an asset managed by a predetermined organization and a user who uses the asset has been described. In particular, the first embodiment is configured so that when a user who belonged to a predetermined organization no longer belongs to the organization, the department and the user to which the asset is assigned can be tracked. On the other hand, the management system according to the second embodiment further enables estimation of the specific usage status of the asset. The management system according to the second embodiment acquires information related to the usage status of assets via a network. Then, the management system outputs an asset whose usage rate during a predetermined period of each asset meets a predetermined standard based on the acquired information.

FIG. 8 is a diagram showing an example of the configuration of the management system 2 according to the second embodiment. The configuration and function of the management system 2 according to the second embodiment are substantially the same as those of the management system 1 according to the first embodiment. Hereinafter, description of the configuration and functions common to the management system 1 according to the first embodiment will be omitted.

The management system 2 includes a management device 10A, a first database 20, and a second database 30. The management system 2 further includes a management device 10A, a network 40 that connects the first database 20 and the second database 30 so as to be communicable with each other. The management system 2 further includes a management device 10A, a first database 20 and a second database 30, and a server 50 communicably connected via the network 40. Although one server 50 is shown in FIG. 8, the number of information processing devices connected to the management device 10A on the management system 2 is not particularly limited. Further, not only the server 50 but also an information processing device having information related to the information stored in the first and second databases 20 and 30 can be connected to the management device 10A via the network 40.

The management device 10A acquires the usage status of the assets managed by the second database 30 via the network 40 in addition to the functions of the management device 10 according to the first embodiment. Further, the management device 10A extracts assets whose usage rate during a predetermined period is equal to or less than the first threshold value based on the acquired usage status. The management device 10A also extracts assets whose usage rate during a predetermined period is equal to or higher than the second threshold value based on the acquired usage status. The management device 10A also extracts departments whose average usage rate of assets during a predetermined period is equal to or less than the first threshold value or equal to or higher than the second threshold value based on the acquired usage status. The management device 10A outputs the extracted information.

Therefore, the acquisition unit 111A, the extraction unit 112A, and the output control unit 115A of the management device 10A have the following functions in addition to the functions of the acquisition unit 111, the extraction unit 112, and the output control unit 115 of the management device 10 of the first embodiment. Has a function.

The acquisition unit 111A acquires the usage status of the asset via the network. For example, the acquisition unit 111A acquires the usage status of the asset from the asset connected to the network 40. For example, the acquisition unit 111A acquires the power ON, power OFF, and the like of the asset. The acquisition unit 111A may acquire information directly from the asset, or may acquire information from a device such as a gateway or a server 50 connected to the asset.

The extraction unit 112A extracts assets whose usage rate during a predetermined period is equal to or less than the first threshold value based on the information acquired by the acquisition unit 111A. For example, the extraction unit 112A extracts an asset for which a predetermined period has passed since the start of use of the asset in the organization. Then, the extraction unit 112A calculates the usage rate of the asset during a predetermined period based on the acquired information. For example, the extraction unit 112A first extracts from the second database 30 the assets that have been used for 3 months or more at that time. Then, the extraction unit 112A calculates the usage rate of the asset from 3 months ago to that time based on the acquired information. The extraction unit 112A then extracts assets whose utilization is equal to or less than the first threshold value. For example, the extraction unit 112A extracts an asset having a usage rate of 10% or less from 3 months ago to that time. If the asset is properly used for business, the utilization rate of the asset is expected to meet the specified value. The first threshold is, for example, the average value of the utilization rate when the asset is properly used for business. In this case, it can be estimated that the assets whose utilization rate is equal to or less than the first threshold value are not properly used.

The extraction unit 112A also extracts assets whose usage rate during a predetermined period is equal to or higher than the second threshold value based on the information acquired by the acquisition unit 111A. For example, the extraction unit 112A extracts from the second database 30 the assets that have been used for 3 months or more at that time. Then, the extraction unit 112A calculates the usage rate of the asset from 3 months ago to that time based on the acquired information. The extraction unit 112A then extracts assets whose utilization rate is equal to or higher than the second threshold value. The second threshold is, for example, a value that greatly deviates from the utilization rate when the asset is properly used for business. For example, it is assumed that a PC used in a company that works 8 hours out of 24 hours a day is logged on for 20 hours or more a day. Even when considering overtime, this value deviates significantly from what would be expected if the asset were properly used for business. In this case, it can be estimated that the assets whose utilization rate is equal to or higher than the second threshold value are not properly used.

The extraction unit 112A also extracts assets from the second database 30 for each department to which the assets are assigned. Then, the extraction unit 112A extracts a department in which the average usage rate of the asset during a predetermined period is equal to or less than the first threshold value or equal to or higher than the second threshold value based on the usage status of the asset. In this way, the extraction unit 112A extracts the departments that are presumed to be not using the assets properly. The method for setting the first threshold value and the second threshold value is not particularly limited.

The output control unit 115A causes the output unit 140 to output the assets and departments extracted by the extraction unit 112A. For example, the output control unit 115A selects an asset extracted by the extraction unit 112A from the assets stored in association with the difference information in the second database 30, and outputs a list of the selected assets to the output unit 140. Let me. The output control unit 115A may be configured to change the display mode on the output list according to whether the usage rate of the asset is equal to or less than the first threshold value or equal to or greater than the second threshold value. 1st alert, 2nd alert). Further, the output control unit 115A superimposes a department having an average usage rate of less than or equal to the first threshold value or more than or equal to the second threshold value on the display of assets having an average usage rate of less than or equal to the first threshold value or greater than or equal to the second threshold value. It may be configured to be displayed on the list.

The configurations and functions of the management device 10A other than the acquisition unit 111A, the extraction unit 112A, and the output control unit 115A are the same as those of the management device 10 according to the first embodiment.

FIG. 9 is a flowchart for explaining an example of the processing flow in the management device according to the second embodiment. The management device according to the second embodiment executes the process shown in FIG. 7 independently or in parallel with the process shown in FIG.

First, the acquisition unit 111A acquires the usage status of the assets stored in the second database 30 (step S91). The extraction unit 112A determines whether or not the usage rate of each asset during a predetermined period is equal to or less than the first threshold value based on the acquired usage status (step S92). When it is determined that the usage rate is equal to or less than the first threshold value (step S92, Yes), the extraction unit 112A instructs the output control unit 115A to add the first alert corresponding to the asset in the output list (step S92, Yes). Step S93). On the other hand, when it is determined that the usage rate exceeds the first threshold value (step S92, No), the extraction unit 112A then determines whether or not the usage rate of each asset during the predetermined period is equal to or higher than the second threshold value. (Step S94). When it is determined that the usage rate is equal to or higher than the second threshold value (step S94, Yes), the extraction unit 112A instructs the output control unit 115A to add a second alert corresponding to the asset in the output list (step S94, Yes). Step S95). On the other hand, when the extraction unit 112A determines that the usage rate is less than the second threshold value (step S94, No), the extraction unit 112A proceeds to step S96. Then, the output control unit 115A causes the output unit 140 to output an output list to which the first alert and the second alert are added based on the processing of the extraction unit 112A (step S96). This completes the process.

The process shown in FIG. 9 may be configured to add a first alert and a second alert to the list output in step S77 based on the process of FIG. 7. Further, the process shown in FIG. 9 may be configured to be executed by the management device 10 separately from the process shown in FIG. 7. Further, the management device 10A may be configured to execute only one of the process of adding the first alert (steps S92 and S93) and the process of adding the second alert (steps S94 and S95). good. Further, in the process shown in FIG. 9, the management device 10A may be configured to process only the assets stored in the second database 30 in association with a predetermined department.

[Effect of the second embodiment]
As described above, in the management device according to the second embodiment, the acquisition unit further acquires the usage status of the assets via the network. The extraction unit extracts assets whose usage rate during a predetermined period is equal to or less than the first threshold value based on the usage status acquired by the acquisition unit. The output control unit causes the output unit to output the assets extracted by the extraction unit among the assets stored in the second database corresponding to the user ID acquired by the acquisition unit. Therefore, the management device according to the second embodiment can easily track the usage status of the assets. For example, according to the management device according to the second embodiment, not only can an asset that has become a surplus asset due to the user's retirement be found, but the asset is not actually used and is no longer needed. Can be known by the administrator. Further, according to the management device according to the second embodiment, the manager can easily find an asset that is assigned to the incumbent user but is not effectively utilized.

Further, in the management device according to the second embodiment, the extraction unit extracts assets whose usage rate during a predetermined period is equal to or higher than the second threshold value based on the usage status acquired by the acquisition unit. Then, the output control unit causes the output unit to output the assets extracted by the extraction unit among the assets corresponding to the user ID. Therefore, the management device according to the second embodiment can make the manager discover the assets and the like that are left with the power turned on, and contribute to the effective utilization of the assets. In addition, the management device according to the second embodiment allows the manager to easily find an entity or the like in which the asset is used without being properly managed. For example, the management device can promote the discovery that the PC used by the retired person is being used by another user without reporting the PC to which the PC is deployed to the asset management department. In addition, the management device according to the second embodiment allows the manager to easily find a department or the like in which the assets are not sufficiently arranged.

Further, in the management device according to the second embodiment, the acquisition unit further acquires the department associated with the user ID from the first database. Then, in the management device according to the second embodiment, the acquisition unit further acquires the usage status of the assets via the network. The extraction unit extracts the departments whose average usage rate of assets during a predetermined period is equal to or less than the first threshold value or equal to or greater than the second threshold value, based on the departments acquired by the acquisition unit and the usage status. The output control unit outputs the department extracted by the extraction unit to the output unit. Therefore, according to the second embodiment, the management device can easily make the manager find a department having a large amount of surplus assets by the output from the management device. In addition, the management device can easily make the manager find a department lacking assets by the output from the management device. In addition, the management device can promptly detect an improper asset allocation by the output from the management device.

Further, in the management device according to the second embodiment, the acquisition unit acquires the usage status of the assets that have been used before the predetermined period during the predetermined period. Therefore, the management device can realize more accurate determination of the usage status by not using the asset or the like that has just started to be used for the determination of the usage status. Further, the management device can output more effective information by setting a predetermined period, for example, a period of 3 months immediately before that point.

[Third Embodiment]
Although examples of the disclosed management device, management method, and management program have been described so far, the present invention may be implemented in various different forms other than the above-mentioned examples. Therefore, another embodiment included in the present invention will be described below.

[Implementation by cloud computing]
The disclosure management program can be implemented on the servers that make up the cloud system and used to link information between different databases via the cloud system. In this way, it is possible to effectively utilize the information held by each department while maintaining the independence of information among a large number of departments.

[Distributed and integrated]
Each component of each of the illustrated devices does not necessarily have to be physically configured as shown. That is, the specific form of distribution / integration of each device is not limited to the one shown in the figure, and all or part of them may be functionally or physically distributed / physically in any unit according to various loads and usage conditions. Can be integrated and configured. For example, in the above embodiment, the function described as the function of the management device 10 can be implemented as the function of the application running on the second database 30. The arrangement of each function can be determined based on the processing capacity of the management device 10 and the first database 20 and the like.

[Management program]
Further, in the various processes described in the above embodiment, a program prepared in advance is distributed from a computer such as a server to a computer such as a tablet terminal or a notebook computer, and the server and the computer cooperate to execute the processes. It can be realized by doing. Therefore, in the following, an example of a computer that executes a management program having the same function as that of the above embodiment will be described with reference to FIG.

FIG. 10 is a diagram for explaining an example of a computer that executes the management program according to the first to third embodiments. As shown in FIG. 10, the computer 1000 has an operation unit 1100, a display 1200, and a communication unit 1300. Further, the computer 1000 has a CPU (Central Processing Unit) 1400, a ROM (Read Only Memory) 1500, a RAM (Random Access Memory) 1600, and an HDD (Hard Disk Drive) 1700. Each part of these 1100 to 1700 is connected via a bus 1800.

As shown in FIG. 10, the HDD 1700 stores in advance a management program 1700a capable of mounting a module exhibiting the same function as each part shown in the first embodiment. The management program 1700a may be integrated or separated as appropriate, as in the case of each component shown in FIG. That is, as for each data stored in the HDD 1700, not all the data need to be stored in the HDD 1700 at all times, and only the data necessary for processing needs to be stored in the HDD 1700.

Then, the CPU 1400 reads each module of the management program 1700a from the HDD 1700 and expands it into the RAM 1600. As a result, as shown in FIG. 10, the management program 1700a functions as the management process 1600a. The management process 1600a appropriately expands various data read from the HDD 1700 into an area allocated to itself on the RAM 1600, and executes various processes based on the expanded various data. The management process 1600a includes a process executed by each processing unit shown in FIG. Further, in each processing unit virtually realized on the CPU 1400, it is not always necessary for all the processing units to operate on the CPU 1400, and only the necessary processing units need to be virtually realized.

The above management program 1700a does not necessarily have to be stored in the HDD 1700 or ROM 1500 from the beginning. For example, each program is stored in a "portable physical medium" such as a flexible disk or a CD-ROM (Compact Disk Read Only Memory) inserted in the computer 1000. Alternatively, each program is stored in a "portable physical medium" such as a DVD (Digital Versaille Disc) disk, a magneto-optical disk, or an IC card. Then, the computer 1000 may acquire and execute each program from these portable physical media. Further, each program may be stored in another computer or server device connected to the computer 1000 via a public line, the Internet, a LAN, a WAN (Wide Area Network), or the like. Then, the computer 1000 may acquire each program from these and execute the program.

1, 10A Management system 10, 10A Management device 100 Storage unit 101 First table storage unit 102 Second table storage unit 103 Third table storage unit 110, 110A Control unit 111, 111A Acquisition unit 112, 112A Extraction unit 113 Processing unit 114 Update unit 115, 115A Output control unit 120 Communication unit 130 Input unit 140 Output unit 20 First database 30 Second database 40 Network

Claims (8)

An acquisition unit that acquires a user ID and a user name associated with the user ID at the first timing from the first database of a predetermined organization, and
An extraction unit that extracts the difference between the user ID and the user name stored in the second database of the predetermined organization in association with the assets managed by the organization and the user ID and the user name acquired by the acquisition unit. ,
Based on the difference extracted by the extraction unit, the processing unit that processes the user ID and user name acquired by the acquisition unit, and the processing unit.
An update unit that updates the second database based on the processing result of the processing unit,
Equipped with
When the information acquired by the acquisition unit does not include the user name and the information stored in the second database includes the user name, the processing unit includes the user name and the difference in the information acquired by the acquisition unit. Add difference information indicating the type of difference along with the date and time corresponding to the extraction of
A management device characterized by that. The management device according to claim 1 , further comprising an output control unit for outputting a user ID and a user name processed by the processing unit, an asset corresponding to the user ID, and an output unit. The acquisition unit further acquires the usage status of the asset via the network.
The extraction unit extracts assets whose usage rate during a predetermined period is equal to or less than the first threshold value based on the usage status acquired by the acquisition unit.
The management device according to claim 2 , wherein the output control unit outputs the assets extracted by the extraction unit to the output unit among the assets corresponding to the user ID. The acquisition unit further acquires the usage status of the asset via the network.
The extraction unit extracts assets whose usage rate during a predetermined period is equal to or higher than the second threshold value based on the usage status acquired by the acquisition unit.
The management device according to claim 2 , wherein the output control unit outputs the assets extracted by the extraction unit to the output unit among the assets corresponding to the user ID. The acquisition unit further acquires the department associated with the user ID from the first database, acquires the usage status of the asset via the network, and obtains it.
The extraction unit extracts departments in which the average usage rate of assets during a predetermined period is equal to or less than the first threshold value or equal to or greater than the second threshold value, based on the department acquired by the acquisition unit and the usage status.
The management device according to claim 2 , wherein the output control unit outputs a department extracted by the extraction unit to the output unit. The management device according to any one of claims 3 to 5 , wherein the acquisition unit acquires the usage status of an asset that has been used before the predetermined period. On the computer
A user ID and a user name associated with the user ID are acquired from the first database of a predetermined organization at the first timing.
The difference between the acquired user ID and user name and the acquired user ID and user name stored in the second database of the predetermined organization in association with the assets managed by the organization is extracted.
Based on the extracted difference, the acquired user ID and user name are processed.
The second database is updated based on the processing result.
Execute each process including
In the processing, when the acquired information does not include the user name and the information stored in the second database includes the user name, the acquired information includes the user name and the date and time corresponding to the extraction of the difference. Add difference information indicating the type of difference
A management method characterized by executing each process including the above. A user ID and a user name associated with the user ID are acquired from the first database of a predetermined organization at the first timing.
The difference between the acquired user ID and user name and the acquired user ID and user name stored in the second database of the predetermined organization in association with the assets managed by the organization is extracted.
Based on the extracted difference, the acquired user ID and user name are processed.
The second database is updated based on the processing result.
Let the computer perform the process including each procedure ,
In the processing, when the acquired information does not include the user name and the information stored in the second database includes the user name, the acquired information includes the user name and the date and time corresponding to the extraction of the difference. Add difference information indicating the type of difference
A management program characterized by that.

Images