Hitachi

JP1 Version 12 JP1/IT Desktop Management 2 Overview and System Design Guide


2.11.9 Importing asset association information

By using a CSV file, you can import asset association information. You can add all imported asset associations to the list or edit them. The ioutils importassetassoc command is available to import asset association information. Each of the following assets can be associated with any one of the assets listed under it for import:

Hardware asset

Software license

Managed software

Contract

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."

Organization of this subsection

(1) Coding format of a CSV file used to import asset association information

Data inside the CSV file to be used for import must be coded according to the prescribed coding format. Specific combinations of asset items that can be associated with one another for import as well as a coding format appropriate for each combination of asset information items are provided below.

Note

Each CSV file you create for import can only list information pertaining to a specific combination of asset items. For example, there must be one CSV file that lists information regarding the "Hardware asset -> Device" association and another CSV file that lists information regarding the "Hardware asset -> Contract" association.

Tip

You do not have to enclose each data item to be imported in double quotation marks ("), except when the data item contains a comma (,). For example, when the data item to be imported is AB,CD, it must be coded as "AB,CD".

Tip
  • When a certain asset does not have any assets associated with it, you can simply leave the second and subsequent columns beside it in the CSV file blank.

  • When a certain asset is associated with multiple assets, use one row to describe each association.

  • When you have multiple rows to describe the multiple assets with which a certain asset can be associated, any rows among them that do not show an associated asset will be treated as invalid data.

Hardware asset -> Device

The association shown at the top of the list in the CSV file corresponds to the representative device.

One asset number can be associated with multiple host IDs.

Column position in the CSV file

Item

Format of Data

1

Asset #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Host ID

Numerics, uppercase letters, and the following signs, with 64 or less characters:

hash mark (#), hyphen (-), and period (.)

Hardware asset -> Hardware asset

One asset number can be associated with multiple other asset numbers. Hardware assets to be associated with the main hardware asset must have asset numbers that are different from the one assigned to the main asset.

Column position in the CSV file

Item

Format of Data

1

Asset #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Asset #

Hardware asset -> Contract

One asset number can be associated with multiple contract numbers. You cannot specify the contract numbers corresponding to the contracts associated with software licenses.

Column position in the CSV file

Item

Format of Data

1

Asset #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Contract #

Software license -> Managed software

One license number can be associated with only one managed software name.

Column position in the CSV file

Item

Format of Data

1

License #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Managed Software Name

A character string with 512 or less characters

Software license -> License to be upgraded

One license number can be associated with only one license number corresponding to the software license to be upgraded.

You cannot specify a license number corresponding to a software license that meets any one of the conditions described below. You can check detailed information regarding each software license by displaying the Software Licenses view in the Assets module or by exporting the same data. If the software license in question meets any of the following conditions, specify a different license number and then proceed to associate that license number with the license number corresponding to the software license to be upgraded.

Column position in the CSV file

Item

Format of Data

1

License #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

License # to be upgraded

Software license -> Device

One license number can be associated with multiple host IDs. You cannot specify the host IDs of detected devices.

Column position in the CSV file

Item

Format of Data

1

License #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Host ID

Numerics, uppercase letters, and the following signs, with 64 or less characters:

hash mark (#), hyphen (-), and period (.)

Software license -> Contract

One license number can be associated with only one contract number. You cannot specify a contract number corresponding to the contract associated with a hardware asset.

Column position in the CSV file

Item

Format of Data

1

License #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Contract #

Managed software -> Software

One managed software name can be associated with multiple software names. You can specify software names and product IDs that have not been registered in the database. You cannot specify a product ID when Full-product version is specified as the purchasing status.

Column position in the CSV file

Item

Format of Data

1

Managed Software Name

A character string with 512 or less characters

2

Software Name

A character string with 512 or less characters

3

Purchasing Status

Either one of the following values:

  • Volume license version

  • Full-product version

4

Product ID

A string of no more than 64 ASCII characters that does not include control characters.

The specifiable combinations of Software Name, Purchasing Status, and Product ID are as follows:

Managed software -> Software license

One managed software name can be associated with multiple license numbers.

Column position in the CSV file

Item

Format of Data

1

Managed Software Name

A character string with 512 or less characters

2

License #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

Contract -> Hardware asset

One contract number can be associated with multiple asset numbers. A contract associated with a software license cannot be associated with hardware assets.

Column position in the CSV file

Item

Format of Data

1

Contract #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Asset #

Contract -> Software license

One contract number can be associated with multiple license numbers. A contract associated with hardware assets cannot be associated with software licenses.

Column position in the CSV file

Item

Format of Data

1

Contract #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

License #

Contract -> Contract vendor list

One contract number can be associated with only one contract vendor name.

Column position in the CSV file

Item

Format of Data

1

Contract #

Alphanumerics with 32 or less characters, and the following signs:

exclamation mark (!), double quotation mark ("), hash mark (#), dollar sign ($), percent sign (%), ampersand (&), single quotation mark ('), left parenthesis ((), right parenthesis ()), asterisk (*), plus sign (+), comma (,), hyphen (-), period (.), slash (/), colon (:), semicolon (;), left angle bracket (<), equal sign (=), right angle bracket (>), question mark (?), at mark (@), left square bracket ([), backslash (\), right square bracket (]), caret (^), underscore (_), grave accent mark (`), left curly bracket ({), vertical bar (|), right curly bracket (}), and swung dash (~)

2

Contract Vendor Name

A character string with 256 or less characters

CSV file coding example

Shown below is an example of how to code the "Hardware asset -> Contract" associations in a CSV file. Specifically, the example below describes the following associations:

AssetNo001, ContractNo001
AssetNo002,
AssetNo003, ContractNo003
AssetNo003, ContractNo004