JP2007304660A - Command execution result recording system and command execution result recording method - Google Patents

Abstract

PROBLEM TO BE SOLVED: To automatically execute a command and automatically record a result in a check list.
A command execution result recording system including an operation terminal 1 for determining a return value of an execution result when a command is given to a plurality of work target servers, wherein the operation terminal 1 receives a predetermined command / the predetermined command. A command information table 50 that stores a normal return value output when executed by a predetermined work target server / a confirmation ID given to a confirmation command when the predetermined command is executed; A confirmation item information table 40 for storing a confirmation ID / a confirmation command corresponding to the confirmation ID, and a confirmation corresponding to the confirmation ID read from the predetermined command / confirmation item information table 40 stored in the command information table 50 Generating a script file 80 including commands for the work, work content information / work target corresponding to the commands included in the script file 80 Which generates a check list information 90 including the confirmation result information by over server-name / combination thereof.
[Selection] Figure 1

Description

  The present invention relates to a command execution result recording system and a command execution result recording method in a data center that operates and manages a server system that provides various business operation processing services to a plurality of customers. The present invention relates to a command execution result recording system and a command execution result recording method capable of issuing a wide variety of commands and automatically recording the execution results of the plurality of commands.

  A computer system that provides various business operation processing services in recent years has a plurality of business servers corresponding to a large number of business, and when performing business operation work such as maintenance and change of the system composed of the plurality of business servers. It is necessary to issue a wide variety of commands to all business servers and check whether or not this system has been configured correctly. The accuracy of work performed by the department in charge is required.

  In the prior art, in order to ensure the accuracy of the confirmation work, for example, the work procedure manual is detailed and the work results are checked by multiple people. There was a possibility that a human error such as an input error at the time of entry would occur. Furthermore, in the prior art, there are materials to carry along with work procedure manuals and checklists for browsing information necessary for work, hindering work efficiency for carrying large amounts of materials, and for confirmation of materials on site There was a defect that it would contribute to human error.

The following patent document is cited as a document that describes a technique for improving the efficiency of the confirmation work. In this patent document, a checklist is registered in the inspection server, and the operator checks the checklist and necessary information. In this case, a technique is described in which technical information necessary for the confirmation work is downloaded from the inspection server, and a check list in which the check result is input is returned to the inspection server.
JP 2003-316426 A

  Although the technology described in the patent document can improve the efficiency of the confirmation work by systematizing and unifying the checklist in the confirmation work, the confirmation work result confirmation and result input depend on the manual work. There was a defect that would contribute to the occurrence of mistakes.

  Further, as a method for confirming the work result in the system change work, a method of generating a checklist describing the procedure manual of the work to be performed and items to be confirmed by the work, and entering the result for each work item at the time of work can be considered. Although this method can prevent omissions in work procedures, mistakes in the confirmation of work results, and omissions in work hosts, the work procedure manual and checklist are both paper media, so centralized management is possible. In addition, there was a problem that the result had to be entered manually.

  An object of the present invention is to eliminate the above-mentioned problems caused by the prior art, and in a business operation work for a plurality of business processing systems and peripheral devices, an operation is executed from information defining a command to execute the work and a confirmation item corresponding to the command. A command execution result recording system and a command execution result recording method capable of generating a command to be executed and a check list for confirming the result and automatically executing the command in the generated check list and automatically recording the result in the check list Is to provide.

To achieve the above object, the present invention provides a plurality of work target servers having a computer that executes a command and outputs the execution result of the executed command as a return value, and gives the command to the computer of the work target server. A command execution result recording system comprising an operation terminal having a computer for executing the command and determining a return value of an execution result of the executed command,
The operation terminal is
A predetermined command, work content information indicating the work content of the predetermined command, a normal return value output when the predetermined command is executed by a predetermined work target server, and the predetermined command are executed. An execution command table that stores a confirmation ID attached to a confirmation command when
A confirmation item information table storing the confirmation ID and a confirmation command corresponding to the confirmation ID;
Script file generation function for generating a script file including a predetermined command and work content information read from the execution command table and a confirmation command corresponding to a confirmation ID read based on a confirmation ID from the confirmation item information table When,
Work content information corresponding to a command included in the script file generated by the script file generation function, a work target server name input so as to execute a command corresponding to the work content information, the work content information, A first feature is that it includes a computer that executes a checklist generation function that generates checklist information including confirmation result information in combination with a work target server name.

  In the command execution result recording system, the present invention provides a function in which a computer of the operation terminal executes a command included in a script file generated by the script file generation function, and a work target server for the executed command. A function of comparing a return value output by the command and a normal return value stored in the execution command table, and storing a result of the comparison in the confirmation result information of the check list information. To do.

