Command Execution Log List Display command

The Command Execution Log can be displayed in a list.

= Remarks =

The log records of the Command Execution Log that are backed up by automatic or manual switching can become the target of this command as well.

Program interface

CALL Library name/UTLOPLLIST PARM(['LIB=library name'] 'CL' 
   ['OUTFILE=filename'] ['H=hostname'] ['USR=userid|ADMUSR=userid'] 
   ['OP=operation'] ['PRCID=processingid'] 
   ['FROM=DATE1' ['FTIME=TIME1']] ['TO=DATE2' ['TTIME=TIME2']] 
   ['G'] ['OUTPUT=filename'] ['EXIT' CL variable name])

Explanation of parameters

LIB=library name

Library name in which HULFT is installed ("HULFT" by default)

Specify this parameter as an alphanumeric character string of 10 bytes or less starting with an alphabet.

CL

Specification of Command Execution Log (Mandatory)

OUTFILE=filename

Output file name (Optional)

Specify this parameter in the format of Library name/File name(Member name).

When the log is output to a file, all the fields in the Command Execution Log are output.

When omitted, some main fields are written to standard output.

= Remarks =

For the file format of the Command Execution Log, refer to the following:

HULFT10 for IBMi Administration Manual : File format of operation logs
For the fields written to standard output when the output file name is defaulted, refer to Table 5.6 Fields of the Command Execution Log.

H=hostname

Target Starting Host Name to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 68 bytes or less.

When omitted, all the host names become the targets of this command.

USR=userid

The User ID (OS) on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter within 105 bytes.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the "ADMUSR=" at the same time.

= Remarks =

The user ID of OS is subject to the convention of the OS on the starting host. For details, refer to the following:

HULFT10 for IBMi Administration Manual : Outline of Operation Log

ADMUSR=userid

The User ID of the Management Console Security on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 32 bytes or less.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the "USR=" at the same time.

= Remarks =

For details on the User ID of the Management Console Security of each host type, refer to the following:

HULFT10 for IBMi Administration Manual : Outline of Operation Log

OP=operation

Name of the target request, command, or command execution key to be displayed in the list (Optional)

When omitted, all requests, commands, and command execution keys become targeted by this command.

= Remarks =

For details on request, command, or command execution key names you can specify, refer to the following:

HULFT10 for IBMi Administration Manual : Command execution keys and search keys

PRCID=processingid

Target Latest Identifier to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 34 bytes.

When omitted, all the Latest Identifiers become the targets of this command.

= Remarks =

For details on the Identifier, refer to the following:

HULFT10 for IBMi Administration Manual : Identifier

FROM=DATE1 [FTIME=TIME1] TO=DATE2 [TTIME=TIME2]

Target Start date (Time) and end date (Time) to be displayed in a list (Optional)

When the "FTIME=" is specified, the "FROM=" is mandatory. When the "TTIME=" is specified, the "TO=" is mandatory.

When the "FROM=" is omitted, HULFT displays the log records from the beginning till the date that you specified in the "TO=".

When the "TO=" is omitted, HULFT displays the log records from the date that you specified in the "FROM=" till the latest log record.

When both are omitted, log records of all dates become target of this command. You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings, and DATE1 must be earlier than or equal to DATE2. The log record of the date you specified is included in the target records to be deleted.

= Remarks =

The target of these parameters are the Execution Date and the Execution Time.

G

Control of error messages that the Command Execution Log List Display command outputs (Optional)

When omitted, HULFT displays error messages.

OUTPUT=filename

Destination of the error messages that the Command Execution Log List Display command outputs (Optional)

Specify this parameter in the format of Library name/File name(Member name).

When omitted, error messages are not output.

The number of log records that a log file can retain is unlimited.

EXIT CL variable name

Specifies to receive the error code output by the Command Execution Log List Display command and specifies the CL variable name to set the error code value (Optional)

The CL variable name must be immediately after the EXIT tag.

HULFT sets an error code to the CL variable only if the command ends unsuccessfully.

When omitted, an error code is not set.

Command interface

UTLOPLLIST OPLFILE() PRCID() HOSTNAME() FROMDATE() FROMTIME() TODATE() 
 TOTIME() USERID() USR() ADMUSR() CMDNAME() LFILE() LMBR() 
 LIBRARY( ) MSG( ) FILE( ) MBR( )

Explanation of parameters

OPLFILE

Specification of Command Execution Log (Mandatory)

PRCID

Target Latest Identifier to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 34 bytes.

When omitted, all the Latest Identifiers become the targets of this command.

= Remarks =

For details on the Identifier, refer to the following:

HULFT10 for IBMi Administration Manual : Identifier

HOSTNAME

Target Starting Host Name to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 68 bytes or less.

When omitted, all the host names become the targets of this command.

FROMDATE

Target start date to be displayed in a list (Optional)

Specify this parameter in numbers of 8 bytes in length.

When omitted, all the dates through the specified date for the TODATE become the targets of this command.

You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings. Specify a date in the range from FROMDATE to TODATE. The log record of the date you specified is included in the target records to be output in a list.

What is searched is Execution Date.

FROMTIME

Target start time to be displayed in a list (Optional)

Specify this parameter in numbers shorter than 6 bytes in length. You can specify this parameter only when the FROMDATE is specified.

When omitted, all the times through the specified time for the TOTIME become the targets of this command.

The time is output in the form of hhmmss. Specify a time in the range from FROMTIME to TOTIME. The specified time is covered by the target range of output as well.

What is searched is Execution Time.

TODATE

Target end time to be displayed in a list (Optional)

Specify this parameter in numbers of 8 bytes in length.

When omitted, all the dates on and after the specified date for the FROMDATE become the targets of this command.

You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings. Specify a date in the range of FROMDATE through TODATE. The log record of the date you specified is included in the target records to be output in a list.

What is searched is Execution Date.

TOTIME

Target end time to be displayed in a list (Optional)

Specify this parameter in numbers shorter than 6 bytes in length. You can specify this parameter only when the TODATE is specified.

When omitted, all the times after the specified time for the FROMTIME become the targets of this command.

The time is output in the form of hhmmss. Specify a time in the range of FROMTIME through TOTIME. The specified time is covered by the target range of output as well.

What is searched is Execution Time.

USERID

The User ID on the starting host which is the target to be displayed in a list (Optional)

*USR :: User ID (OS)
*ADMUSR :: User ID of the Management Console Security

When omitted, all the User ID become the targets of this command.

= Remarks =

For the details on the User ID on each host type, refer to the following:

HULFT10 for IBMi Administration Manual : Outline of Operation Log

USR

The User ID (OS) on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter within 105 bytes.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the ADMUSR at the same time.

= Remarks =

The user ID of OS is subject to the convention of the OS on the starting host. For details, refer to the following:

HULFT10 for IBMi Administration Manual : Outline of Operation Log

ADMUSR

The User ID of the Management Console Security on the starting host which is the target to be displayed in a list (Optional)

Specify this parameter as an alphanumeric character string of 32 bytes or less.

When omitted, all the User ID become the targets of this command.

You cannot specify this parameter and the USR at the same time.

= Remarks =

For details on the User ID of the Management Console Security of each host type, refer to the following:

HULFT10 for IBMi Administration Manual : Outline of Operation Log

CMDNAME

Command name or request name to be displayed in a list (Optional)

When omitted, all the command names or request names become the targets of this command.

LFILE

Library name and file name of the output file (Optional)

Specify this parameter in the format of Library name/File name. Specify these names as an alphanumeric character string of 10 bytes or less starting with an alphabet, respectively.

When the log is output to a file, all the fields in the Command Execution Log are output.

When omitted, some main fields are written to standard output.

= Remarks =

For the file format of the Command Execution Log, refer to the following:

HULFT10 for IBMi Administration Manual : File format of operation logs
For the fields written to standard output when the output file name is defaulted, refer to Table 5.6 Fields of the Command Execution Log.

LMBR

Member name of the output file ("*FILE" by default)

LIBRARY

Library name in which HULFT is installed ("HULFT" by default)

Specify this parameter as an alphanumeric character string of 10 bytes or less starting with an alphabet.

MSG

Control of error messages ("*YES" by default)

*NO :: Suppress error messages.
*YES :: Show error messages.

FILE

Name of the library and the file to which error messages are output (Optional)

Specify this parameter in the format of Library name/File name.

Specify these names as an alphanumeric character string of 10 bytes or less starting with an alphabet, respectively.

When omitted, error messages are not output. The number of log records that a log file can retain is unlimited.

MBR

Member name of the file to which error messages are output ("*FILE" by default)

Specify this parameter as an alphanumeric character string of 10 bytes or less starting with an alphabet.

Table 5.6 Fields of the Command Execution Log
Field Name	Description	Size
DATE	Execution Time and Execution Date (in the form of YYYY/MM/DD HH:MM:SS.mmm) (*1)	23 bytes
PROC-ID	Latest Identifier	34 bytes
OS-USERID	User ID (OS)	32 bytes
ADM-USERID	User ID (Management Console)	32 bytes
HOSTNAME	Starting Host Name	68 bytes
OPERATION	Command Execution Key	36 bytes
OPERATION-DETAIL	Command Parameter	40 bytes

You must specify the date according to the format specified as Date Format (DATEFMT) in the System Environment Settings.

= Remarks =

The item that doesn't come up to the display size is indicated in left justification.
When the size of a filed to be displayed is larger than that of the display size, the part that exceeded the display size is cut off.

Output example

Standard output

2017/12/29 18:36:18.503 420972D411140625000E471A000000F421                   
USR01                                                                        
AS400                                                                        
MANAGEMENT_INFORMATION_REGISTRATION  'LIB=HULOLIB' 'I=RCV' 'ID=FILE00018NAGOY 
                                                                             
