JP4891192B2 - Information processing apparatus management system, information processing apparatus management program, and information processing apparatus management method - Google Patents

Description

  The present invention relates to a management system for an information processing apparatus, and more particularly to a system for managing entry / exit (addition, collection, etc.) of an information processing apparatus, which is hardware that requires various settings according to usage conditions. The present invention also relates to a system that facilitates database structure change (logical table structure change) even after system operation has started.

  For example, the management of articles in a warehouse or the like becomes very complicated when there are many or many articles or management items. Patent Documents 1 to 5, etc. disclose conventional technologies related to improving the efficiency of management of entry / exit and reducing management errors by performing such article management by the system. Further, Patent Document 6 discloses a conventional technique related to a database that facilitates the addition of various types of related data without changing the database structure.

JP-A-11-53431 JP 2001-255927 A JP 2003-192111 A JP 2003-192111 A JP-A-2005-312602 WO04 / 097679

  In recent enterprises, etc., a network is formed in the enterprise, and an information processing device (which may be simply referred to as a personal computer or a PC hereinafter) is assigned to each user (employee, etc.). It has become common. When the scale of a company or the like increases, a considerable number of personal computers will be held, and fluctuations in users (employees, etc.) will frequently occur. Therefore, it is very rare that all the personal computers owned by the company are used by users, and it will be used by adding or collecting personal computers as needed (joining / transferring / leaving). Computers that have not been put into storage. That is, it is necessary to manage the receipt and delivery of personal computers at the storage location.

  However, since the information processing apparatus requires various settings depending on the user to be used, the management of the information processing apparatus cannot be made efficient only by management as an article (hardware). That is, for example, even when considering one IP address setting when adding a personal computer, conventionally, an administrator who manages the IP address of the installation destination is assigned an address, An operator needs to set the assigned IP address on a personal computer and install (add) it, which can cause complicated setting work and errors in setting work. . Such a problem cannot be solved by a warehouse management system for simple goods (hardware) as described above. Both hardware and software (various setting information, rules for determining this, etc.) A management system considered as a management target is desired.

  In view of the above points, the present invention is a management system for managing an information processing apparatus, which is necessary not only for management of entry / exit of a hardware information processing apparatus itself, but also for processing performed on the information processing apparatus. It is an object of the present invention to provide an information processing apparatus management system capable of managing various setting information and rules for determining the setting information in association with loading / unloading of the information processing apparatus. In addition, even if the logical table structure changes after the system starts operating, the table structure can be easily changed without requiring major system modifications such as redefining the database structure. An object of the present invention is to provide such a system.

  The information processing apparatus management system according to claim 1 manages a plurality of information processing apparatuses that can have any status of an operating state used by a user and a storage state that is not used. An information processing apparatus management system, an information processing apparatus management table in which an information processing apparatus identification code for identifying each information processing apparatus and status information indicating an operating state or a storage state are stored in association with each other; a management server; A terminal setting device that executes a setting process for the information processing device connected in accordance with a command from the management server, and a rule storage unit that stores rules to be processed for various requests. When the request is made to the management server, the management server refers to the rule storage unit, and from the request, Generating setting information or a processing instruction to be set for the information processing apparatus based on the information, and sending the setting information to the terminal setting apparatus, thereby automatically setting the information processing apparatus connected to the terminal setting apparatus. And updating the status information of the information processing apparatus management table in accordance with the processing.

  According to the above configuration, by providing a rule storage unit that stores rules to be processed in response to a request (for example, an expansion request), a rule can be generated when a request for an expansion request is input to the management server. The “setting information or processing instruction to be set for the information processing apparatus” is automatically generated with reference to FIG. 6, and the setting process for the information processing apparatus is automatically performed by the terminal setting apparatus. For example, “IP address in branch A is a1 to a100”, “Use an IP address within the range assigned to each branch for expansion requests”, “For stored requests for expansion requests Execute IP address setting ”in the rule storage unit, and if there is a request for“ addition of a PC to the branch office A ”(exit request from the storage location side) In accordance with the rules, a processing command for the stored personal computer and necessary setting information are generated, whereby the personal computer setting process is performed. In addition, when the request is “addition of a PC to the A branch office”, status information corresponding to the issued PC (PC for which setting processing has been performed) is updated from the storage state to the operating state, etc. Thus, the storage management as hardware is also performed. In addition, although each component is described functionally, each component is not limited to each piece of hardware. For example, the management server and the terminal setting device have the same hardware (box). It does not matter if it is housed in a configuration.

  The information processing apparatus management system according to claim 2 is the information processing apparatus management system according to claim 1, wherein when the requested addition request is made to the management server, the management server performs the rule. By referring to the storage unit, generating the setting information or processing command to be set for the information processing apparatus in the storage state based on the rule from the extension request, and sending the setting information or processing instruction to the terminal setting apparatus, the terminal The setting process for the information processing apparatus connected to the setting apparatus in the storage state is automatically performed, and the corresponding status information in the information processing apparatus management table is set to the operating state, or the requested collection request or relocation is performed. If there is a request or update request to the management server, the management server refers to the rule storage unit, and The terminal setting is generated by generating setting information or a processing command to be set for the information processing apparatus in the operating state based on the rule from the collection request, the transfer request, or the update request, and sending it to the terminal setting apparatus. A setting process for the information processing apparatus connected to the apparatus in the operating state is automatically performed.

  According to the above configuration, when the request is an expansion request, the processing (processing based on the setting information generated based on the rule or the processing instruction) for the information processing apparatus in the storage state is automatically performed, and the request Is a collection request, a relocation request, or an update request, the processing for the information processing apparatus in the operating state is automatically performed.

  The information processing device management system according to claim 3 is the information processing device management system according to claim 1, wherein there are a plurality of storage locations for storing the information processing devices in the storage state, and each of the storage locations has the storage location. A terminal setting device, comprising a terminal setting device management table storing a terminal setting device identification code for identifying each terminal setting device and respective storage location information, and each of the information processing device management tables includes When the request for expansion is made to the management server by storing the installation location information or storage location information of the information processing device, the management server refers to the rule storage unit, Generating setting information or a processing instruction to be set for the information processing apparatus in the storage state based on the rule from the extension request; And determining which storage location information processing device is to be used based on the service, and sending the setting information or processing command to the terminal setting device provided in the determined storage location. To automatically perform the setting process for the information processing apparatus in the storage state connected to the terminal setting apparatus, and set the corresponding status information in the information processing apparatus management table to the operating state, or the request. When the collection request is made to the management server, the management server refers to the rule storage unit, and should be set for the information processing apparatus in the operating state based on the rule from the collection request. Generate setting information or processing instructions, determine which storage location to store the information processing apparatus in the operating state based on the rules, By sending the setting information or a processing command to the terminal setting device provided in the determined storage location, setting processing for the information processing device in the operating state connected to the terminal setting device is performed. Automatically performing the corresponding status information in the information processing device management table, or if the requested relocation request or update request is made to the management server, the management server Refer to the rule storage unit, generate setting information or a processing command to be set for the information processing apparatus in the operating state based on the rule from the transfer request or update request, and based on the rule, It is determined whether the terminal setting device in the storage location is to execute the setting process, and the determined terminal setting device By sending the setting information or the processing command, the setting process for the information processing apparatus in the operating state connected to the terminal setting apparatus is automatically performed.

  According to the above configuration, when there are a plurality of storage locations, it is determined, for example, which storage location the information processing apparatus should be delivered to (based on the rule setting) based on regional factors.

  An information processing apparatus management system according to claim 4 is the information processing apparatus management system according to any one of claims 1 to 3, wherein the request is received by providing a printer that outputs various forms. If there is, the management server refers to the rule storage unit, generates work instruction information for the worker based on the rule from the request, and generates a work instruction sheet describing the work instruction content in the printer. It is made to print.

  According to the above configuration, based on the rules, an instruction sheet corresponding to each request (for example, an instruction sheet in which a delivery instruction or an installation instruction is described in the case of an expansion request) is automatically generated.

  The information processing apparatus management system according to claim 5 manages a plurality of information processing apparatuses that can have any status of an operating state used by a user and a storage state that is not used. An information processing apparatus management system, an information processing apparatus management table in which an information processing apparatus identification code for identifying each information processing apparatus and status information indicating an operating state or a storage state are stored in association with each other; a management server; , A terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server, a rule storage unit that stores rules to be processed for various requests, and outputs various forms And an output device capable of outputting information attachment means capable of reading information by optical or electromagnetic techniques. By providing the terminal setting device with an information reading unit capable of reading information from the attachment means, and attaching the information attachment means to each information processing device having the information of the identification code corresponding to the information processing device. If the request is for the management server, the management server refers to the rule storage unit, and setting information or processing to be set for the information processing apparatus based on the rule from the request Generating an instruction, generating an instruction code corresponding to the processing, and causing the output device to output the information attachment means having the information of the instruction code; referring to the rule storage unit, the rule from the request The work instruction information for the worker is generated on the basis of the information and the work instruction document describing the contents of the work instruction is printed on the printer. In the management server that has received the read information transmitted from the terminal setting device by reading the attached information attachment unit and the information attachment unit attached to the information processing device by the information reading unit, A process is associated with an information processing apparatus to perform the process, and the setting information or the processing command is sent to the terminal setting apparatus, thereby performing setting processing for the information processing apparatus connected to the terminal setting apparatus. It is automatically performed, and corresponding status information in the information processing apparatus management table is updated according to the processing.

  According to the above configuration, each process and the process are performed by a simple operation of reading the information attachment unit (for example, an IC chip) attached to the work instruction and the information attachment unit attached to the information processing apparatus by the information reading unit. Association with an information processing apparatus to be performed is performed, and setting processing for the information processing apparatus is automatically performed.

  The information processing apparatus management system according to claim 6 is the information processing apparatus management system according to claim 5, wherein the request is an expansion request, and the information processing apparatus in which the setting process is performed is in the storage state. It is an information processing apparatus, or the request is a collection request, a transfer request, or an update request, and the information processing apparatus in which the setting process is performed is the information processing apparatus in the operating state. To do.

  The information processing device management system according to claim 7 is the information processing device management system according to claim 5, wherein there are a plurality of storage locations for storing the information processing devices in the storage state, and each of the storage locations includes the storage device. A terminal setting device, a printer, and an output device, each including a terminal setting device management table storing a terminal setting device identification code for identifying each terminal setting device and each storage location information; By providing an information processing device management table storing information processing device identification codes for identifying information processing devices and installation location information or storage location information of the respective information processing devices, the requested increase request is sent to the management server. If there is an error, the management server refers to the rule accumulating unit, and from the expansion request, determines what is based on the rule. Attaching information that determines whether to use the information processing device in the storage location, and has the printer and the output device provided in the determined storage location have the information on the work instruction and the instruction code If the collection request is output to the management server, the management server refers to the rule storage unit, and any storage location based on the rule from the collection request. To determine whether to store the information processing device in the operating state, and to give the information of the work instruction and the instruction code to the printer and the output device provided in the determined storage location When the information attachment means is output or the request for relocation or update requested is sent to the management server, the management server sends the information The storage unit is referred to, based on the rule from the relocation request or the update request, it is determined whether the terminal setting device in the storage location is to execute the setting process, and the determined storage location is provided. The printer and the output device output information attaching means having the work instruction document and the instruction code information.

  The information processing apparatus management system according to claim 8 is the information processing apparatus management system according to claim 6 or 7, wherein the setting process is performed when the request is an expansion request. The information attachment means for attaching to the storage member for packing the information, the information attachment means having information indicating the contents of the storage member generated by the management server is output to the output device It is characterized by making it.

  According to the above configuration, for example, an information attachment means (for example, an IC chip or a barcode) having information indicating the contents is attached to a cardboard box for loading a personal computer. By reading the information with the information reading unit, the contents can be confirmed. The “information attachment means having information indicating the contents of the storage member” is not limited to “information attachment means” in which various types of information related to the contents are stored directly, but “information attachment means” Includes a table in which only the ID of the box is stored, and the contents can be confirmed by having a table in which the system stores various IDs related to the ID in association with each other. It is.

  An information processing device management system according to claim 9 is the information processing device management system according to any one of claims 5 to 8, wherein the information attachment means is a barcode, and the information reading device The unit is a bar code reader, and the printer also functions as the output device by causing the printer to print a bar code having the instruction code information on the work instruction sheet.

  An information processing apparatus management system according to claim 10 is the information processing apparatus management system according to any one of claims 1 to 9, wherein the information processing apparatus management system is an information processing apparatus in a specific company. And when the management server receives personnel information from a personnel management server that manages personnel data in the specific company, the management server refers to the rule storage unit and determines from the personnel information The request is generated based on the rule, and each process is executed according to the generated request.

  According to the above configuration, based on the personnel information obtained from the personnel management server, the management server generates a request (such as an expansion request) with reference to the rules. For example, by establishing a rule such as “Generate an expansion request when new employee personnel information (including assignment location information) is obtained”, an expansion request is automatically generated from the personnel information. The Rukoto.

  An information processing apparatus management system according to an eleventh aspect is the information processing apparatus management system according to any one of the first to tenth aspects, wherein the table storing the rules or various types of information is stored in association with each other. The logical table structure is a table for managing the series of data as rows by storing the series of data in each column defining attributes common to the data. When recording in the database provided, it is recorded as a record having, as field values, row identification information indicating the attributes of the series of data, column identification information indicating the common attributes, and the data .

  According to the above configuration, regardless of the logical table structure, the record registered in the database has a structure having three field values of row identification information, column identification information, and data. . The database functions as the rule storage unit when the “table storing the rules” is stored as a record of the above format.

  An information processing apparatus management system according to claim 12 is the information processing apparatus management system according to claim 11, wherein the column identification information corresponding to each column is defined in the definition file defining the table structure. And an input data file having a series of data conforming to the column structure defined by the column structure definition file and having a series of data associated with the row identification information. Are obtained, the row identification information corresponding to each data obtained from the input data file is obtained, and the column identification information corresponding to each data is obtained from the column structure definition file. Updated to record in the database a record having the row identification information, column identification information, and the data as field values And wherein the Rukoto.

  According to the above configuration, three field values of row identification information, column identification information, and data are obtained from a table structure (logical table structure) determined based on the column structure definition file and an input data file according to the table structure. A record with it will be generated and recorded in the database. The column structure definition file may be input to the system together with the input data file, or may be registered in advance in the system.

  An information processing apparatus management system according to claim 13 is the information processing apparatus management system according to claim 12, wherein when there is no data in the series of data in the input data file, If the record specified by the row identification information and the column identification information does not exist at the time of reading information from the database without storing the corresponding record in the database, the row Empty data is output as data corresponding to the identification information and the column identification information.

  According to the above configuration, no record is stored in the database for no data (blank), and empty data is output when there is no corresponding record when reading data. For example, since not all cells of the table that is the input data file are filled with data, cells without such data are not registered in the database as records, and the corresponding records are read when data is read. When it is determined that there is no data, the same structure as the original input data file can be reproduced by outputting empty data. Note that empty data means that there is no value as data, and “empty data” in the present invention is a concept including data indicating that there is no data, null, and the like.

  The information processing apparatus management program according to claim 14 manages a plurality of information processing apparatuses that can have any status of an operating state used by a user and a storage state that is not used. An information processing device management system, comprising: a management server; a terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server; and rules to be processed for various requests A stored rule storage unit; a printer that outputs various forms; and an output device that can output information attachment means that can read information by optical or electromagnetic techniques. A readable information reading unit is provided in the terminal setting device, and each information processing device has information on the identification code corresponding to the information processing device. When the request is made to the management server in the information processing apparatus management system with the information attachment means provided with the information, the rule storage unit is referred to when the request is made to the management server. Generating setting information or a processing instruction to be set for the information processing apparatus, generating an instruction code corresponding to the processing, and the information attaching unit having the instruction code information Outputting to the output device; generating work instruction information for an operator based on the rule from the request with reference to the rule storage unit; and printing a work instruction sheet describing the contents of the work instruction on the printer And when the terminal setting device transmits an identification code of the information processing device and the instruction code, Transmitting the information for setting the setting information or processing instructions according to the instruction code to the information processing apparatus corresponding to the identification code thus received to said terminal setting device, characterized in that to the execution.

  The information processing device management program according to claim 15 is the information processing device management program according to claim 14, wherein there are a plurality of storage locations for storing the information processing devices in the storage state, and each of the storage locations includes the storage device. A terminal setting device, a printer, and an output device, each including a terminal setting device management table storing a terminal setting device identification code for identifying each terminal setting device and each storage location information; By providing an information processing device management table storing information processing device identification codes for identifying information processing devices and installation location information or storage location information of the respective information processing devices, the requested increase request is sent to the management server. Information on any storage location based on the rules from the expansion request with reference to the rule storage unit A step of determining whether or not to use a physical device, and an output of information attached to the printer and the output device provided with the determined storage location with information on the work instruction and the instruction code. Or when the requested collection request is made to the management server, refer to the rule accumulating unit and move the operation from the collection request to any storage location based on the rule. A step of determining whether or not to store the information processing device in the state, and information that gives the information of the work instruction and the instruction code to the printer and the output device provided in the determined storage location Outputting the attachment means, or executing the step when the requested relocation request or update request is made to the management server. A step of referring to the storage unit to determine whether the terminal setting device in the storage location is to execute the setting process based on the rule from the relocation request or the update request; and the prepared storage location Causing the printer and the output device to output the information attachment means having the work instruction and the information of the instruction code.

  An information processing device management program according to claim 16 is the information processing device management program according to claim 14 or 15, wherein the information processing device management system manages information processing devices in a specific company. Yes, when the management server receives personnel information from the personnel management server that manages personnel data in the specific company, the request is generated based on the rules from the personnel information with reference to the rule storage unit The step to perform is performed.

  An information processing apparatus management program according to claim 17 is the information processing apparatus management program according to any one of claims 14 to 16, wherein a table storing the rule or various types of information is held in association with each other. The logical table structure is a logical table structure of a table that manages a series of data as rows by storing the series of data in each column defining attributes common to the data. A definition file for defining a general table structure, which includes a column structure definition file in which column identification information indicating the common attribute corresponding to each column is defined, and a column structure defined by the column structure definition file. An input data file having a series of data corresponding to a series of data associated with row identification information indicating attributes of the series of data Is input to the system, the step of acquiring row identification information corresponding to each data obtained from the input data file and the column identification information corresponding to each data are obtained from the column structure definition file. A step, generating a record having the acquired row identification information, column identification information, and the data as field values; and registering the generated record in a database included in the system.

  An information processing apparatus management program according to claim 18 is the information processing apparatus management program according to claim 17, wherein it is determined whether or not there is no data in a series of data in the input data file. The step of registering the record in the database only for the data for which the determination result data exists, and the reading of the information from the database by the row identification information and the column identification information. A step of determining whether or not a specified record exists, and a step of outputting empty data as data corresponding to the row identification information and the column identification information when the corresponding record does not exist It is characterized by doing.

  The information processing apparatus management method according to claim 19 manages a plurality of information processing apparatuses that can have any status of an operating state used by a user and a storage state that is not used. An information processing device management method by an information processing device management system, comprising: a management server; a terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server; and various requests A rule storage unit that stores rules to be processed, a printer that outputs various forms, and an output device that can output information attachment means that can read information by optical or electromagnetic techniques, An information reading unit capable of reading information from an information attachment unit is provided in the terminal setting device, and each information processing device corresponds to the information processing device. By attaching the information attaching means having the identification code information, the request is input to the management server, so that the setting information to be set for the information processing apparatus or the instruction code corresponding to the processing instruction is set. The information attaching means having the information is output to the output device, and the work instruction information for the worker is generated and the work instruction document describing the work instruction content is printed on the printer, and the work instruction is output. Each of the processes by attaching the output information attaching means to the document and reading the information attaching means attached to the work instruction and the information attaching means attached to the information processing apparatus by the information reading unit. Is associated with the information processing apparatus to perform the processing, and the management server that has received the information sends the setting information or processing instruction to the terminal setting device And by, characterized in that to automatically perform the setting processing for the information processing apparatus connected to the terminal setting device.

  The information processing apparatus management method according to claim 20 manages a plurality of information processing apparatuses that can have any status of an operating state used by a user and a storage state that is not used. An information processing device management method by an information processing device management system, comprising: a management server; a terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server; and various requests A rule storage unit that stores rules to be processed, and a printer that outputs various forms, the terminal setting device includes a barcode reader, and each information processing device corresponds to the information processing device By attaching a barcode with information of the identification code to be received, the request is input to the management server, so that the information processing apparatus The printer prints a work instruction sheet in which the bar code having the setting information to be set or the instruction code information corresponding to the processing instruction and the contents of the work instruction for the worker are printed on the printer. By reading the printed barcode and the barcode attached to the information processing apparatus with the barcode reader, the processes are associated with the information processing apparatus to be processed, and the information is received. By sending the setting information or processing command to the terminal setting device, the management server that has performed the setting processing for the information processing device connected to the terminal setting device is automatically performed.

  The first database system according to the present invention manages a series of data as rows by storing a series of data in each column in which attributes common to each data are defined as a logical table structure. A database system, comprising a control device and a storage device, as a record having row identification information indicating an attribute of the series of data, column identification information indicating the common attribute, and the data as field values It is recorded in a storage device.

  A second database system according to the present invention is the first database system described above, which is a definition file that defines the table structure, and the column structure definition in which the column identification information corresponding to each column is defined A file and an input data file having a series of data according to the column structure defined by the column structure definition file and having a series of data associated with the row identification information are input to the system. The control device acquires row identification information corresponding to each data obtained from the input data file, and obtains column identification information corresponding to each data from the column structure definition file. A record having the row identification information, the column identification information, and the data as field values is recorded in the storage device. And features.

  The third database system according to the present invention is the second database system described above, and corresponds to the case where there is no data in the series of data in the input data file. If the record specified by the row identification information and the column identification information does not exist when reading the information from the storage device without storing the record in the storage device, the row identification information and It is characterized in that empty data is output as data corresponding to the column identification information.

  A first database processing program according to the present invention includes a control device and a storage device, and stores a series of data in each column defining attributes common to each data as a logical table structure. As a definition file that defines a logical table structure in the database system that manages the series of data as a column structure definition file in which column identification information indicating the common attribute corresponding to each column is defined, An input data file having a series of data conforming to the column structure defined by the column structure definition file and having a series of data associated with row identification information indicating attributes of the series of data is input. A row identification information corresponding to each data obtained from the input data file, and a column identification corresponding to each data. Acquiring information from the column structure definition file; generating a record having the acquired row identification information, column identification information, and the data as field values; and registering the generated record in the storage device And executing the step.

  A second database processing program according to the present invention is a step of determining whether or not there is any data in the series of data in the input data file that is the first database processing program. The process of registering the record in the storage device only for the data for which the determination result data exists, and specifying the row identification information and the column identification information when reading the information from the storage device A step of determining whether or not a record to be recorded exists, and a step of outputting empty data as data corresponding to the row identification information and the column identification information when the corresponding record does not exist It is characterized by that.

  According to the information processing apparatus management system of claim 1 of the present invention, a request is stored in the management server by storing a rule storage unit that stores rules to be processed in response to a request (for example, an expansion request). Is input to the information processing apparatus, the "setting information or processing instruction to be set for the information processing apparatus" is automatically generated with reference to the rule, and the terminal setting apparatus automatically sets the information processing apparatus. Therefore, it is possible to improve the work efficiency as compared with the case where the setting process is performed manually, to prevent problems caused by input errors, and to reduce the risk of information leakage. In addition, since the “rule storage unit” is provided, it is possible to easily change the definition of various processing operations and the like by appropriately changing and updating the rules stored in the rule storage unit. Excellent system operation flexibility.

  According to the information processing apparatus management system of the fifth aspect of the present invention, the information reading unit (for example, an IC chip) attached to the work instruction and the information attachment means attached to the information processing apparatus are read by the information reading unit. By a simple operation, each process is associated with an information processing apparatus to perform the process, and a setting process for the information processing apparatus is automatically performed. Therefore, the worker can perform work (for example, work that requires manpower such as shipping work) while confirming the work instruction sheet, so that work leakage is prevented and the setting process to the information processing apparatus is performed as follows: Since it is automatically performed only by reading the information attachment means by the information reading unit, the operation is simple and mistakes can be prevented.

  According to the information processing apparatus management system of claim 8 of the present invention, there is an information attachment means (for example, an IC chip, a barcode, etc.) that gives information indicating the contents to a cardboard box for shipping into which a personal computer is placed, for example. Therefore, the content can be confirmed by reading the information from the information attaching unit by the information reading unit. Therefore, for example, it is useful for confirming the shipping status.

  According to the information processing apparatus management system of the ninth aspect of the present invention, various information is attached to the instruction sheet and the information processing apparatus by the barcode, so that the system can be constructed and operated at low cost. .

  According to the information processing apparatus management system of the tenth aspect of the present invention, for example, a rule such as “when a new employee's personnel information (including assigned location information) is obtained, an expansion request is generated” is defined. This makes it possible to automatically generate an expansion request or the like from personnel information, which is very useful as an information processing apparatus management system in a company or the like. In other words, with the addition, relocation, withdrawal, etc. (that is related to personnel information), the expansion, relocation, and collection of personal computers may also occur. The efficiency of the operation of the internal system as a whole is improved, and the occurrence of problems due to incomplete communication between departments is also suppressed.

  According to the information processing apparatus management system of the eleventh aspect of the present invention, the record registered in the database is the row identification information, the column identification information, and the data regardless of the logical table structure. The structure has three field values. In other words, even if the logical table structure is modified, the actual data structure in the database can be left as “structure with three field values”. Even when the structure changes, it is possible to easily apply logical table structure changes without requiring major system modifications such as redefinition of the database structure. Excellent in convenience and convenience.

  According to the information processing apparatus management system of the thirteenth aspect of the present invention, since there is no data (blank), no record is stored in the database, so that the use efficiency of the storage area of the database is improved.

  Hereinafter, specific embodiments of the present invention will be described with reference to the drawings. The following embodiment is one form when the present invention is embodied, and is not intended to limit the present invention within the scope thereof.

  FIG. 1 is a block diagram for explaining the outline of the operation of the information processing apparatus management system of this embodiment, and FIG. 2 is a block diagram showing the outline of the configuration of the information processing apparatus management system.

  In the information processing apparatus management system of this embodiment, a maintenance service company receives a request from a company (user 2) that is a customer, and the information processing apparatus that the company has (using a personal computer as a typical example here) This is a system used in the case of maintaining and managing the system described below. That is, in addition to the maintenance service for the PC (operating state PC 203) operating in the in-company system possessed by the user 2, the management is performed for the PC (storage state PC 110) that is not operating. In response to requests from customers (collection requests, expansion requests, etc.), departments that requested requests after removing unnecessary PCs (operation to collect and store) and making necessary settings for stored PCs The business that installs in the.

  As shown in FIGS. 1 and 2, the management center 1 operated by the maintenance service company includes a management server 101, a terminal setting device 102, and a host server 201 provided in the in-company system of the user 2. A linkage server 103 that generates information that can be input to the management server 101 based on the information; a printer 104; a PC 107 that is a client; a rule DB 105 that is a rule storage unit that stores rules to be processed for various requests; A management data DB 106 in which device information related to the PC of the user 2 to be managed is stored;

  The rule stored in the rule DB 105 is what kind of processing (mainly electronic processing) should be performed according to the contents of the request when various requests (requests) are made. And what kind of information is necessary for the processing, the rules for its generation, the contents of work required for various requests (requests) (mainly human work) Rules that define procedures, rules for printing forms required for the work, rules for converting data from the outside (user 2's host server 201) into data that can be handled by the management server 101, etc. The individual rules corresponding to the agreement with the user 2 are registered in advance.

  The device information stored in the management data DB 106 is information relating to the PC of the user 2 who is the object of maintenance management. A PC identification code for identifying each PC is assigned to each PC, and the PC identification code Various types of information related to the PC (for example, manufacturer, model number, serial number, MAC address of the network card provided in the PC, hardware configuration information, information about the user when in the operating state, etc.) are stored. Status information indicating whether each PC is in an operating state (a state used by the user 2) or a storage state (a state stored in the management center 1) is stored in association with each other (see FIG. That is, it functions as an “information processing apparatus management table”). The management data DB 106 stores information necessary for each process performed on the PC. “Information necessary for each process performed on the PC” is, for example, various information necessary for initial setting (various parameters, parameters necessary for various settings from hardware level to software level, etc.), Various programs to be installed (including OS etc.), network information of the user 2 (for example, various information according to the domain name and the system configuration of the user 2, and a PC is connected to the network in the user 2 Information necessary for use), programs and data for various updates (such as patch application), and programs for initializing (whitening) a PC.

  In the maintenance service company having the management system having the above-described configuration, for example, upon receiving a request for adding a PC from the user 2, a setting required for the PC 110 in the storage state (an initial stage for enabling use of the PC at the requested installation location) After setting (setting), the PC is shipped (delivered), or upon receipt of a collection request, the collected (delivery) PC is whitened (initialized for the next use) and stored It is something to keep in. Requests for expansion and collection are made by the information device manager 6 to the device management center 1 when the user contacts the information device manager 6 (see FIG. 1) (telephone, e-mail, etc.) ( In response to a request from the information device manager 6 by telephone or e-mail, the operator of the device management center 1 inputs to the management system using the terminal 107, or the information device manager 6 via an interface such as a browser It may be input directly to the management system), or when a malfunction occurs in the operating PC and the user 2 makes an inquiry to the help desk 4, the help desk 4 determines that the PC needs repair. If the request is issued to the device management center 1 (for example, an installation request for an alternative machine being repaired) or the personnel change information in the user 2 is stored in the host server 201. By coming to the device management center 1, generated, such as by automatically request in device management center within 1 is generated based on the personnel changes information.

  FIG. 3 is a flowchart mainly showing the processing operation related to the present invention of the information processing apparatus management system, showing the processing operation when the personnel change information is received from the host server 201 of the user 2. It is. Note that “when the personnel change information is received from the host server 201” may be one in which the host server 201 actively transmits information, or in response to a request from the device management center 1 side. 201 may transmit (passively).

  When personnel change information is input in the user 2 system (step 301), the personnel change information is transmitted from the host server 201 to the device management center 1 (cooperation server 103) (step 302). The cooperation server 103 that has received the personnel change information refers to the rule DB 105 and performs a process of unifying the data format (absorbing the data format difference based on the system difference) and based on the rule from the personnel change information. A request (addition, collection, transfer, update request) is generated (step 303). Personnel transfer information is, for example, user name, department information, post information, work location information, enrollment (status) information, etc., and what requests are generated (or not) based on the information in the rules ) Is defined. That is, for example, "When there is personnel transfer information that a new employee has entered, a request to add a PC to the new employee's work location is generated (definition such as passing information such as a user name as an argument, etc. ) ”, Relocation requests are generated in the case of relocation, collection requests are generated in the case of retirement, and PCs are not added to specific departments even if it is new employee information. A rule corresponding to a request based on the actual state of business operation by the user 2 is registered in the rule DB 105 by the designer in advance, for example, when the promotion is performed, the PC needs to be updated (generate an update request).

  In the present embodiment, the cooperation server 103 converts the personnel change information received from the user 2 into the request information to be input to the management server 101, so that the difference in the data format depending on the user 2 is obtained. 103 is absorbed (the design of the management server 101 is separated from the influence from the user 2), but the device management center 1 is a system that operates within the user 2, for example. In some cases, the cooperation server 103 may not be particularly necessary, and the personnel change information may be directly input to the management server 101 so that the data format conversion is performed by the management server 101 ( The function of the cooperation server 103 may be provided in the management server 101).

  The request generated by the cooperation server 103 is input to the management server 101 (step 304). In FIG. 1, although described as a flow through the terminal 107, it does not mean that manual input is required, but in a format in accordance with the input interface to the management server 101 used on the terminal 107, Data is sent from 103 and a request is automatically registered in the management server 101.

  In the subsequent step 305, the management server 101 determines whether the request content is “addition request”, “collection request”, “transfer request” or “update request”.

  If it is an expansion request, an expansion request execution process (details will be described later) is executed in step 306 to perform initial setting for the PC 110 in the storage state, and delivery of the PC for which the setting has been completed to the delivery company 3 The request is delivered to the user 2 (step 307).

  If the result of the determination in step 305 is a collection request, the collection request is executed after the collection of the PC (incoming delivery from the user 2 to the device management center 1 by the delivery company 3) (step 308). Processing (details will be described later) is executed (step 309), and the initialized PC is stored (step 310).

  If the result of determination in step 305 is a relocation request or an update request, there is a collection of PCs (entry by delivery from the user 2 to the device management center 1 by the delivery company 3) (step 311). Relocation / update request execution processing (details will be described later) is executed (step 312), and delivery to the user 2 is requested by requesting the delivery company 3 to deliver the PC for which update processing and the like have been set (step 313). .

  As described above, as a whole processing flow, when there is a personnel change in the user 2, a “PC expansion request” or the like is automatically generated based on the personnel change information, and the PC Various settings and PC delivery (PC entry / exit management) and the like are performed.

  4 to 6 are flowcharts showing the outline of “addition request execution processing” in step 306, “collection request execution processing” in step 309, and “transfer / update request execution processing” in step 312 in FIG. . Hereinafter, each process will be described with reference to the drawings.

  In the “addition request execution process” shown in FIG. 4, the management server 101 that has received the extension request (step 401) refers to the rule DB 105 and sets setting information and a processing command ( The setting information and processing instructions necessary for various settings (for initial setting) for making the PC usable at the location where the expansion request is made are generated with reference to the management data DB 106 as necessary ( Step 402).

  Further, in step 403, a process for causing the printer 104 to print various forms such as a work instruction sheet (for example, a shipping work instruction sheet or a shipping slip) based on the rule corresponding to the received expansion request is performed.

  In the next step 404, it is determined whether or not the storage state PC 110 is connected to the terminal setting device 102. If there is, the process proceeds to step 405, and the step is performed for the connected PC. By using the setting information generated in 402 and executing a processing instruction, initial setting for the PC is automatically performed. For example, an IP address setting will be described as a specific example of the contents of the initial setting. The rule of the rule DB 105 includes an IP address assignment method according to the system configuration of the user 2 (for example, the address aaa-dddd for the branch A). And the management data DB 106 stores the value of the IP address and the assignment status of the IP address, and is included in the request for expansion. A range of IP address values that can be set based on the rules is generated from the PC installation location information, and an IP address value that is empty (not used) in the IP address range is determined with reference to the management data DB 106 -Obtain and set the obtained IP address value in the storage state PC 110 (PC to be issued) It is intended. The connection between the PC 110 and the terminal setting device 102 is performed by assigning an IP address to the PC 110 by the dynamic address assignment method, and after the necessary information is transmitted to the PC 110, the setting process in the PC 110 is executed. Later (that is, after the IP address is set to the IP address used by the user 2), communication between the PC 110 and the terminal setting device 102 cannot be performed.

  After the setting process in step 405 is completed, shipping confirmation / warning processes in steps 406 to 408 are performed. This process waits for input of shipping confirmation information by the operator. The operator uses the shipping slip printed in accordance with the instruction printed in step 403, for example, to perform the shipping work of the PC for which setting has been completed (remove the PC 110 from the terminal setting device 102 and paste the packing or shipping slip) When the shipping operation is completed, the terminal 107 is used to input that the shipment has been completed. In the management server 101, when the shipment confirmation information is obtained, the process proceeds to step 409. On the other hand, when the shipment confirmation is not obtained even after a predetermined period of time elapses after the process of step 405 is finished ( Step 407), warning processing (for example, processing for displaying a warning screen on the terminal 107) is performed (step 408).

  When the shipment is confirmed (step 406), the status information of the corresponding PC (which PC is determined from the MAC address recognized at the time of connection in step 404) in the management data DB 106 is displayed. Update (step 409) and the process ends. The update of status information is, for example, updating user information, PC installation location information, assigned IP address, and the like in addition to updating from “storage state” to “operating state”.

  In the “collection request execution process” shown in FIG. 5, the management server 101 that has received the collection request (step 501) refers to the rule DB 105 and sets setting information and processing instructions ( A process for whitening the PC requested to be collected is generated with reference to the management data DB as necessary (step 502).

  In step 503, based on the rule corresponding to the received collection request, various processes such as a work instruction sheet (for example, an instruction sheet for working to pack and collect by visiting the user 2) are printed on the printer 104.

  Subsequent steps 504 to 506 are arrival confirmation / warning processing, which is the same concept as the shipping confirmation / warning processing of 406 to 408 in FIG.

  In the following step 507, it is determined whether or not the collected PC (PC in operation) is connected to the terminal setting device 102. If there is, the process proceeds to step 508, and By executing the processing instruction generated in step 502 for the connected PC, the PC is automatically whitened (initialized).

  Subsequent steps 509 to 511 are storage confirmation / warning processes, which are the same as the shipping confirmation / warning processes in steps 406 to 408 of FIG. 4 except that there is a difference between shipment and storage (PC storage in the storage location). Concept.

  When it is confirmed that a PC (a PC that has been recovered and has been initialized for the next use) has been stored in the storage location (step 509), the corresponding data in the management data DB 106 is stored. The PC status information is updated (step 512), and the process is terminated. The update of status information includes, for example, deletion of user information, PC installation location information, etc., and release of an assigned IP address, in addition to updating from “operating state” to “storage state”. The process of updating the PC status information related to “deleting user information, PC installation location information, etc., releasing the assigned IP address, etc.” is performed by executing whitening (initialization) (step 508). It may be performed at the time.

  In the “relocation / update request execution process” shown in FIG. 6, the management server 101 that has received the relocation / update request (step 601) refers to the rule DB 105 based on the rule corresponding to the received relocation / update request. Setting information and processing instructions (update processing for relocation / update requests) are generated with reference to the management data DB as necessary (step 602).

  In step 603, various forms such as work instructions based on the rules corresponding to the received relocation / update request (for example, work instructions for packing and collecting by visiting the user 2, instructions for shipping work, shipping slips, etc.) Etc.) is printed on the printer 104.

  The subsequent arrival confirmation process in step 604 is the same process as in steps 504 to 506 in FIG. 5, and step 605 is also the same process as in step 507 in FIG.

  In step 606, the processing instruction generated in step 602 is executed on the PC connected to the terminal setting device 102 (the PC once collected from the user 2) to automatically update the PC. Process.

  The subsequent shipment confirmation processing in step 607 is the same processing as in steps 406 to 408 in FIG. 4. When shipment is confirmed, the status information of the corresponding PC in the management data DB 106 is updated (step 608). ) End the process. The status information update is, for example, updating user information, PC installation location information, information such as an assigned IP address.

  The relocation request mentioned here basically means a case where the same hardware is relocated. In other words, the PC 203 in the operating state is temporarily collected in the user 2 and subjected to update processing or the like (IP address change or the like) as necessary, but the same updated PC 203 is shipped again. On the other hand, when hardware replacement occurs, it corresponds as a combination of a collection request and an expansion request (that is, a collection process (the process of FIG. 5) and an expansion process (the process of FIG. 4) are executed). ). Accordingly, the expansion process and the recovery process can be performed in parallel, and in some cases, the expansion can be completed prior to the recovery. These usages are also defined by rules.

  As described above, according to the information processing apparatus management system of the present embodiment, the request such as the expansion request is managed by providing the rule accumulation unit storing the rules to be processed for the request (for example, the expansion request). “Setting information or processing instruction to be set for the information processing device (PC)” is automatically generated with reference to the rule when input to the server, and information processing is automatically performed by the terminal setting device. Since the setting process for the device is performed, the work efficiency is higher than when the setting process is performed manually, and it is possible to prevent problems caused by input errors and reduce the risk of information leakage. Value, etc., so that the worker can not recognize it). Further, the work level is made uniform by automating the work, and the operator's skill is not required. Therefore, the operation cost can be reduced.

  In addition, for example, by establishing a rule such as “Generate an expansion request when new employee personnel information (including location information) is obtained”, an expansion request is automatically generated from the personnel information. Since it is generated, it is very useful as an information processing apparatus management system for companies and the like. That is, since the addition, relocation, collection, etc. of the personal computer occur with joining, transferring, leaving, etc., the personnel management server (in this embodiment, the host server 201 in the user 2 functions as a personnel management server). Automatically improves the efficiency of the operation of the entire system and prevents the occurrence of problems due to inadequate communication between departments and inadequate contact with maintenance service companies. Is done.

  Further, since the “rule DB 105” is provided so as to be independent from the management server 105, various users (information processing of this embodiment) can be obtained by appropriately changing and updating the rules stored in the rule DB 105. It is easy to change various types of definitions according to the customer (from the viewpoint of a maintenance service company having a device management system) and to change and add definitions of various processing operations, etc. Excellent.

  As is apparent from the above description of the processing operation, the terminal setting device 102 in this embodiment may actually be a simple connection port (connection port of the management server 101), and the terminal setting device 102 is not necessarily hardware. (The management server may have a function of a terminal setting device).

  In the description of the present embodiment, the operation when the personnel change information is received from the host server 201 of the user 2 (when the request is automatically generated from the personnel change information) is mainly described. The processing operation itself performed based on the request is the same concept even when the request is input using.

  In this embodiment, the maintenance service company has been described as managing a customer's company's PC. However, a system provided for managing one company's own PC may be used. In this case, various settings and update processes may be performed at the installation location of the PC. That is, instead of connecting to the terminal setting device 102 and performing setting processing, various processing may be performed while connected to the corporate network at the PC installation location.

  FIG. 7 is a block diagram for explaining the outline of the operation of the information processing apparatus management system of this embodiment, and FIG. 8 is a block diagram showing the outline of the configuration of the information processing apparatus management system. In addition, the same code | symbol is used about the component similar to Example 1 (FIGS. 1 and 2).

  As in the first embodiment, the information processing apparatus management system according to the present embodiment is used when a maintenance service company receives a request from a customer company (user 2) to maintain and manage a PC of the company. In this embodiment, there are a plurality of storage locations (storage centers 11) for storing PCs, and the management center 1 and the storage center 11 are connected by a private network (this makes it possible to physically The storage center 11 is provided at a location different from the management center 1, but the logical configuration is basically the same as that of the first embodiment except that there are a plurality of storage centers). Each storage center is provided with a terminal setting device 112 and a printer 111, and the terminal setting device 112 is provided with a bar code reader 113. Information on the devices (printers, terminal setting devices, etc.) provided in each of these storage centers is also stored in the management data DB (by storing the identification code of each device and the base code in association with each other). It is possible to determine which device is in which location, and information necessary for communication such as an IP address is also stored, that is, it has a function as a “terminal setting device management table”. ). Further, as a precondition for the operation of the information processing apparatus management system according to the present embodiment, each maintenance / management target PC (user 2's PC) is provided with a barcode corresponding to the PC identification code. FIG. 26 shows an example thereof (a sticker on which a barcode corresponding to the PC identification code is printed).

  9 to 13 show an example of a table for defining rules stored in the rule DB 105. FIG.

  FIG. 9 shows an example of a table that defines a rule for creating a setting value to be set in a PC to be processed (a PC that performs processing when there is an expansion request). Rules are determined for each type. In the rule, other rules may be referred to. This is to improve the efficiency of system operation and maintenance by modularizing common rules (basic rules).

  FIG. 10A shows an example of a table that defines a base (a base according to the system of the user 2, for example, a branch that the user 2 has) and network rules for each business use type. . FIG. 2B is an explanatory diagram showing the relationship between the network segment and the base, and explains that the logical network segment and the physical base are not necessarily the same (logical network). (The base number in the network segment is kept in the information of each base so that the segment can be used physically at multiple bases).

  FIG. 11 shows an example of a table for defining a data conversion rule, and the diagram on the right side of each table explains an example of conversion. Here, an example of replacement of field data and replacement with a fixed value is taken as an example, and an example of a rule for correcting a difference in data structure between systems is shown. FIG. 11A shows an example of a table that defines a rule for “data format unification processing” in the cooperation server 103. That is, a rule for converting data input from the host server 201 of the user 2 into data that can be registered in the management server 101 (information that can be registered as a request) is defined. FIG. 11B defines rules for registering a CSV file in the management server 101.

  FIG. 12 shows an example of a table that defines rules for work order, and FIG. 14 is a flowchart showing the order of work defined by the table. Note that the flowchart shows the context of the entire work, and does not mean that all these work will occur when a certain request is made. For example, when an expansion request is made, work such as “warehousing” and “operation check” does not occur.

  FIG. 13 shows an example of a table for defining data input rules.

  FIG. 15 is a diagram for explaining the structure of each table in FIGS. 9 to 13 and 16 to 18. Each table in FIGS. 9 to 13 and 16 to 18 stores basic data. Basic data, and has a structure having detailed data associated with each basic data (by associating various identification codes and identification names associated with the basic data with detailed data, Detailed data is associated with each basic data). As described in paragraphs 0156 to 0157, the processing speed of the system can be increased. In addition, by adopting such a structure, it is possible to design the information processing apparatus management system to operate based on each basic data, such as a specific set value for each individual case. There is no need to worry about the difference. In other words, the basic design of the system is to operate based on each basic data, and it is possible to refer to and acquire detailed data associated with each basic data as required (customer Therefore, it is possible to define a specific setting value based on the difference in the detailed data), so that extremely excellent flexibility can be obtained in the construction, operation, and maintenance of the system in accordance with various specific requirements. This point is particularly useful when the system manages not only hardware but also software as in this system (the hardware configuration is relatively different from each customer's work, etc.). However, there are many cases where the software configuration varies greatly depending on the difference in business).

  16 to 18 show examples of tables stored in the management data DB 106. FIG.

  FIG. 16 shows an example of a table in which the base data is stored. “Base code” corresponds to the identification code associated with the basic data, and FIG. FIG. 5B is a table in which detailed data regarding the base is stored.

  FIG. 17 shows an example of a table for storing individual setting values created based on a rule, and “setting value number” corresponds to an identification code associated with basic data. FIG. 18 shows an example of a table for storing information of an information processing apparatus (PC) to be managed, and “device management number” corresponds to an identification code associated with basic data. As in the above, FIG. (A) is basic data and FIG. (B) is detailed data.

  Hereinafter, as in the first embodiment, the processing operation when the personnel change information is received from the host server 201 of the user 2 will be mainly described. The basic part of the processing operation related to the present invention of the information processing apparatus management system of the present embodiment is the same as that of the first embodiment (FIG. 3), and the management center 1 receives personnel change information from the host server 201, The cooperation server 103 converts the data format and generates a request (step 303), and the request is input to the management server 101 (step 304). Then, the management server 101 discriminates the contents of the request (step 305) and executes processing corresponding to each (step 306 to step 313).

  FIG. 19 shows an outline of “addition request execution processing” executed by the management server 101 of the information processing apparatus management system of this embodiment.

  When the expansion request is received (step 1901), the rule DB 105 is referred to, and setting information and a processing instruction (a PC can be used at the location where the expansion request is made) based on the rule corresponding to the received expansion request. For this purpose, setting information and processing instructions necessary for various settings (for initial setting) are generated with reference to the management data DB as necessary. Further, an instruction code corresponding to the generated processing instruction (instruction code corresponding to the work content) is generated, and the storage center 11 in charge is determined (step 1902). In the case of an expansion request, the “storage center in charge” is closest (distance or time) to the installation location (such as the branch 21 of the user 2 and the information is included in the information of the expansion request). The storage center 11 is determined with reference to information (such as base information) in each table based on the rules. The “instruction code corresponding to the processing instruction (instruction code corresponding to the work content)” is, for example, an instruction code corresponding to “execution of initial setting processing performed on the extension PC” or “shipment work”. Is an instruction code corresponding to.

  In the subsequent step 1903, various forms such as work instructions (for example, shipping work instructions, shipping slips, etc.) based on the rules corresponding to the received enlargement request, and the instruction codes generated in step 1902 (respectively, (Instruction code corresponding to the form) is printed on the printer 111 provided in the storage center 11 determined in step 1902 (refer to the management data DB 106). As a result, the printer 111 provided in the storage center 11 determined in step 1902 is specified, and necessary information is obtained, and a print command is transmitted). The “instruction code corresponding to each form” is, for example, an instruction code corresponding to “shipping work” attached to a shipping slip. A bar code (bar code having information indicating the contents) to be attached to the shipping packaging box is also printed. In this embodiment, the information that the barcode actually attached to the packaging box has is information (identification information) that uniquely defines the packaging box, and specific information indicating the identification information and contents Are stored in the management data DB in association with each other (created in the processing in step 1902), and by reading the barcode of the packing box, specific information indicating the corresponding contents is acquired. (This can be said to be a pseudo “barcode with information indicating the contents”).

  Through the above processing, various work instructions with barcodes are determined based on the storage center 11 (rules) closest to the installation site (user 2), and the rules are determined based on the operation policy. The printer 111 is not necessarily required to be “nearest”, and is printed from the printer 111. As a result, the storage center 11 performs work based on the printed work instruction sheet and the like.

  FIG. 21 shows an example of a work instruction sheet (setting sheet) printed in the extension request execution process, FIG. 22 shows an example of a shipping slip, FIG. 23 shows an example of a barcode pasted on a shipping packaging box, Shown respectively. Note that the value such as “IP address” in FIG. 21 is blank, but if there is actually setting information generated in step 1902, it is printed here.

  Work based on work instructions etc. is a work that must be done manually (for example, shipping work) is naturally manual, but a bar code printed for each work (for example, in work instructions) The operation instruction is written in the text and the barcode is printed next to it), and the system can determine which work stage the system is reading . Furthermore, in the information processing apparatus management system according to the present embodiment, setting information and processing instructions to be set in the PC are generated, and an instruction code corresponding to the setting information is generated and printed as a barcode. In addition, the setting process for the PC is automatically executed by using the reading of the identification code of the extension PC) as a trigger.

  When the barcode having the instruction code information and the barcode having the PC identification code information are read by the barcode reader 113, the barcode is transmitted to the management server 101 by the terminal setting device 112 having the barcode reader 113. The When the management server 101 receives the information (step 1904), a process corresponding to the instruction code is executed for the PC corresponding to the PC identification code (step 1906). For example, when the instruction code indicates “PC initial setting process”, information on the PC to be processed is acquired from the management data DB 106 based on the PC identification code (for example, acquisition of a MAC address). In other words, a process for automatically executing the initial setting is performed on the PC connected to the terminal setting device 112. If it is determined that the PC specified based on the PC identification code is not connected to the terminal setting device 112, a process for displaying a warning on the terminal setting device 112 is performed. Also good.

  When the instruction code indicates shipping confirmation (for example, when the barcode printed on the shipping slip and the barcode attached to the packing box are read) (step 1905), the management data DB 106 Then, the status information of the corresponding PC is updated (step 1907), and the process is terminated. The update of status information is, for example, updating user information, PC installation location information, assigned IP address, and the like in addition to updating from “storage state” to “operating state”.

  FIG. 20 shows an outline of “collection request execution processing” executed by the management server 101 of the information processing apparatus management system of this embodiment.

  The basic processing concept is the same as the “addition request execution processing” in FIG. 19, and the storage center 11 in charge is determined from the collection request based on the rules, and various processing instructions and instruction codes are generated to generate the barcode. A form with “” is printed (steps 2001 to 2003).

  FIG. 24 and FIG. 25 show examples of work instructions printed in the collection request execution process.

  When information based on the barcode is received from the terminal setting device 112, processing corresponding to the instruction code (such as whitening processing) is executed on the PC corresponding to the PC identification code, and the instruction code confirms storage. If it is the one shown (for example, when the barcode printed on the storage instruction is read), the status information of the corresponding PC in the management data DB 106 is updated (from “operation state” to “storage state”). Update) to end the processing (step 2004 to step 2007).

  The “transfer / update request execution process” is the same processing concept as in FIG. 19, and the storage center 11 in charge is determined from the transfer / update request based on the rules, and various processing instructions and instruction codes are generated. Print a form with a code. When the information based on the barcode is received from the terminal setting device 112, the process corresponding to the instruction code (various update processes, etc.) is executed on the PC corresponding to the identification code of the PC. If it indicates shipping confirmation (for example, when a barcode printed on a shipping slip is read), the status information of the corresponding PC in the management data DB 106 is updated, and the process ends.

  For example, when the personnel transfer information is transfer information and the storage center 11 nearest to the transfer source and the transfer destination is different, “recovery request” and “addition request” are not used instead of “relocation request”. Is generated, and a form printing process or the like is performed for each storage center 11. That is, by generating a “collection request” for the storage center 11 nearest to the transfer source and performing the collection process, and generating an “addition request” for the nearest storage center 11 of the transfer destination and performing the expansion process. The PC will be relocated in line with the transfer. Such rules for generating various requests based on personnel change information are also appropriately defined in rules according to the business system of each user 2.

  As described above, according to the information processing apparatus management system of this embodiment, each process can be performed by a simple operation of reading the barcode attached to the work instruction and the barcode attached to the PC by the barcode reader. Since the process is associated with the PC to be processed and the setting process for the PC is automatically performed, the operation is simple and mistakes can be prevented. In addition, even when there are storage centers in various locations by setting rules, PC entry / exit management is automatically performed based on personnel information, etc., taking into account geographical factors, so system operation・ Management efficiency will be improved.

  In addition, according to the information processing apparatus management system of this embodiment, status information indicating whether each PC is in an operating state or a storage state is held, and thus the information is stored in a system in which the PC operates (in this embodiment, the user 2 It is also possible to perform operations such as permitting connection to the network only for PCs whose status is in the operating state (naturally managed PCs) in the system. As a result, security in the “system on which the PC operates” can be enhanced.

  In the present embodiment, the bar code is used as the means for giving the information of the instruction code and the identification code, but other “information attaching means capable of reading information by optical or electromagnetic methods” (for example, RFID or IC chip). That is, by providing the storage center with an output device capable of outputting these information attachment means, the information attachment means may be attached to each form ("output device" is provided with the information attachment means). It is different in the case of having a function of directly outputting each form, but is usually attached by an apparatus for attaching the information attachment means to each form or manually). However, at present, the use of a barcode as in this embodiment makes it possible to configure the system at a low cost, and the barcode is a widely recognized technology and can be easily viewed. It is possible and preferable for the operator to perform the work without any problem.

  Further, in this embodiment, the management server is provided in the management center, and the configuration in which only the terminal setting device is arranged in each storage center has been described as an example. What is provided in the center may be used.

  Next, as a third embodiment, the point in the present invention “specifically defining rules and how various requests are generated and processes based on various requests are processed based on the rules” is more specifically described. explain. In the system according to the present invention, when rules and various data are stored in the DB, the logical table structure is converted into a record structure having three field values of row identification information, column identification information, and data. This point will be explained. The system configuration itself is basically the same as that of the first or second embodiment. In the following description, the drawings used for the description of the first and second embodiments are used as necessary. Give an explanation.

  FIG. 27 is a flowchart showing an outline of the processing operation of the “site addition request execution process”. FIG. 28 is a diagram for explaining an outline of the data flow (reference destination of necessary information) in the process.

  As described in the second embodiment, the “site” is a branch 21 of the user 2 (see FIG. 8), and is determined according to the organization form of the user 2 or the like. The “base addition request execution process” in FIG. 27 is a case where, when the user 2 newly adds a base, the base is managed in order to manage the PC and the like installed at the base by the information processing apparatus management system. This is a process for registering in the system as a target.

  The “base addition request execution process” is executed when a “base addition request” is generated. “Location addition application” is an application for adding a location. For example, the location addition application data created by the information device manager 6 (see FIG. 7) is input to the management server 101. Is called. The base addition application data includes various information stored in the “base data storage table (FIG. 16)” such as the base name, location, telephone number, and network segment. However, the site number is not included in the site addition application data as will be described later, and is automatically assigned by the system.

  The management server 101 that has received the site addition application data determines the site number by referring to the network segment information included in the site addition application data and the site data storage table (FIG. 27: step 2701). The base No. is determined by referring to the detailed data (FIG. 16B) of the base data storage table to determine whether or not there is the same network segment as the base addition application data. If “1” is assigned as the base number and there are identical ones, serial numbers are assigned (for example, if four base numbers are already assigned to three in the same network segment, 4 is assigned). ). As a result, a plurality of bases may exist in the same network segment, and this point is as described with reference to FIG.

  In the subsequent step 2702, a base code is further generated, and various information included in the base addition application data is associated with the base code / base No. and stored in the base data storage table. Since the site number is information indicating the number of the site in each network segment, it is duplicated information in different network segments, but the site code is uniquely assigned to each site, and duplication is allowed. Not. The base code may be generated automatically by a serial number or the like, or may be included in the base addition application data (determined by a person).

  In the subsequent step 2703, the set value rule table (FIG. 9) is referred to, and the network rule table (FIG. 10) is referred to based on the site number determined in step 2701, and the maximum number of devices that can be installed in the site is determined. A set value number is generated for all, and a process for generating a set value corresponding to each set value number (information such as an IP address set for each device installed in the base to be added) is performed. The “set value number” is a key item in the individual set value storage table (FIG. 17), and is uniquely determined for a set of set values set for each device. Here, the “maximum number of devices that can be installed at a site” is determined based on the number of IP addresses assigned to each site No. defined by the network rule table (the maximum number of devices is determined under other conditions). It may be determined). That is, when the site number is 1, according to FIG. 10, since the third octet of the IP address is 100 and the fourth octet is 1 to 100 for the device for business use type, the business of the base A maximum of 100 devices can be installed (the maximum number of devices in the base is the sum of the maximum number of each business use type). Setting values are generated for all of the maximum numbers, and the “setting value number” is the identification number.

  As described above, the setting value rule table is a table that defines a rule for creating a setting value to be set in a PC to be processed, and includes items of a table (rule) to be referred to in order to generate various setting values, A value to be a set value is directly set (fixed value) (for example, the IP address is defined to be determined based on the base data and the network rule table as described above). As described above, in the process of step 2703, various setting values (individual setting value storage table (FIG. 17) are stored based on the setting value rule table (FIG. 9), the site number, the network rule table (FIG. 10), and the like. Value) is automatically generated. Note that not all “setting values to be set in the PC” are automatically generated here (of course, if all can be automatically generated). For example, when there is a setting item that can be understood only at the time of an expansion request, there is also a setting value that is generated based on information included in the expansion request (this is step 402 of the expansion request process (FIG. 4)). As described in the above process).

  In step 2704, the individual setting value storage table (FIG. 17) is updated with the various setting values generated above. In this case, by storing the base codes in association with each other, the base data storage table (FIG. 16) and the individual set value storage table (FIG. 17) are linked.

  With the above “base addition request execution process”, each setting value is set for all of the maximum number of devices that can be installed at newly added locations (in this embodiment, “devices that can be connected to the network”). Is generated and stored in the individual set value storage table (FIG. 17). In other words, by preparing in advance the setting values required when there is an “addition request” for installing a device at the base (as described above, it is not always possible to prepare all necessary information in advance. No), it is possible to quickly execute processes according to various requests. In the state where the setting value is just generated (the actual device has not yet been assigned), the “device management code” column in the individual setting value storage table is blank, and the “status” column Also, information such as blank or “unassigned” is stored.

  As is clear from the above description, “site addition application” is also a kind of request made to this system, and it is a rule to be processed for the request, such as a network rule table or a set value rule table. Based on this, setting values to be set in the devices (information processing apparatuses) installed at the respective bases are generated in advance, and stored and held in an individual setting value storage table (function as an information processing apparatus management table). As shown in FIG. 28, for the requested site addition application, site information change application, site abolition application, etc., the information in the site data storage table is referred to based on the network rules and setting value rules that are rules. The individual set value is generated, and the generated information is stored in the individual set value storage table. The “site information change application” is for changing the information of an existing base, but the basic operation is the same as the base addition application described above. In addition, “location cancellation application” identifies the target location number from the location data storage table based on the information in the application data, and uses the location number as a key for each information in the location data storage table and the individual set value storage table. Is to be deleted.

  Next, a data linkage processing operation in the linkage server 103 that has received personnel change information from the host server 201 (FIG. 1) will be described. FIG. 29 is a flowchart showing an outline of the processing operation. This processing corresponds to the processing in step 303 in FIG.

  The cooperation server 103 that has received “cooperation data” (personnel change information) from the host server 201 performs processing for converting the received cooperation data based on the data conversion rule table (step 2901).

  FIG. 30 shows “cooperation data” (personnel change information) input from the host server 201, while FIG. 31 shows a case where a request (addition request, etc.) is registered with the management server 101 using the terminal 107. Application format. The processing in step 2901 is to generate the data in FIG. 33 (data that conforms to the application format in FIG. 31) by converting the linkage data in FIG. 30 based on the data conversion rule table in FIG. In other words, data suitable for the application format is generated from the linkage data by exchanging the position of each data. In this example, there is an item “application type” in the linkage data, and the type of request (addition, etc.) is defined in the item, and therefore the “information processing apparatus management system” that receives this is received. The type of request to be generated can be determined immediately, but only information that defines the type of personnel change, such as “transfer” or “joined”, is defined as information on personnel changes as linkage data. On the system side, by providing a defined table in which personnel change types and requests to be generated are associated with each other, it is possible to refer to the table and make a determination such as “generate“ addition request ”if“ entered ””. You may make it perform.

  In step 2902 (FIG. 29), data processing based on the rules defined in the cooperation data registration rule table (FIG. 34) is performed on the conversion data generated in step 2901. The cooperation data registration rule of FIG. 34 describes a rule for supplementing information that is not included in the cooperation data (personnel change information), and DB (management data DB 106 or the like) stores necessary information based on the rule. The data registered in the system is completed by supplementing the information of the missing part (shaded part) in FIG. With this process, data as a request is completed, and the processes after step 305 in FIG. 3 are executed based on the request.

  In step 2903 (FIG. 29), the data generated in step 2902 is registered in the management data DB 106 as an “application form table” based on the rules defined in the data registration rule table (FIG. 35).

  The request processing rule table in FIG. 36 corresponds to each request (application) referred to in step 402 in FIG. 4, step 502 in FIG. 5, step 602 in FIG. 6, step 1902 in FIG. 19, and step 2002 in FIG. Is a table in which rules are defined. For example, in response to an expansion request, first of all, whether there is a device inventory confirmation (a device whose business application type is suitable with reference to the asset information storage table (FIG. 18) and whose “installation location” is a warehouse. This is performed by determining the base No. by referring to the base data storage table (FIG. 16) and referring to the individual set value storage table based on the base No. Performs processing to determine whether there is a vacant setting value to be assigned to business use (processing to determine whether there is a blank in the “device management code” item), and assigns the setting value if there is a vacancy (individual) Register the device management code (obtained from the asset information storage table) in the setting value storage table, execute the process (such as updating the “installation location” item in the asset information storage table), and execute the setting data output process (setting to the PC). So that the process) is executed. For the assigned setting values, a process of updating the item “state” in the individual setting value storage table (FIG. 17) during operation is also performed.

  The form output rule table in FIG. 37 corresponds to each request (application) referred to in step 403 in FIG. 4, step 503 in FIG. 5, step 603 in FIG. 6, step 1903 in FIG. 19, and step 2003 in FIG. A table in which rules are defined.

  FIG. 38 and FIG. 39 are diagrams for explaining an outline of a data flow (a reference destination of necessary information, etc.) in processing when there is a request (mainly an expansion request). ) Is a diagram showing a flow when data can be specified by software, and FIG. 39 shows a flow when specifying a device using a barcode when specifying the device by data is not possible by software. FIG.