Further, the present invention provides a plurality of work target servers having a computer that executes a command and outputs the execution result of the executed command as a return value, and gives the command to the computer of the work target server to execute the command. An operation terminal having a computer for determining a return value of the execution result of the executed command,
The operation terminal is
A predetermined command, work content information indicating the work content of the predetermined command, a normal return value output when the predetermined command is executed by a predetermined work target server, and the predetermined command are executed. An execution command table that stores a confirmation ID attached to a confirmation command when
A command execution result recording method of a command execution result recording system comprising the confirmation ID and a confirmation item information table storing a confirmation command corresponding to the confirmation ID,
The computer of the operation terminal is
Script file generation step of generating a script file including a predetermined command and work content information read from the execution command table and a confirmation command corresponding to the confirmation ID read based on the confirmation ID from the confirmation item information table When,
Work content information corresponding to a command included in the script file generated by the script file generation function, a work target server name input so as to execute a command corresponding to the work content information, the work content information, A third feature is that a check list generation step of generating check list information including confirmation result information in combination with a work target server name is executed.

  In the command execution result recording method, the present invention provides a process in which a computer of the operation terminal executes a command included in a script file generated by the script file generation function, and a work target server for the executed command. And a step of comparing the return value output by the normal return value stored in the execution command table and storing the comparison result in the confirmation result information of the check list information, as a fourth feature. To do.

  According to the present invention, in an operation / maintenance operation of a server that provides a business processing service to a plurality of customers, an execution command and a work content are changed before the operation based on a predefined execution command and confirmation items. By creating and executing a linked checklist, it is possible to automatically record confirmation results, reducing the chances of mistakes in confirming results when working manually, omission of results, and omission of work on the target host. .

Hereinafter, a command execution result recording system and a command execution result recording method according to an embodiment of the present invention will be described in detail with reference to the drawings. FIG. 1 is a diagram showing an overall configuration of a command execution result recording system for realizing a command execution result recording method according to an embodiment of the present invention, and FIG. 2 is an execution command and confirmation items managed in an operation terminal according to the present embodiment. FIG. 3 is a diagram showing an example of information registration, FIG. 3 is a diagram showing a screen example of a script and check list generation program according to this embodiment, FIG. 4 is a flowchart showing a script generation procedure according to this embodiment, and FIG. 5 is a check according to this embodiment. FIG. 6 shows a specific example of a script file generated by the script and the check list generation program. FIG. 7 shows a specific example of check list information generated by the script and the check list generation program. Figures 8 and 8 show command issue control and checklist output according to this embodiment. It is a flowchart showing a specific example of a management procedure.
<Description of configuration>

  As shown in FIG. 1, the command execution result recording system according to the present embodiment is connected to an input device 21, a display device 22, and a peripheral device 123, and is a computer to be checked for whether or not the system construction is correctly performed. And a computer connected to the work target server 2, issuing various commands to the work target server 2, and confirming whether or not the work target server 2 is correctly constructed And an operation terminal 1 including Connected to the operation terminal 1 are an input device 11 that receives input of command selection and confirmation information from an operator, and a display device 12 that displays a command name and input content. Although only one work target server 2 is shown in the drawing, in an actual system, a plurality of work target servers corresponding to a large number of tasks are connected to the operation terminal.

  The operation terminal 1 displays on the display device 12 a command information table 50 storing execution command definition information defining various commands for performing confirmation work, and commands to be executed and confirmation items. The script file 80 and the check list generation program 30 that generate the script file 80 and the check list information 90 after the items are determined, and the confirmation item information table 40 that stores confirmation item definition information defining confirmation items for the work target server 2 are provided. The script file and checklist generation program 30 creates a script file 80 under the instructions of the operator using the various definition information stored in the command information table 50 and the confirmation item information table 40. Various commands are executed on Together to create a checklist information 90 for one in which to reflect the check (check) results of the various command execution executed based on the checklist to checklist information 90.

  The execution command definition information defined by the command information table 50 includes, as shown in the upper part of FIG. 2, the item number (#), the category of the command to be executed, the work contents by the command, the command, and the normality by the command It consists of a plurality of items including a return value and a confirmation ID of confirmation item definition information to be described later. For example, the item number “1” includes a command for performing “file copy” work content with the category “file update”. “FILECOPY”, the normal return value from the work target server for this command “FILECOPY” is “0”, and when executing the command “FILECOPY”, the confirmation ID defined in the confirmation item definition information described later is “ It is defined that the confirmation command is “F1” and “F2”.

  As shown in the lower part of FIG. 2, the confirmation item definition information stored in the confirmation item information table 40 includes an item number (#), a category of a command to be executed, a confirmation ID assigned to each command, a work A confirmation command corresponding to the confirmation ID, a confirmation content for displaying the content of the confirmation command, and a confirmation item parameter of the confirmation content. For example, the item number “1” includes The procedure of the confirmation ID “F1” with the category “file update” is “existence confirmation” for confirming whether or not the designated file exists in the designated path, and a command for this “existence confirmation”. Is “CHKPATH”, the confirmation content is “file existence [% 1]” (where “% 1” etc. is a variable), and the confirmation item parameter is “% 1: file path”. ing

  The definition relationship between these two tables will be described. For example, when the operator selects the work content “file copy” in the category “file update” of the execution command definition information, the command “FILECOPY” is executed. The command for confirming that “update” is correct is the commands “CHKPATH” and “CHKTIME” defined by the confirmation IDs “F1” and “F2”, and “c: ¥ TEST. “txt: file path” and “c: ¥ TEST.txt: file path / 2005/1/1 13:00: update date” are displayed, and the normal return value for the command “FILECOPY” is “ “0” is defined.

  The script file and the check list generation program 30 display as functions a command input unit 31 that receives a command input arbitrarily selected by an operator, a confirmation item input unit 32 that receives input of a confirmation item, and the input command. A command display unit 33 for performing confirmation, a confirmation information input unit 34 for receiving input of confirmation information, a script file generation unit 35 for generating a script file 80 based on the input command / confirmation item / confirmation information, and the script The function includes a check list generation unit 36 that generates check list information based on the file 80, and the operator uses the operation screen shown in FIG. 3 to indicate a work name 301 and a work target server 302 that is a work target. And select a category and operation from the command list 303 and execute the command By determining 304, as the work execution time information 305, for example, the work name and other information corresponding to the determined command “file copy” are read from the execution command definition information and the confirmation item definition information and displayed. When the script file / check list generation 306 is clicked, the script file 80 and the check list information 90 are generated.

  As shown in FIG. 6, the script file 80 is a list of commands to be executed based on the execution command definition information and the confirmation item definition information (FIG. 2). It consists of commands “CHLPATH” and “CHKTIME” associated with confirmation IDs “F1” and “F2”, followed by a command string, followed by a command “FILEECOP” of item number “1” of the command information .

  The check list information 80 includes “work contents” such as host name confirmation and file update and confirmation contents to be confirmed according to the work contents for each item number, as shown as “before work” in the upper part of FIG. It consists of each item of “work item name” and “work content” for specifying the “confirmation item” and “work host name” for specifying the work target server for which the “work content” is to be confirmed. It is represented as a list composed of confirmation result information fields for storing check results.

  The work target server 2 includes an input device 21, a display device 22, a peripheral device 123, a command issuance control and checklist output program 60 that controls execution of a process according to a command input from the operation terminal 1, and the command And a system management command 120 including a peripheral device management command 121 for controlling the peripheral device 123 and the like, and an operation management tool control command 122 for changing the setting of the operation management tool.

The command issue control and checklist output program 60 includes a command string input unit 61 for inputting commands from the script file 80 of the operation terminal 1 and a checklist for inputting checklist information from the checklist information 90. An information input unit 62, a server check unit 63 for inputting a work target server name input by an operator, and a server name that has been checked (confirmed) among the server names input by the server check unit 63. An executed check unit 64 for identifying, a return value check unit 65 for checking a return value returned from the work target server by command execution, a command execution control unit 66 for controlling command execution, and the command execution And enter the confirmation result in the checklist information based on the return value. Composed from the check list information recording output unit 67 for outputting.
<Description of operation>

<Generate script file>
As shown in FIG. 4, the command execution result recording system configured as described above uses the work name (for example, “data update 001”) input by the worker in the work name 301 on the operation screen shown in FIG. Step 401 for reading, Step 402 for outputting the work name to the head of the script file, Step 403 for reading an execution command (for example, “FILECOPY”) selected by the operator from the command list 303 on the operation screen, and execution Step 404 for outputting the command to the script file, Step 405 for reading the confirmation ID (for example, “F1”) defined in the read execution command, and a confirmation command (for example, “CHKPATH”) defined for the confirmation ID. Read, replace between confirmation ID and confirmation command ("F1" → "CH PATH ”), step 407 for outputting the replaced confirmation command to the script file, and determining whether or not a confirmation ID is further defined, and determining that a further confirmation ID is defined. When it is determined in step 408 that the process returns to step 406 and no further confirmation ID is defined by the determination in step 408, it is determined whether or not a further execution command is defined. Then, returning to the step 404, the step 409 for further replacing the confirmation ID of the execution command is sequentially executed, so that the script file 80 shown in FIG. 6 is created. That is, the command execution result recording system according to the present embodiment extracts the commands defined in the execution command definition information and the confirmation item definition information based on the work name or execution command input or selected by the operator, and performs the confirmation execution. And a script file 80 corresponding to a simple program including a list of execution commands and confirmation commands for confirming execution results of the execution commands.

<Generation of checklist information>
Next, this system generates check list information 90 based on the script file 80, and the processing procedure will be described with reference to FIG. In this process, as shown in FIG. 5, the step 501 for reading the work name input to the script file 80 and the read work name as the head column of the check list information (“work content” in the format in the upper part of FIG. 7). Step 502 for outputting to the command, Step 503 for reading the command input to the script file 80, and a confirmation ID (eg, “F1”) defined in the read command, and confirmation item definition information based on the confirmation ID Step 505 for reading the confirmation information (for example, “confirm existence of the file”) from the two and replacing (“F1” → “confirm existence of the file”) between the two, and the replaced confirmation information to the check list information Step 506 for outputting, it is determined whether or not a confirmation ID is further defined, and it is further determined that a confirmation ID is defined. When it is determined in step 507 that the process returns to step 505 and no further confirmation ID is defined by the determination in step 507, it is input in the “work target server” column of the operation screen shown in FIG. A step 508 for reading the server name, a step 509 for outputting the read server name to the “working host name” field of the check list information, a determination is made as to whether or not a server name has been entered, and the server name If it has been input, the processing returns to the step 509 and the step 510 is sequentially executed to generate the check list information 90 in the format shown in the upper part of FIG. That is, the present system generates check list information (check result blank) shown in the upper part of FIG. 7 using the script file 80 and the execution command input from the operation screen shown in FIG. It will work.

  As described above, the command execution result recording system according to the present embodiment stores the execution command definition information and the confirmation item definition information shown in FIG. 2 in the operation terminal 1, and the work target server name and work input by the operator. The other confirmation command for confirmation defined in the execution command selected corresponding to the content is read through the confirmation ID, and a command to be executed by the execution and confirmation command is generated as a script file 80, and the script The check list information shown in the upper part of FIG. 7 is automatically generated using the file 80 and the work name and work host name input or selected by the worker.

<Execution of confirmation work and output of results>
The command execution result recording system and the execution result recording method according to the present embodiment execute various commands for the work target server 2 using the checklist information described above, confirm the command execution results, and check the confirmation results. The checklist information is input (filled in), and this processing procedure will be described with reference to FIG.

  FIG. 8 is a flowchart of command control and automatic recording to checklist information when executing a script file according to the present embodiment. This process executes the script file 80 on the work server and places it at the head of the script file 80. A step 801 for reading checklist information in which a work name having the same name as the defined work name is defined, a step 802 for obtaining the host name of the server that executed the script file 80, and the acquired host name as a key. Step 803 for searching for a matching host name from the host name definition line of the checklist information, Step 804 for determining whether or not there is a matching host name as a result of the search, and Host name that matches in Step 804 When the server is not found, a message indicating that the work server is different is displayed. Step 812 for setting, step 813 for outputting the result to the checklist information following the step 812, and the column of the target host in the checklist information 90 when a matching host name is found in the step 804 Step 805 for confirming whether or not the server being executed has already been worked from the result, Step 806 for judging the result of the confirmation and shifting to Step 812 when it is judged that the work has been performed, and Step 806 Step 807 for executing the commands defined in the script file 80 in order from the top when it is determined that the work has not been performed, and a return value responding to the execution in step 807 are obtained, and the return value and the execution command definition information are obtained. Judges whether or not the return value corresponding to the defined command matches. If it is determined that there is not, step 808 that shifts to step 812, and a symbol indicating that the item of the checklist information 90 is normal (for example, “◯”) when it is determined by step 808 that it matches the normal return value. Step 809 is set so as to be stored in the confirmation result information column, and after Step 809, it is determined whether a command remains, and when it is determined that the command remains, Step 811 is returned to Step 807. When it is determined in step 811 that no command remains, and following step 813, the script file is executed.

  As described above, the command execution result recording system and the execution result recording method according to the present embodiment perform the command control when executing the script file shown in FIG. Execution of various commands, confirmation of the command execution result, and input (fill-in) of the confirmation result to the checklist information can be automatically performed. As shown in the lower part of FIG. In the combination column of the matrix of the work host name (for example, HOST_A, etc.) and the work content corresponding to each item number (for example, “host name confirmation”), a symbol of the work result, for example, “○” when normal, and when not normal By entering (inputting) “x”, various command execution results for the work target server 2 can be automatically obtained without depending on manpower. ON (Input) it is possible to, thereby making it possible to improve the reliability of the efficiency and work of the check work. In the check list information in the lower part of FIG. 7, an error was reported in the work content “host name confirmation” work with the host name “HOST_E”. The result of “file update” is blank, indicating that the operation has been interrupted.

  As described above, the command execution result recording system according to the present embodiment associates a command for executing work with the operation terminal 1 and a confirmation item to be confirmed by the work and stores them as “execution command definition information” and “confirmation item definition information”. In addition, when the worker selects and decides the work contents to be executed and the work target server before the work is performed, a script file 80 including a command sequence for performing the work and a confirmation associated with the script file 80 are confirmed. A checklist information 90 in a matrix format describing items and work hosts is generated, and the generated execution command sequence is sequentially executed at the time of execution of work, and the execution result is defined in advance as “execution command definition information”. By automatically entering the confirmation result (“○” or “×”) in comparison with the “return value”, the command It can be described or outputs the result of the confirmation items defined in the check list information for each row as a checklist information.

  Therefore, according to the present embodiment, a command to be executed and checklist information for confirming the result are generated from the information defining the command for performing the work and the corresponding confirmation item, and the command is automatically generated based on the generated checklist information source. Execution and automatic recording of check results in checklist information can be performed, thereby improving the efficiency of confirmation work and improving the reliability of check results by manual work.

  The command execution result recording system and the command execution result recording method according to the present invention operate a business processing system for a plurality of customers in order to output manual check results to checklist information and prevent manual error and omission. In addition, it can be used for an outsourcing service of configuration change work in a shared use data center or the like equipped with an operation terminal for maintenance.

The figure which shows the whole structure of the command execution result recording system which implement | achieves the command execution result recording method by one Embodiment of this invention. The figure which shows the example of registration of the execution command and confirmation item information managed in the operation terminal by this embodiment. The figure which shows the example of a screen of the script by this embodiment, and a check list production | generation program. The flowchart which shows the script production | generation procedure by this embodiment. The flowchart which shows the check list production | generation procedure by this embodiment. The figure which shows the specific example of the script file produced | generated by the script and checklist production | generation program by this embodiment. The figure which shows the specific example of the check list information produced | generated by this script and a check list production | generation program. 6 is a flowchart showing a specific example of a command issuance control and checklist output processing procedure according to the present embodiment.

Explanation of symbols

1: operation terminal, 2: work target server, 11: input device, 12: display device, 21: input device, 22: display device, 30: check list generation program, 31: command input unit, 32: confirmation item input unit 33: command display unit, 34: confirmation information input unit, 35: script file generation unit, 36: check list generation unit, 40: confirmation item information table, 50: command information table, 60: check list output program, 61: Command string input unit 62: Check list input unit 63: Server check unit 64: Check unit 65: Return value check unit 66: Command execution control unit 67: Check list record output unit 80: Script file 90: Check list information, 120: System management command, 121: Peripheral device management command, 12 : Operations management tool control commands, 123: peripheral equipment.

Claims (4)

A plurality of work target servers having a computer that executes a command and outputs the execution result of the executed command as a return value, and gives the command to the computer of the work target server to execute the command and execute the command A command execution result recording system comprising an operation terminal having a computer for determining a return value of the execution result of
The operation terminal is
A predetermined command, work content information indicating the work content of the predetermined command, a normal return value output when the predetermined command is executed by a predetermined work target server, and the predetermined command are executed. An execution command table that stores a confirmation ID attached to a confirmation command when
A confirmation item information table storing the confirmation ID and a confirmation command corresponding to the confirmation ID;
Script file generation function for generating a script file including a predetermined command and work content information read from the execution command table and a confirmation command corresponding to a confirmation ID read based on a confirmation ID from the confirmation item information table When,
Work content information corresponding to a command included in the script file generated by the script file generation function, a work target server name input so as to execute a command corresponding to the work content information, the work content information, A computer that executes a checklist generation function that generates checklist information including confirmation result information in combination with a work target server name,
A command execution result recording system characterized by the above. The computer of the operation terminal is
A function for executing a command included in a script file generated by the script file generation function and a return value output by the work target server for the executed command and a normal return value stored in the execution command table are compared. The command execution result recording system according to claim 1, further comprising a function of storing the comparison result in the confirmation result information of the check list information. A plurality of work target servers having a computer that executes a command and outputs the execution result of the executed command as a return value, and gives the command to the computer of the work target server to execute the command and execute the command An operation terminal having a computer for determining the return value of the execution result of
The operation terminal is
A predetermined command, work content information indicating the work content of the predetermined command, a normal return value output when the predetermined command is executed by a predetermined work target server, and the predetermined command are executed. An execution command table that stores a confirmation ID attached to a confirmation command when
A command execution result recording method of a command execution result recording system comprising the confirmation ID and a confirmation item information table storing a confirmation command corresponding to the confirmation ID,
The computer of the operation terminal is
Script file generation step of generating a script file including a predetermined command and work content information read from the execution command table and a confirmation command corresponding to the confirmation ID read based on the confirmation ID from the confirmation item information table When,
Work content information corresponding to a command included in the script file generated by the script file generation function, a work target server name input so as to execute a command corresponding to the work content information, the work content information, A command execution result recording method comprising: executing a checklist generation step of generating checklist information including confirmation result information in combination with a work target server name. The computer of the operation terminal is
The step of executing the command included in the script file generated by the script file generation function is compared with the return value output by the work target server for the executed command and the normal return value stored in the execution command table 4. The command execution result recording method according to claim 3, further comprising: storing the comparison result in the confirmation result information of the check list information.