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
-
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."
- 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.
-
The license type differs between the upgrade license and the software license to be upgraded.
-
The upgrade license is identical to the software license to be upgraded.
-
The number of the software licenses to be upgraded is fewer than the total number of upgrade licenses.
-
The license to be upgraded is a limited license, whereas the upgrade license is an unlimited license.
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:
|
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:
-
Software Name: software-name, Purchasing Status: blank, Product ID: blank
-
Software Name: software-name, Purchasing Status: purchasing-status, Product ID: blank
-
Software Name: software-name, Purchasing Status: purchasing-status, Product ID: product-ID
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:
-
Asset number AssetNo001 that is associated with contract number ContractNo001
-
Asset number AssetNo002 that is associated with none of the contract numbers
-
• Asset number AssetNo003 that is associated with contract numbers ContractNo003 and ContractNo004
AssetNo001, ContractNo001 AssetNo002, AssetNo003, ContractNo003 AssetNo003, ContractNo004