As shown in FIG.
(1) Based on the form output rule table (FIG. 37), a work instruction (shipping instruction) is generated by using the information of the individual set value storage table (FIG. 17) and the work instruction sheet is printed (FIG. 4). Equivalent to the processing of step 403),
(2)-(3) When the PC to be shipped (additional PC) is connected to the terminal setting device 102, the MAC address of the PC is acquired, and based on this, the asset information storage table (MAC of each PC) Address or the like), or by referring to the individual setting value storage table, whether the PC connected to the terminal setting device 102 is appropriate (in the device management code to which the setting value described above is assigned) It is determined whether or not the corresponding PC.
(4) If this is OK, a process of setting the corresponding setting value of the individual setting value storage table in the PC is executed (corresponding to the process of step 405 in FIG. 4). If the connected PC is not a proper PC, an error is displayed and the setting process is not performed.

  On the other hand, when the device cannot be specified by data by software (FIG. 39), the device management code of the device is read by reading the barcode attached to the device (barcode having device management code information) with a barcode reader. Based on this, the individual setting value storage table is referred to, and it is determined whether the device connected to the terminal setting device 102 is an appropriate one. Other processes are the same as those in FIG.

  Next, in the system according to the present invention, when rules and various data are stored in the DB, the logical table structure is converted into a record structure having three field values of row identification information, column identification information, and data. Will be described.

  Here, as an example, the case where the table of FIG. 17A is stored in the DB (management data DB 106) is used. The table structure shown in FIG. 17A corresponds to the “logical table structure”. In this system, this logical table structure is stored in the DB as a record having “row identification information”, “column identification information”, and “data” as field values.

  “Row identification information” is a series of data in units of rows (in the top row of FIG. 17A, “B001G001”, “B001”, “H00001”, “Active”, “Business”). The “set value number” at the left end corresponds to “row identification information”.

  “Column identification information” is attribute information (attributes common to each data) that each column has. In the example of FIG. 17A, “set value number”, “base code”, “device” “Management code”, “status”, and “business use type” are applicable. As described below, “column identification information” may be handled as a numerical value such as “2” instead of information such as “base code” by associating it with a code such as a numerical value. Similarly, “row identification information” may be converted into a numerical value or the like.

  “Data” is the data itself stored in the table. In the top row of FIG. 17A, “B001G001”, “B001”, “H00001”, “in operation”, “business” "Corresponds to the data.

  “Store in the DB as a record having“ row identification information ”,“ column identification information ”, and“ data ”as field values” means to register in the DB as a three-column data structure. Is.

  The table shown in FIG. 40 (a) is a “column structure definition file” that defines the structure of the “logical table structure” in FIG. 17 (a). The table shown in FIG. The table becomes an input data file for the system (for example, CSV file). Here, for convenience of explanation, FIG. 17A in which the number of columns at the time of illustration is appropriate is used as a specific example of the input data file. For FIG. 17A, which is a basic table for the table (FIG. 17B), “registering in the DB as a three-column data structure” is not performed.

  When FIG. 17A is input as the input data file, the management server 101 determines what is the key item that is “row identification information” based on the column structure definition file (FIG. 40A). , “Column identification information” (in this example, a column structure definition file (FIG. 1) corresponding to each data (for example, B001) of a series of data (that is, data for one row) identified by each key item (for example, B001G001)). 40 (a)) is determined from the input data file and the column structure definition file, for example, the column identification information corresponding to B001 is 1). As a result, each data and the corresponding “row identification information” and “column identification information” are acquired and stored in the DB as records having these as field values. The data structure registered in the DB is shown in FIG.

  With such a configuration, the data structure on the DB can be a (three-column) structure that always has three field values. That is, as is clear from the above description, any number of “logical table structure” fields (columns) can always have a three-column structure on an actual DB. is there. As a result, even if the “logical table structure” is changed, it is possible to prevent the DB structure on the system from being affected.

  For example, when it is desired to increase the number of items managed in the table of FIG. 17A during system operation, the table structure of FIG. In this case, since redefinition of the database is required, the influence of system modification becomes very large. However, according to the present invention, items are added to the column structure definition file (FIG. 40 (a)). It is possible to apply a change in the table structure to the system simply by incrementing it by one, preparing an input data file according to this, and inputting it into the system. For example, if one item is added in FIG. 17A and “column identification information” is added as 5, as shown in FIG. 41, the data structure on the DB does not change at all, and only the number of records increases. is there. In addition, in FIG. 41, the case where only the increased difference was added as a record was illustrated. As is clear from this, each record on the DB does not have to be stored in order according to the table structure of FIG. Even if the order of the records varies, it is possible to read necessary information from the DB by reading according to the definition of the column structure definition file (FIG. 40A). However, in terms of processing efficiency, it is possible to employ a processing method that increases the reading efficiency if the records are arranged according to a predetermined rule.

  The effect based on this invention is further demonstrated using a specific example. When managing information related to the PC, items (various information) related to the PC are held by the asset information management table as shown in FIG. For example, when managing version information of software with a PC, there is usually an item “version information” in the table, and information on the current version assigned to the PC is stored there. Become. However, with such a management method, only the latest version information can be obtained from the table. In other words, software versions may be updated many times, but their history cannot be managed. If the asset information management table structure is the same as the data structure on the DB as in the past, in order to deal with this problem, a separate table for managing the software version history is prepared, Although it is necessary to define extra items so that new items can be added to the structure of the asset information management table, both methods require expansion beyond the initial design expectations. If this occurs, there is a possibility that it cannot be easily dealt with (the expandability of the system is limited and the operability is inferior), and it is not preferable from the viewpoint of the use efficiency of the storage area.

  On the other hand, according to the present invention, it is possible to respond as an “asset information management table” regardless of how much the version update history increases. It is possible to make it possible to discriminate such things as “when was received”. In addition, even if something that was not assumed as a management item at the beginning of system design occurs afterwards, it is easy to make the item a management target, so the system is extremely scalable and easy to operate. It is. As is clear from these explanations, software or hardware settings and configuration may change frequently (and there is a request to manage their change history for reasons such as troubleshooting) This is very suitable for a management system for an information processing apparatus (PC).

  When an input data file is given and registered in the DB, when there are no data (blank) cells in the input data file, a record is not created on the DB and the data is read If the corresponding record does not exist in the DB, empty data is output so that the DB storage area can be used efficiently.

  For example, in FIG. 17A, assuming that the data (B001) corresponding to the base code in the row of B001G001 is blank, the uppermost record (B001G001, 1, B001) in FIG. 41 is not created. Thus, the use of the storage area can be reduced. When reading, a record on the DB is searched based on B001G001 which is row identification information and 1 which is column identification information. If there is no corresponding record, the empty data is output, It is possible to read out the state of the table structure of FIG.

  In this system, when various rules and various data (tables) are stored in the DB, they are stored in the format as described above, and each “column” corresponding to the various rules and various data is stored. A “structure definition file” is defined, and a table (FIG. 41) having a three-column data structure generated thereby is formed. Accordingly, each column structure definition file and each three-column structure table generated thereby are assigned identification information (table name) and managed in association with each other.

  What is stored in the DB in the format as described above is a detailed table of various rules and various data (tables) (detailed data described in FIG. 15 and paragraph 0097). About basic tables (basic data) Store in the DB as it is. The basic table is not necessarily required for system operation (it can operate only with the detailed table), but when stored in the DB in the above format, the number of records tends to be very large, so the processing speed is increased. This is provided for the purpose.

  For example, in the individual set value storage table of FIG. 17, the system can be operated only by storing the table (logical table structure) of FIG. 17B in the DB in the format described above. . However, in the above DB configuration, for example, if there are 100,000 rows and 100 columns in FIG. 17B, 10 million records are required (in fact, if there is blank data, the number of records decreases as described above. Therefore, the search takes time (of course, it depends on the processing capability of the system, and does not cause a problem when sufficient processing capability is ensured). Therefore, a basic table (FIG. 17A) in which only items frequently used in the system processing are extracted is created, and the basic operation of the system is performed by referring to the basic table (the necessary information is the basic information). By referring to the detailed table when it is not in the table), the processing speed is increased.

  The data management method in the database described above is not only applicable to the “information processing apparatus management system” according to the present invention, but can be widely applied to general database systems.

