Importing annotation values

If you maintain annotations on SAN objects (such as storage, hosts, and virtual machines) in a CSV file, you can import that information into OnCommand Insight. You can import applications, business entities, or annotations such as tier and building.

About this task

The following rules apply:
The following object types and keys are supported in the import utility:
Type Key
Host id-><id> or <Name> or <IP>
VM id-><id> or <Name>
Storage pool id-><id> or <Storage_name>-><Storage_Pool_name>
Internal volume id-><id> or <Storage_name>-><Internal_volume_name>
Volume id-><id> or <Storage_name>-><Volume_name>
Storage id-><id> or <Name> or <IP>
Switch id-><id> or <Name> or <IP>
Port id-><id> or <WWN>
Share id-><id> or <Storage Name>-><Internal Volume Name>-><Share Name>-><Protocol> [-><Qtree Name >]

<Qtree> is optional if there is a default qtree.

Qtree id-><id> or <Storage Name>-><Internal Volume Name>-><Qtree Name>

The CSV file should use the following format:

, , <Annotation Type> [, <Annotation Type> ...]
[, Application] [, Tenant] [, Line_Of_Business] [,
Business_Unit] [, Project]

<Object Type Value 1>, <Object Key 1>, <Annotation Value> [,
<Annotation Value> ...] [, <Application>] [, <Tenant>] [,
<Line_Of_Business>] [, <Business_Unit>] [, <Project>]

...

<Object Type Value N>, <Object Key N>, <Annotation Value> [,
<Annotation Value> ...] [, <Application>] [, <Tenant>] [,
<Line_Of_Business>] [, <Business_Unit>] [, <Project>]

Steps

  1. Log in to the Insight web UI.
  2. Click Admin and select Troubleshooting.
    The Troubleshooting page displays.
  3. In the Other tasks section of the page, click the OnCommand Insight Portal link.
  4. Click Insight Connect API.
  5. Log in to the portal.
  6. Click Annotation Import Utility.
  7. Save the .zip file, unzip it, and read the readme.txt file for additional information and samples.
  8. Place the CSV file in same folder as the .zip file.
  9. In the command line window, enter the following:
    java -jar rest-import-utility.jar [-uusername] [-ppassword]
    [-aserver name or IP address] [-bbatch size] [-ccase sensitive:true/false]
    [-lextra logging:true/false] csv filename

    The -l option, which enables extra logging, and the -c option, which enables case sensitivity, are set to false by default. Therefore, you must specify them only when you want to use the features.

    Note: There are no spaces between the options and their values.

    Note: The following keywords are reserved and prevent users from specifying them as annotation names:
    • Application
    • Application_Priority
    • Tenant
    • Line_Of_Business
    • Business_Unit
    • Project

    Errors are generated if you attempt to import an annotation type using one of the reserved keywords. If you have created annotation names using these keywords, you must modify them so that the import utility tool can work correctly.