2017/12/29 18:36:24.749 420972D41145FDF4000E471A000000F821                   
USR01                                                                        
AS400                                                                        
SEND_FILE                            'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKY 
                                                                             
2017/12/29 18:37:36.570 420972D413848F5C000E471A0000010621                   
USR01                                                                        
AS400                                                                        
MANAGEMENT_INFORMATION_REGISTRATION  'LIB=HULOLIB' 'I=SND' 'ID=FILE00018NAGOY 
                                                                             
2017/12/29 19:08:56.434 420972D44E4376C9000E471A0000011921                   
USR01                                                                        
AS400                                                                        
SEND_FILE                            'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKY 
                                                                             
2017/12/29 19:08:56.434 420972D44E4376C9000E471A0000011921                   
USR01                                                                        
AS400                                                                        
SEND_FILE                            'LIB=HULOLIB' 'F=FILE00018NAGOYA8TO8TOKY 
                                                                             
2017/12/29 19:13:58.802 420972D457B66A7F000E471A0000012221                   
USR01                                                                        
AS400                                                                        
HULFT_MANAGEMENT_SCREEN_FINISH                                               
                                                                             
2017/12/29 19:14:09.562 420972D4580C7EFA000E471A0000012E21                   
USR01                                                                        
AS400                                                                        
HULFT_MANAGEMENT_SCREEN_START        'LIB=HULOLIB'                           
                                                                             
2017/12/29 19:14:12.271 420972D458222B02000E471A0000013221                   
USR01                                                                        
AS400                                                                        
HULFT_MANAGEMENT_SCREEN_FINISH

File output

"2017/12/29","18:36:18.503","2017/12/29","18:36:18.503","USR01","","AS400","420972D411140625000E471A000
000F421","420972D411140625000E471A000000F421","AS400","","MANAGEMENT_INFORMATION_REGISTRATION","HULFT_
MANAGEMENT_SCREEN","'LIB=HULOLIB' 'I=RCV' 'ID=FILE00018NAGOYA8TO8TOKYO'"   
"2017/12/29","18:36:24.749","2017/12/29","18:36:24.749","USR01","","AS400","420972D41145FDF4000E471A000
000F821","420972D41145FDF4000E471A000000F821","AS400","","SEND_FILE","HULFT_MANAGEMENT_SCREEN","'LIB=HU
LOLIB' 'F=FILE00018NAGOYA8TO8TOKYO'"                                      
"2017/12/29","18:37:36.570","2017/12/29","18:37:36.570","USR01","","AS400","420972D413848F5C000E471A000
0010621","420972D413848F5C000E471A0000010621","AS400","","MANAGEMENT_INFORMATION_REGISTRATION","HULFT_M
ANAGEMENT_SCREEN","'LIB=HULOLIB' 'I=SND' 'ID=FILE00018NAGOYA8TO8TOKYO'"   
"2017/12/29","19:08:56.434","2017/12/29","19:08:56.433","USR01","","AS400","420972D44E4376C9000E471A000
0011921","420972D44E4376C9000E471A0000011921","AS400","","SEND_FILE","HULFT_MANAGEMENT_SCREEN","'LIB=HU
LOLIB' 'F=FILE00018NAGOYA8TO8TOKYO'"                                      
"2017/12/29","19:13:58.802","2017/12/29","19:13:58.802","USR01","","AS400","420972D457B66A7F000E471A000
0012221","420972D457B66A7F000E471A0000012221","AS400","","HULFT_MANAGEMENT_SCREEN_FINISH","HULFT_MANAGE
MENT_SCREEN",""                                                           
"2017/12/29","19:14:09.562","2017/12/29","19:14:09.562","USR01","","AS400","420972D4580C7EFA000E471A000
0012E21","420972D4580C7EFA000E471A0000012E21","AS400","","HULFT_MANAGEMENT_SCREEN_START","HULFT_MANAGEM
ENT_SCREEN","'LIB=HULOLIB'"                                               
"2017/12/29","19:14:12.271","2017/12/29","19:14:12.271","USR01","","AS400","420972D458222B02000E471A000
0013221","420972D458222B02000E471A0000013221","AS400","","HULFT_MANAGEMENT_SCREEN_FINISH","HULFT_MANAGE
MENT_SCREEN",""

= Remarks =

The date format varies depending on a value of the Date Format (DATEFMT) that is specified in the System Environment Settings. For details, refer to the following:

HULFT10 for IBMi Administration Manual : Global Settings

Notes

If you specify the FROMDATE, HULFT searches the Command Execution Log from the top, then detects the first log record that matches the value of the FROMDATE, and displays the log record together with all the records that follow after.
If you specify TODATE, HULFT searches the Command Execution Log from the top or from the time or date that is specified for the FROMDATE, and displays the log records up to the first one that exceeds the value that is specified for the TODATE.

Figure 5.2 Display Range of Operation Log