2.2.3 Usage example of Batch change of operation users service template
This section describes an assumed system configuration and examples of properties to be specified when using the Batch change of operation users service template.
By using this service template, you can change OS user passwords, change JP1/Base password management information, and change JP1 user passwords based on the contents of CSV (Comma Separated Values) files or spreadsheets created in Microsoft Excel.
Assumed system configuration
This service template assumes the following system configuration:
- Web browser
-
A terminal used to operate JP1/AO. The user uses this terminal to set property values in the service template.
- IT operation automation server
-
A server with JP1/AO and JP1/Base installed. The file of user permission levels is stored on the local disk of the IT operation automation server.
- Authentication server
-
A server with JP1/Base installed.
- Agent server
-
A server with JP1/Base installed.
|
Processing flow
-
A user enters property values in the Web browser and submits the service for execution.
-
The IT operation automation server loads the OS user information file and JP1 user information file specified in the property value.
Based on the loaded parameters, the IT operation automation server performs automated processing on the agent server and the authentication server.
-
Based on the setting values in the OS user information file, the passwords for OS users are changed on the agent server.
-
If you set True for JP1/Base password management information update requirement for a user in the OS user information file, JP1/Base password management information is changed on the agent server.
-
Based on the setting values in the JP1user information file, the passwords for JP1 users on the authentication server are changed.
Example of specifying property values
To use the Batch change of operation users service template, a user must specify the appropriate property values for the user environment. Specify the property values in the Service Definition dialog box and the Submit Service dialog box.
Property group |
Property name |
Property key |
Description |
Specification example |
---|---|---|---|---|
Information on the user information file |
Path of the OS user information file |
OS.osUserInfoFilePath |
Specifies the path of the file containing the OS user information stored in the JP1/AO server as a full path. One of the following file extensions is required: csv, xls, xlsx, or xlsm. |
C:\ao\os_user.xls |
Sheet name of the OS user information file |
OS.osUserInfoSheetName |
If the OS user information file is an Excel file, specify the sheet name containing the user information. |
Sheet2 |
|
Path of JP1 user information file |
jp1base.jp1UserInfoFilePath |
Specifies the path of the file containing the JP1 user information stored in the JP1/AO server as a full path. One of the following file extensions is required: csv, xls, xlsx, or xlsm. |
C:\ao\jp1_user.xls |
|
Sheet name of JP1 user information file |
jp1base.jp1UserInfoSheetName |
If the JP1 user information file is an Excel file, specify the sheet name containing the user information. Always specify when the JP1 user information file is an Excel file. |
Sheet1 |
|
Details of the OS user information file |
Column number of key information of the OS user information file |
OS.osUserInfoKeyColumn |
Specifies the column number containing the "key information" in the OS user information file. Specify the column number as an integer from 1 to 255. |
7 |
Column number of host name of agent server |
common.targetHostNameColumn |
Specifies the column number containing the "Agent server host name" in the OS user information file. Specify the column number as an integer from 1 to 255. |
1 |
|
Column number of JP1/Base logical host name of agent server |
jp1base.jp1BaseLHostNameColumn |
Specifies the column number containing the "Agent server JP1/Base logical host name" in the OS user information file. Specify the column number as an integer from 1 to 255. |
5 |
|
Column number of the OS user name |
OS.osUserNameColumn |
Specifies the column number containing the "OS user name" in the OS user information file. Specify the column number as an integer from 1 to 255. |
2 |
|
Column number of new password of the OS user |
OS.osUserNewPasswordColumn |
Specifies the column number containing the "new password of the OS user" in the OS user information file. Specify the column number as an integer from 1 to 255. |
3 |
|
Column number of the OS user type |
OS.osUserTypeColumn |
Specifies the column number containing the "OS user type" in the OS user information file. Specify the column number as an integer from 1 to 255. |
4 |
|
Column no. of JP1/Base psswrd mngmnt info update required column |
jp1base.updatePasswordInfoColumn |
Specifies the column number containing the "JP1/Base password management information update requirement" in the OS user information file. Specify the column number as an integer from 1 to 255. |
6 |
|
Details of the JP1 user information file |
Column number of key information of JP1 user information file |
jp1base.jp1UserInfoKeyColumn |
Specifies the column number containing the "key information" in the JP1 user information file. Specify the column number as an integer from 1 to 255. |
6 |
Column number of host name of JP1 authentication server |
jp1base.certHostNameColumn |
Specifies the column number containing the "JP1 authentication server host name" in the JP1 user information file. Specify the column number as an integer from 1 to 255. |
1 |
|
Column number of logical host name of JP1 authentication server |
jp1base.certHostLHostNameColumn |
Specifies the column number containing the "JP1 authentication server logical host name" in the JP1 user information file. Specify the column number as an integer from 1 to 255. |
5 |
|
Column number of JP1 user name |
jp1base.jp1UserNameColumn |
Specifies the column number containing the "JP1 user name" in the JP1 user information file. Specify the column number as an integer from 1 to 255. |
2 |
|
Column number of old password of JP1 user |
jp1base.jp1UserOldPasswordColumn |
Specifies the column number containing the "old password of the JP1 user" in the JP1 user information file. Specify the column number as an integer from 1 to 255. |
4 |
|
Column number of new password of JP1 user |
jp1base.jp1UserNewPasswordColumn |
Specifies the column number containing the "new password of the JP1 user" in the JP1 user information file. Specify the column number as an integer from 1 to 255. |
3 |
Relationship between property values and user information in list form
The column of information read from a user information list (OS user information file or JP1 user information file) is specified using the column number associated with each property. User list information must include a column with key information. You can, for example, make an existing user management ledger or other source of user information usable as a user information list by adding a key information column. The following figure shows an example in which an OS user information file is used to change OS user passwords and JP1/Base password management information.
|
-
A user enters property values in the Web browser and submits the service for execution.
-
JP1/AO reads the worksheet specified in the Sheet name of the OS user information file property from the file specified in the Path of the OS user information file property.
-
The column numbers specified for each item in the properties are mapped to the column read from the OSuser information file.
-
JP1/AO references the column specified in the Column number of key information of the OS user information file property, and changes OS user passwords and JP1/Base password management information in lines with the corresponding key information.
Related topics