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.

Figure 2‒3: System configuration assumed for the Batch change of operation users service template

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 window and the Submit Service window.

Table 2‒5: Examples of property values specified in the Submit Service window (Batch change of operation users)
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.

Figure 2‒4: Mapping example in which OS user information file is used

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.

To Page Top