export asset values command

You can export values of properties and custom attributes of information assets, excluding extended data sources and extension mapping documents, into the file that is in a comma-separated value (CSV) format. Use the istool export asset values command.

Purpose

Use this command to export properties and custom attribute values of information assets, or when you want to schedule an export.

Do not use this command to export extended data sources and extension mapping documents. To export those asset types, use the istool export command. For the full list of supported asset types for which you can export asset values, see Asset types that you can import and export.

Note: This command replaces the istool export custom attribute values command.

Prerequisites

You must have the Information Governance Catalog Information Asset Administrator role.

IBM® InfoSphere® Information Governance Catalog must be installed on the same server as IBM WebSphere® Application Server.

The version of istool command framework must be the same version as InfoSphere Information Governance Catalog.

Run the command from the client tier, or from the engine tier if InfoSphere Information Governance Catalog was installed there.

The preferred way to run this command is in the istool command-line window. If you run this command in your operating system command-line window or in scripts, you must add istool before the command name.

Command syntax

Optional parameters and optional values in the syntax are enclosed in brackets, [ ].

export asset values 
authentication parameters
[generic parameters] 
-directory dir_name
-output log_file_name
-type asset_REST_name
[-pattern]

Parameters

authentication parameters: Required. All asset interchange commands use authentication parameters to connect to a specific installation of InfoSphere Information Server.
generic parameters: The generic parameters are available to all asset interchange commands. Use the generic parameters to request help on command syntax, to specify silent or verbose operation, and to use a script to run commands.
-directory | -dir dir_name: Specifies the directory to contain the export file.; If the directory name has an embedded space, enclose the name in double quotation marks (").
-output | -o log_file_name: Specifies the name of the log file that contains the output, including errors, of the command that was run. Include the directory path in log_file_name.; If the directory does not exist, the command fails.; The log file is created if it does not exist. If the log file does exists, the output is appended to the file. If the command is automated to run at different times, the log file displays the ongoing output of each command that was run.
-type | -t asset_REST_name: The REST name of the asset type.
-pattern | -pt: The pattern to match the asset type name. Put the pattern in double quotation marks ("). You can use a percent (%) or an asterisk (*) as wildcard characters.

Output

A return value of 0 indicates successful completion. Any other value indicates failure. The reason for the failure is displayed in a screen message.

For more information, see the system log file in either of the following directories:

For Microsoft Windows operating system environment: C:\Documents and Settings\username\istool_workspace\.metadata\.log; where username is the name of the operating system account of the user who runs this command.
For UNIX or Linux® operating system environment: user_home/username/istool_workspace/.metadata/.log; where user_home is the root directory of all user accounts, and username is the name of the operating system account of the user who runs this command.

Additionally, see the workbench_cli.log file. This log file is located in the directory from which you ran the command.

Example

The following command exports all database tables whose name begins with the string a_. The REST name for database table is database_table.

export asset values -dom localhost:9445 -u my_user -p my_password -type database_table 
-pt "a_*" -dir C:\tmp -o C:\tmp\log.log