17.33 ioassetsfieldutil export (exporting the definitions of common management fields and additional management fields)
This section describes the ioassetsfieldutil export command, which exports the definitions of common management fields and additional management fields.
Functionality
This command exports the definitions of common management fields and additional management fields to a CSV file.
You can export the definitions of the following common management fields and additional management fields as long as the data type of the field is hierarchical or enumeration:
-
Common management fields of hardware asset information and device information
-
Additional management fields of hardware asset information
-
Additional management fields of software license information
-
Additional management fields of contract information
Execute the command as follows:
-
In a single-server configuration: Execute the command on the management server when setup of the management server setup is complete and when the service on the management server is running.
-
In a multi-server configuration: Execute the command on the database server when setup of both the management server and the database server is complete and when the services on both servers are running.
Format
ioassetsfieldutil export -field export-file-name[ -encoding character-encoding][ -s]
Arguments
- -field export-file-name
-
Specify the absolute path (by using 255 bytes or fewer) of the CSV file to be exported.
- -encoding character-encoding
-
Specify the character encoding of the CSV file to be exported. You can use the character encodings shown below. If you omit this argument, the character encoding is 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
-
- -s
-
Overwrites the file even if a file that has the same name already exists at the export destination. If you omit this argument and a file that has the same name already exists, an overwrite-confirmation message appears. In such a case, the system either cancels output of the file or overwrites the file according to your (the administrator's) response.
Storage location
JP1/IT Desktop Management-installation-folder\mgr\bin\
You can execute this command without specifying the storage location for the executable file by using the command prompt provided by JP1/IT Desktop Management.
Notes
-
This command cannot be simultaneously executed by multiple users.
-
This command cannot be executed simultaneously with any of the following commands:
-
exportdb
-
importdb
-
ioassetsfieldutil import
-
ioutils exportasset
-
ioutils exportdevice
-
ioutils exportdevicedetail
-
ioutils exportfield
-
ioutils exportfilter
-
ioutils exportoplog
-
ioutils exportpolicy
-
ioutils exporttemplate
-
ioutils exportupdategroup
-
ioutils importasset
-
ioutils importfield
-
ioutils importfilter
-
ioutils importpolicy
-
ioutils importtemplate
-
ioutils importupdategroup
-
reorgdb
-
startservice
-
stopservice
-
updatesupportinfo
-
Return values
The following table shows the return values of the ioassetsfieldutil export command.
|
Return value |
Description |
|---|---|
|
0 |
The command finished normally. |
|
11 |
The argument syntax is incorrect. |
|
12 |
The specified folder is invalid, the disk does not have sufficient free space, or the folder does not exist. |
|
15 |
A file access error occurred when outputting the file, or the disk does not have sufficient free space. |
|
31 |
Another command is currently executing. |
|
51 |
You do not have permission to execute this command. |
|
54 |
Either the management server or the database server is not set up. |
|
101 |
Command execution failed either because there is insufficient memory or for some other reason. |
|
120 |
A database access error occurred. |
|
150 |
Command execution was interrupted because of some other error. |
Example
The following example shows how to use this command to export the definitions of common management fields and additional management fields to C:\temp\common.csv.
ioassetsfieldutil export -field C:\temp\common.csv -encoding UTF-8 -s
Related Topics: