Table Of Contents
Using Cisco ANA Manage Tables
Working With Cisco ANA Manage Tables
Finding Text In a Table
Filtering Information
Setting Selection Filters
Sorting a Table
Exporting the Table To a File
Using Cisco ANA Manage Tables
This chapter describes how to perform general Cisco ANA Manage functions when working with tables:
•
Working With Cisco ANA Manage Tables—Describes how to work with tables, including finding information, opening filters and exporting table information.
•
Finding Text In a Table—Describes how to sort a table by defining specific criterion.
•
Filtering Information—Describes how to define a filter for the data displayed in the workspace. In addition, it describes how to choose lines and set specific selection filters.
•
Setting Selection Filters—Describes how to choose a line or specific set of lines, and display them in the table.
•
Sorting a Table—Describes how to sort tables by defining specific criteria.
•
Exporting the Table To a File—Describes how to export all the currently displayed data from the workspace to a CSV file.
All these functions are performed using the Cisco ANA Manage table toolbar.
Working With Cisco ANA Manage Tables
Various tables are used throughout the application to display different types of information. Cisco ANA Manage enables the administrator to perform the following functions using the toolbar displayed above the table in the workspace:
•
Find text in a table.
•
Define a filter in a table.
•
Clear a defined filter from a table.
•
Choose lines and set a selection filter in a table.
•
Undo the previous selection filter in a table.
•
Undo all selection filters.
•
Sort the table according to a column.
•
Export table information.
•
Finding specific information in Cisco ANA Manage tables.
You can also find specific Cisco ANA Manage information, such as Cisco ANA units, AVM/VNE details using Find and entering criteria into the Find dialog box. For more information, see Finding an AVM or VNE, page 6-6.
For more information about the table toolbar, see Table Toolbar, page 2-6.
Finding Text In a Table
Cisco ANA Manage enables you to search for information in the workspace by entering the search criteria, for example, by entering a partial username.
Note
The tools displayed in the table are a generic component of Cisco ANA applications.
To find text in a table:
Step 1
In the table toolbar, enter the search criteria in the Find field.
Step 2
Press Enter. The row matching the search criteria is highlighted in the table.
Note
Click F3 to continue searching the table.
Filtering Information
Cisco ANA Manage enables you to define a filter for the data displayed in the workspace according to a selected column. For example, in the Users branch, information can be filtered according to username.
To define a filter:
Step 1
In the table toolbar, click Filter. The Filter dialog box is displayed.
The following lists are displayed in the Filter dialog box:
•
Field—Displays a list of all the columns displayed in the current table.
•
Operator—Displays a list of the values included in the filter operation.
The following checkbox is displayed in the Filter dialog box:
•
Not—Choose this checkbox to filter the negative of the value in the Operator field. For example, if the Not checkbox was selected in the Filter dialog box, the filter operator would be the equivalent of "does not contain".
The following free text area is displayed in the Filter dialog box:
•
Search for—Enter the required filter value.
Step 2
Choose an option from the Field and Operator lists.
Step 3
Enter the required filter values in the Search for field.
Step 4
Click OK. The information is displayed in the workspace using the defined filter.
Note
The Filter button toggles to indicate that a filter has been applied.
The filter can be cleared in order to display all the data in the table again.
To clear a filter:
Step 1
On the toolbar, click Filter. The Filter dialog box is displayed.
Step 2
Click Clear. The workspace displays all the data.
Note
Use the Clear filter option to clear ALL the filter settings. See
Setting Selection Filters.
Setting Selection Filters
You can choose a line or specific set of lines, and display them in the table (all un-selected lines are hidden). You may make continuous multiple line selections, setting the table content after each selection using Set Selection Filter.
You can undo the last line selections (one step back), one at a time, using Previous Selection Filter, or undo (rewind) all multiple line selections, using the Rewind All menu option.
This filtering mechanism enables you sort though several hundred lines and pinpoint the appropriate lines that contain the required information. For example, you could filter and display seven lines in a 129 line database segment table:
To choose multiple lines and apply the set selection filter:
Step 1
Choose the lines in a Cisco ANA Manage table. The Set Selection Filter button is activated.
Step 2
Click Set Selection Filter. Only the selected lines remain in the table.
To undo the previous filter selection:
Step 1
Choose one or several lines and filter them out using the appropriate table toolbar buttons.
Step 2
To undo the last filtering out selection, click Previous Selection Filter. The table will display all lines that appeared before your last filter selection.
To undo all previous selected filter out options:
Step 1
Choose, filter out and sort lines as required in the table using the appropriate table toolbar buttons, such as Previous Selection Filter.
Step 2
Click Previous Selection. The Rewind All menu option is displayed:
Step 3
Choose Rewind All. All the lines in the table are displayed.
Tip
To clear all manually selected and defined filter options, use Clear in the Filter dialog box. SeeFiltering Information.
Sorting a Table
The tables displayed in Cisco ANA Manage can be sorted by defining specific criteria on a one-time only basis or continuously.
To sort a table:
Step 1
On the toolbar, click Sort. The Sort dialog box is displayed.
Figure 4-1 Sort Dialog Box
The following dropdown lists are displayed in the Sort By area:
•
Sort By—A list of all the columns displayed in the currently displayed table. The table is sorted firstly according to the selection made here. Choose ascending or descending order.
•
Then By—Lists all the columns displayed in the table. The table is sorted secondly and then lastly according to the selections made here. Choose ascending or descending order.
The following buttons are displayed in the Sort Operation area:
•
Once Only—Sorts the information displayed in the table according to the specified criteria once only. When this option is selected a triangle is displayed in the table heading for the selected column.
•
Continuously/Repeatedly—Sorts the information displayed in the table according to the specified criteria continuously. When this option is selected the
icon is displayed next to the selected column heading.
Step 2
Choose an option from the Sort By list and Ascending or Descending order.
Step 3
Choose an option from the Then By lists and Ascending or Descending order (optional).
Step 4
Choose Once Only or Continuously/Repeatedly.
Step 5
Click OK. The table information is sorted according to the filter defined.
Exporting the Table To a File
Cisco ANA Manage enables you to export all the currently displayed data from the workspace to a CSV (comma separated values) file. The selected rows are exported; when nothing is selected the entire table is exported. The data can then be imported and viewed at a later stage.
Note
This tool occurs throughout the application with the same functionality.
To export the table to a file:
Step 1
In the table toolbar, click Export to CSV. The Export Table To File dialog box is displayed.
Step 2
Browse to the directory where you want to save the table.
Step 3
In the File name field, enter a name for the table.
Step 4
Click Save. The table or selected rows is saved in the selected directory.