FIG. 1 is a block diagram for explaining an outline of operation of an information processing apparatus management system according to a first embodiment. 1 is a block diagram illustrating an outline of the configuration of an information processing apparatus management system according to a first embodiment. The flowchart which showed the outline | summary of the process regarding this invention of the information processing apparatus management system of Example 1. FIG. The flowchart which showed the outline | summary of operation | movement of the expansion request execution process performed with the management server of Example 1. FIG. The flowchart which showed the outline | summary of operation | movement of the collection request execution process performed with the management server of Example 1. FIG. The flowchart which showed the outline | summary of operation | movement of the transfer / update request execution process performed by the management server of Example 1. Block diagram for explaining an outline of operation of an information processing apparatus management system according to a second embodiment FIG. 2 is a block diagram showing an outline of the configuration of an information processing apparatus management system according to a second embodiment The figure which showed an example of the table which defines the rule for creating the setting value set to PC Diagram showing an example of a table that defines network rules for each base and business usage type Diagram showing an example of a table for defining data conversion rules The figure which showed an example of the table which defines the rule of the order of work Diagram showing an example of a table that defines data entry rules Flow chart showing an example of work sequence The figure explaining the structure of each table of management data DB A diagram showing an example of a table that stores site data The figure which showed an example of the table which stores the individual setting value created based on the rule The figure which showed an example of the table which stores the information of PC which is the management object The flowchart which showed the outline | summary of operation | movement of the expansion request execution process performed with the management server of Example 2. FIG. The flowchart which showed the outline | summary of operation | movement of the collection request execution process performed with the management server of Example 2. FIG. A figure showing an example of a work instruction (setting sheet) Figure showing an example of a shipping slip A figure showing an example of a shipping packaging box with a barcode with information indicating the contents Figure showing an example of work instructions (attachment check sheet) A figure showing an example of work instructions (operation check sheet) The figure which showed an example of the sticker on which the barcode corresponding to PC identification code was printed Flowchart showing the outline of the processing operation of the “site addition request execution process” Diagram explaining the outline of the data flow (such as the reference destination of necessary information) of the “site addition request execution process” Flowchart showing the outline of the processing operation of "Cooperative data conversion / registration processing" Diagram showing an example of the configuration of the linkage data Diagram showing an example of the format of the application format The figure which shows an example of a structure of a conversion rule table The figure which shows an example of the data produced | generated by converting cooperation data The figure which shows an example of a structure of a cooperation data registration rule table The figure which shows an example of a structure of a data registration rule table The figure which shows an example of a structure of an application data processing rule table The figure which shows an example of a structure of a form output rule table Diagram explaining the outline of the data flow (reference destination of necessary information, etc.) in processing when an expansion request is made Diagram explaining the outline of the data flow (reference destination of necessary information, etc.) in another process when an expansion request is made The figure which shows an example of the structure of a column structure definition file, and the structure of the data structure registered into DB The figure which shows another example of a structure of the data structure registered into DB

Explanation of symbols

1 management center 2 user (user)
11 Storage Center (Storage location)
101 Management Server 102 Terminal Setting Device 103 Cooperation Server 104 Printer 105 Rule DB (Rule Storage Unit)
106 Management data DB
110 PC (information processing device in storage state)
113 Bar code reader (information reading unit)
201 Host server (HR management server)
203 PC (information processing device in operation state)

Claims (18)

An information processing apparatus management system that manages a plurality of information processing apparatuses that can have one of an operating state used by a user and a storage state that is not in use, each of the information An information processing device management table in which an information processing device identification code for identifying a processing device is associated with status information indicating whether it is in an operating state or a storage state, a management server, and a connection from the management server are connected The request is made to the management server by including a terminal setting device that executes setting processing for the information processing device and a rule storage unit that stores rules to be processed for various requests. In this case, the management server refers to the rule storage unit and sets the information processing apparatus based on the rule from the request. Setting information or a processing command is generated and sent to the terminal setting device to automatically perform setting processing for the information processing device connected to the terminal setting device, and the information processing according to the processing. In the information processing device management system that updates the status information of the device management table ,
There are a plurality of storage locations for storing the information processing devices in the storage state, each of the storage locations is provided with the terminal setting device, and each terminal setting device identification code for identifying each terminal setting device and each storage A terminal setting device management table storing location information;
Since the information processing apparatus management table stores installation location information or storage location information of each information processing apparatus, when the request for expansion is made to the management server, the management server The setting information or processing instruction to be set for the information processing apparatus in the storage state based on the rule is generated from the expansion request by referring to the rule storage unit, and any storage location based on the rule Is connected to the terminal setting device by sending the setting information or a processing command to the terminal setting device provided at the determined storage location. In the storage state
In the case where the setting processing for the information processing apparatus is automatically performed and the corresponding status information in the information processing apparatus management table is set to the operating state, or when the requested collection request is made to the management server The management server refers to the rule storage unit, generates setting information or a processing instruction to be set for the information processing apparatus in the operating state based on the rule from the collection request, and based on the rule It is determined in which storage location the information processing device in the operating state is stored, and the setting information or processing command is sent to the terminal setting device provided in the determined storage location The terminal
A setting process is automatically performed on the information processing apparatus connected to the setting apparatus in the operating state, and the corresponding status information in the information processing apparatus management table is stored, or the requested relocation request or update When the request is made to the management server, the rule storage unit is referred to by the management server, and the setting is made for the information processing apparatus in the operating state based on the rule from the transfer request or update request. Generate setting information or a processing instruction to be performed, determine whether to store the terminal setting device in which storage location based on the rule, and determine the terminal setting device for the determined terminal setting device Setting for the information processing device in the operating state connected to the terminal setting device by sending setting information or a processing command The information processing apparatus management system and performing management automatically. By providing a printer that outputs various forms, when there is the request, the management server refers to the rule storage unit, generates work instruction information for the worker based on the rule from the request, The information processing apparatus management system according to claim 1 , wherein a work instruction sheet in which the contents of the work instruction are described is printed on the printer. An information processing apparatus management system that manages a plurality of information processing apparatuses that can have one of an operating state used by a user and a storage state that is not in use, each of the information An information processing device management table in which an information processing device identification code for identifying a processing device is associated with status information indicating whether it is in an operating state or a storage state, a management server, and a management server connected in accordance with a command from the management server A terminal setting device that executes setting processing for the information processing device, a rule storage unit that stores rules to be processed for various requests, a printer that outputs various forms, and information by optical or electromagnetic techniques. And an output device capable of outputting information attachment means capable of reading information, and reading information from the information attachment means Is added to the terminal setting device, and the information attaching unit is provided with the information of the identification code corresponding to the information processing device. If the management server refers to the rule storage unit, the management server generates setting information or a processing instruction to be set for the information processing device based on the rule from the request, and an instruction corresponding to the processing The information attachment means that generates the code and has the instruction code information is output to the output device, and the work storage information is generated from the request based on the rule by referring to the rule storage unit Then, the work instruction document in which the work instruction content is described is printed on the printer, and the operator attaches the information attachment means attached to the work instruction document to the information processing apparatus. In the management server that has received the read information transmitted from the terminal setting device by reading the information attaching unit that has been read by the information reading unit, the correspondence between each processing and the information processing device that should perform the processing By sending the setting information or processing instruction to the terminal setting device, setting processing for the information processing device connected to the terminal setting device is automatically performed, and the information according to the processing is performed. An information processing apparatus management system that updates corresponding status information in a processing apparatus management table. The request is an expansion request, and the information processing apparatus in which the setting process is performed is the information processing apparatus in the storage state, or the request is a collection request, a transfer request, or an update request, The information processing apparatus management system according to claim 3 , wherein the information processing apparatus in which the setting process is performed is the information processing apparatus in the operating state. There are a plurality of storage locations for storing the information processing devices in the storage state, each of the storage locations is provided with the terminal setting device, the printer, and the output device, respectively, and a terminal setting that identifies each terminal setting device A terminal setting device management table storing device identification codes and storage location information; and information processing device identification codes for identifying the information processing devices and installation location information or storage location information of the information processing devices. By providing a stored information processing apparatus management table, when the requested increase request is made to the management server, the management server refers to the rule storage unit and changes the request from the increase request to the rule. Based on which storage location the information processing device is used is determined, and the determined storage location is provided If the printer and the output device output information attaching means having the work instruction document and the instruction code information, or if the requested collection request is made to the management server, the management The server refers to the rule storage unit, determines from which the collection request the information processing device in the operating state is stored based on the rule, and is provided in the determined storage location. When the printer and the output device output information attachment means having information on the work instruction and the instruction code, or when the requested relocation request or update request is made to the management server The management server refers to the rule accumulating unit, and from any relocation request or update request to any storage location based on the rules. It is determined whether or not the terminal setting device is to execute a setting process, and the information attached to the printer and the output device provided in the determined storage location is provided with information on the work instruction and the instruction code. 4. The information processing apparatus management system according to claim 3, wherein said means is output. When the request is an expansion request, the information attachment means for attaching the information processing apparatus subjected to the setting process to a storage member for packing, wherein the storage member generated by the management server the information processing apparatus management system according to claim 4 or claim 5, characterized in that the information attachment means which gave the information indicating the contents, and outputs to the output device. The information attachment means is a barcode, the information reading unit is a barcode reader, and the printer prints a barcode having information on the instruction code on the work instruction by the printer. the information processing apparatus management system according to any one of claims 3 to 6, characterized in that also functions as an output device. The information processing apparatus management system is a system that manages information processing apparatuses in a specific company, and when the management server receives personnel information from a personnel management server that manages personnel data in the specific company, the management Referring to the rule storage unit by the server, the generating the request based from personnel information in the rule, of claims 3 to 7, characterized in that executing the respective processes in accordance request the generated The information processing apparatus management system according to any one of the above. A table for storing the rules or a table for associating and holding various types of information, and a logical table structure is to store a series of data in each column defining attributes common to each data. When the table for managing the series of data as rows is recorded in a database provided in the system, row identification information indicating the attributes of the series of data, column identification information indicating the common attributes, the data, the information processing apparatus management system according to any one of claims 3 to 8, characterized in that to record as a record having a field value. A definition file for defining the table structure, in which the column identification information corresponding to each column is defined, and a series of data according to the column structure defined by the column structure definition file When an input data file having a series of data associated with the line identification information is input to the system, line identification information corresponding to each data obtained from the input data file is acquired. And acquiring column identification information corresponding to the data from the column structure definition file, and recording records having the acquired row identification information, column identification information, and the data as field values in the database. The information processing apparatus management system according to claim 9, wherein: When there is no data in the series of data in the input data file, the corresponding record is not stored in the database, and when reading information from the database, wherein when the record specified by the row identifier and a column identifier does not exist, according to claim 10, wherein the outputs null data as data corresponding to the line identification information and sequence identification information Information processing device management system. An information processing apparatus management system that manages a plurality of information processing apparatuses that can have any one of an operating state used by a user and a storage state that is not used, and a management server , A terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server, a rule storage unit that stores rules to be processed for various requests, and outputs various forms And an output device capable of outputting information attachment means capable of reading information by optical or electromagnetic techniques, and an information reading unit capable of reading information from the information attachment means is provided in the terminal setting device An information processing apparatus provided with the information attachment means that includes the information of the identification code corresponding to the information processing apparatus. Setting information to be set for the information processing device based on the rule from the request with reference to the rule storage unit when the request is made to the management server in the management system or A step of generating a processing instruction, a step of generating an instruction code corresponding to the processing, a step of causing the output device to output the information attachment means having the information of the instruction code, and referring to the rule storage unit Generating work instruction information for the worker based on the rule from the request and causing the printer to print a work instruction sheet describing the work instruction content; from the terminal setting device to the information processing device; When the identification code and the instruction code are transmitted, the setting information or processing instruction corresponding to the received instruction code The information processing apparatus control program, characterized in that to execute a step of transmitting the information for setting the information processing apparatus corresponding to the identification code received in the terminal setting device. There are a plurality of storage locations for storing the information processing devices in the storage state, each of the storage locations is provided with the terminal setting device, the printer, and the output device, respectively, and a terminal setting that identifies each terminal setting device A terminal setting device management table storing device identification codes and storage location information; and information processing device identification codes for identifying the information processing devices and installation location information or storage location information of the information processing devices. By providing a stored information processing apparatus management table, when the requested expansion request is made to the management server, any storage location is referred to based on the rule from the expansion request with reference to the rule storage unit The step of determining whether to use the information processing apparatus, the printer provided in the determined storage location, and Causing the output device to output an information attachment means having information on the work instruction and the instruction code, or when the requested collection request is made to the management server A step of referring to the rule storage unit to determine in which storage location the information processing apparatus in the operating state is stored based on the rule from the collection request; and the determined storage location Causing the printer and the output device to output the information attachment means having the work instruction document and the information of the instruction code, or the transfer request or update request to be requested is sent to the management server The terminal in any storage location based on the rule from the relocation request or update request with reference to the rule storage unit when there is A step of determining whether or not to execute a setting process on a fixed device, and an attachment of information in which the printer and the output device provided in the determined storage location have information on the work instruction and the instruction code 13. The information processing apparatus management program according to claim 12 , further comprising the step of outputting means. The information processing apparatus management system is a system for managing an information processing apparatus in a specific company, and when the management server receives personnel information from a personnel management server that manages personnel data in the specific company, the rule The information processing apparatus management program according to claim 12 or 13 , wherein a step of generating the request based on the rule from the personnel information with reference to an accumulation unit is executed. A table for storing the rules or a table for associating and holding various types of information, and a logical table structure is to store a series of data in each column defining attributes common to each data. A definition file that defines the logical table structure of the table that manages the series of data as a row, and a column structure definition file in which column identification information indicating the common attribute corresponding to each column is defined; An input data file having a series of data conforming to the column structure defined by the column structure definition file and having a series of data associated with row identification information indicating attributes of the series of data. The line identification information corresponding to each data obtained from the input data file, and Acquiring column identification information corresponding to data from the column structure definition file, generating a record having the acquired row identification information, column identification information, and the data as field values; and The information processing apparatus management program according to any one of claims 12 to 14 , wherein a step of registering in a database included in the system is executed. Determining whether there is no data in the series of data in the input data file, and registering the record in the database only for data for which there is data as a result of the determination A step of determining whether or not a record specified by the row identification information and the column identification information exists when reading information from the database, and a corresponding record does not exist The information processing apparatus management program according to claim 15 , further comprising: outputting empty data as data corresponding to the row identification information and the column identification information. An information processing apparatus management method by an information processing apparatus management system that manages a plurality of information processing apparatuses that can have one of an operating state used by a user and a storage state that is not used A management server, a terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server, and a rule storage unit that stores rules to be processed for various requests An information reading unit capable of reading information from the information attachment means, and a printer for outputting various forms and an output device capable of outputting information attachment means capable of reading information by optical or electromagnetic techniques Is provided in the terminal setting device, and the information processing device has the information of the identification code corresponding to the information processing device. And with the biasing means, to enter the request to the management server, on the basis of the rules from the request by referring to the rule storage unit, generates a setting information or processing instruction to be set for the information processing apparatus Then, an instruction code corresponding to the process is generated, the information attachment means having the information of the instruction code is output to the output device, and the rule is stored in the rule from the request to the rule. Based on this, the work instruction information for the worker is generated, the work instruction document describing the contents of the work instruction is printed on the printer, the output information attachment means is attached to the work instruction document, and the work instruction The information reading unit attached to the document and the information attaching unit attached to the information processing apparatus are read by the information reading unit, whereby each of the processes and the information processing apparatus to perform the process are read. The management server that received the information sends the setting information or a processing command to the terminal setting device, thereby automatically setting the information processing device connected to the terminal setting device. An information processing apparatus management method characterized by: An information processing apparatus management method by an information processing apparatus management system that manages a plurality of information processing apparatuses that can have one of an operating state used by a user and a storage state that is not used A management server, a terminal setting device that executes setting processing for the information processing device connected in accordance with a command from the management server, and a rule storage unit that stores rules to be processed for various requests And a printer that outputs various forms, the terminal setting device is provided with a barcode reader, and each information processing device has information on the identification code corresponding to the information processing device and with the, by inputting the request to the management server, on the basis of the rules from the request by referring to the rule storage unit, to the information processing apparatus To generate a setting information or processing instructions to be set, and generates an instruction code in accordance with the process, the rules from the request by referring to the barcode which gave information of the instruction code rule storage unit And a barcode printed on the work instruction and a bar code attached to the information processing apparatus. Is read by the bar code reader, the processing is associated with the information processing device to perform the processing, and the management server that has received the information sends the setting information or processing command to the terminal setting device To automatically perform setting processing for the information processing apparatus connected to the terminal setting apparatus. .

Images