17.20 ioutils exportoplog (exporting operation logs)
Functionality
This command exports operation logs on the management server into a CSV file at a specified time.
If the size of the export file exceeds 2 GB, the file is split into multiple files. The output files are renamed with sequence numbers added to the end of the file names. Output file not split is also renamed with sequence numbers added to the end of the file names.
Even when no information items are available to export, a file is always exported.
For details about the output format of the file to be exported, see A.4 Output format of exported operation logs.
Execute this command on the management server.
Format
ioutils exportoplog -export export-file-name{ -range export-period-of-time| -within export-number-of-days}[ -encoding character-encoding][ -filter filter-name][ -linenumber-of-lines-to-export][ -timezone time-zone-type][ -s]
Argument
- -export export-file-name
-
Specify the absolute path (within 259 bytes) of the CSV file to export.
- -range export-period-of-time
-
Specify export period of time in YYYY-MM-DD# format. The start date and the end date can be separated with a comma (",").
# YYYY: year, MM: month, DD: day
This argument cannot be specified together with -within.
- -within export-number-of-days
-
Specify the number of days of the logs to export. The number must be between 1 and 500.
This argument cannot be specified together with -range.
- -encoding character-encoding
-
Specify a character code for the operation logs to export. The following types of character codes can be specified. When you do not specify this argument, the character code is automatically set to UTF-8.
-
US-ASCII
-
ISO-8859-1
-
UTF-8
-
UTF-8N
-
UTF-16
-
UTF-16LE
-
UTF-16BE
-
MS932
-
Shift-JIS
-
EUC-JP
-
JIS
-
- -filter filter-name
-
Specify a filter name if you want to export specific operation logs using a filter.
In the filter conditions of the specified filter name, do not include Operation Date/Time (Browser). If you specify a filter name whose filter conditions include Operation Date/Time (Browser), filtering might not be performed correctly.
When setting the following filter conditions, add the Operation Type in parentheses to the filter condition. If not added to the filter condition, the output might be incorrect.
-
Process Name (when the Operation Type is a Process/Program Operation)
-
Destination File Drive Type (when the Operation Type is a File Operation)
-
Operation Target File Name (when the Operation Type is a File Operation)
-
Printed Document Name (when the Operation Type is a Print Operation)
-
Device Name (when the Operation Type is a Device Operation)
-
Device Catefory (when the Operation Type is a Device Operation)
-
URL (when the Operation Type is a Web Access)
-
Window Title (when the Operation Type is a Window Operation)
-
- -line number-of-lines-to-export
-
Specify the number of lines you want to export into 1 file. The number must be between 1 and 4294967295. If this argument is omitted, 2 GB worth of operation logs are output to one file.
- -timezone time-zone-type
-
Specify the time zone for the operation date and time to output.
The types of time zone are listed below. If you omit this argument, the system uses the OpLog_ExportSouceDateAndTime property defined in the configuration file (jdn_manager_config.conf). For details about the OpLog_ExportSouceDateAndTime property, see Lists of properties in the manual JP1/IT Desktop Management 2 Overview and System Design Guide. If the property is not defined, local is specified.
-
local: Outputs the operation date and time of the agent with the time zone of the management server.
-
source: Specify it when you want to output additional operation log information of the agent (Operation Date/Time (Agent), Operation Date/Time (UTC), and Time Zone).
-
- -s
-
Overwrites the file even if a file with the same file name already exists at the export destination. If this argument is not specified and a file with the same file name already exists, an overwrite confirmation message appears. In this case, the system cancels the output or overwrites the file according to the administrator's reply.
Storage location
JP1/IT Desktop Management 2-installation-folder\mgr\bin\
You can execute this command without specifying a storage location for the executable file, by using the command prompt provided by JP1/IT Desktop Management 2.
Notes
-
Execute this command when the management server setup is completed, and the services on the management server have started.
-
This command cannot be simultaneously executed by multiple users.
-
This command cannot be executed simultaneously with any of the following commands:
-
exportdb
-
importdb
-
ioassetsfieldutil export
-
ioassetsfieldutil import
-
ioutils exportasset
-
ioutils exportassetassoc
-
ioutils exportdevice
-
ioutils exportdevicedetail
-
ioutils exportfield
-
ioutils exportfilter
-
ioutils exportpolicy
-
ioutils exporttemplate
-
ioutils exportupdategroup
-
ioutils exportupdatelist
-
ioutils importasset
-
ioutils importassetassoc
-
ioutils importexlog
-
ioutils importfield
-
ioutils importfilter
-
ioutils importpolicy
-
ioutils importtemplate
-
ioutils importupdategroup
-
ioutils importupdatelist
-
reorgdb
-
startservice
-
stopservice
-
updatesupportinfo
-
deletenwgroup
-
deletepackage
-
distributelicense
-
Return value
The following table shows the return values of ioutils exportoplog command.
Return value |
Description |
---|---|
0 |
The command finished normally. |
11 |
The specified format for the argument is incorrect. |
12 |
The specified folder is invalid, the disk does not have sufficient capacity, or the folder does not exist. |
15 |
A file access error occurred when outputting the file, or the disk does not have sufficient capacity. |
31 |
Another command is being executed. |
51 |
You do not have the permissions to execute this command. |
54 |
The management server has not been set up. |
70 |
The specified filter does not exist. |
101 |
Command execution failed because there is not enough memory, or due to some other reason. |
120 |
A database access error occurred. |
150 |
The command execution was interrupted due to some other error. |
Example
The following example shows use of this command to export operation logs to C:\temp\exportoplog.csv, with the number of days to export "25", and using a filter called "file copy operations"
ioutils exportoplog -export C:\temp\exportoplog.csv -within 25 -encoding UTF-8 -filter "file copy operations" -s
Related Topics: