Add an instances table

You can add an instance table to a Microsoft Excel worksheet and work with the information using Microsoft Excel features. Once you have added a table to the worksheet, you can use Microsoft Excel to format, remove columns, and filter the table. The refresh maintains your modification information so that when you save or reopen a worksheet the data can be refreshed or updated.

1. Click Import Instances ().
2. Select the Model tab.
3. Enter a name for the view. This name is added to the worksheet to identify the instance view.
   Note: The name becomes the worksheet name, so if you are creating a new worksheet the name must be unique.
4. Select if you want to use a specific version of the monitor model or if you want to use all versions.
   • Show all monitor context versions shows all monitoring contexts in a monitor model.
   • Show specific monitor context versions shows each version as an additional layer in the selection tree.
   Note: The instances ID and version columns are added to the spread sheet and should not be changed. These columns are key data items that the refresh action uses when locating a row. If the these columns are removed, moved, or changed in any way the refresh action will not be able locate the row and update the data with the latest values from the IBM Business Monitor Server.
5. From the monitor model tree, select the monitor model. You can expand the models and select a monitoring context within a model if you want to narrow the scope of the data imported into the worksheet.
6. Select the columns to show or hide.
   • To show all columns, click >>.
   • To show columns, select columns in the Available list and click > to add them to the Selected list.
   • To hide all columns. click <<.
   • To hide columns, select columns in the Selected list and click < to add them to the Available list.
7. Optional: Reorder the columns by selecting a column in the Selected list and using the up () and down () buttons.
8. Review the summary at the bottom of the page to verify the selected model, model version, and monitoring context.
9. Optional: To focus the data on the instance table, add an instance filter. See Add data filters.
10. Optional: To limit the instances imported to a specific timeframe, add a time filter. See Define a time filter.
11. If you want to limit the amount of instances imported, change the number in the Maximum number of instances field on the Filters tab.
12. Click OK. If there are more then 64 instances in the results, an informational message displays letting you know how many instances are going to be imported. Click OK.
    Note: If you want to lower the number of instances imported, click cancel and return to step 11.