17.6 ioutils exportassetassoc (exporting asset association information)
Functionality
This command exports asset association information to a CSV file.
Each of the following assets can be associated with any one of the assets listed under it for export:
Hardware asset
-
Device
-
Hardware asset
-
Contract
Software license
-
Managed software
-
License to be upgraded
-
Device
-
Contract
Managed software
-
Software
-
Software license
Contract
-
Hardware asset
-
Software license
-
Contract vendor list
- Note
-
Hereafter, an asset association will be expressed as follows:
asset-information -> relevant-asset-information
For example, hardware asset information associated with device information can be expressed as "Hardware asset -> Device."
When no exportable information exists, this command outputs an empty file.
- Note
-
This command does not output a header row.
Execute this command on the management server.
Format
ioutils exportassetassoc -export export-file-name -assoc asset-association-information-to-be-exported[ -encoding character-encoding][ -s]
Arguments
- -export export-file-name
-
Specify the absolute path (within 259 bytes) of the CSV file to export.
- -assoc asset-association-information-to-be-exported
-
Specify the asset association information to be exported. The following types of asset association information are available:
- asset-device
-
Hardware asset -> Device
- asset-asset
-
Hardware asset -> Hardware asset
- asset-contract
-
Hardware asset -> Contract
- license-mngsoftware
-
Software license -> Managed software
- license-upglicense
-
Software license -> License to be upgraded
- license-device
-
Software license -> Device
- license-contract
-
Software license -> Contract
- mngsoftware-software
-
Managed software -> Software
- mngsoftware-license
-
Managed software -> Software license
- contract-asset
-
Contract -> Hardware asset
- contract-license
-
Contract -> Software license
- contract-vendor
-
Contract -> Contract vendor list
- -encoding character-encoding
-
Specify a character code for assert association information to export. The following types of character codes can be specified. When you do not specify this argument, the character code 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 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 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 are running.
-
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 exportdevice
-
ioutils exportdevicedetail
-
ioutils exportfield
-
ioutils exportfilter
-
ioutils exportoplog
-
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 values
The following table shows the return values of the ioutils exportassetassoc 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. |
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 the Hardware asset -> Device associations to C:¥temp¥assetdeviceexpo.csv.
ioutils exportassetassoc -export C:\temp\assetdeviceexpo.csv -assoc asset-device -encoding UTF-8 -s
Related Topics: