Exporting and filtering tables

All views under Views > All Views displayed in the TrueSight Capacity Optimization console contain tables that display metric and other information for each view category.

You can export, filter and classify the data displayed in each of these tables as per your requirement with the help of various data filters and controls. These controls are built-in with each view and enable you to customize the output and display of information.

 For more information, refer to the following sections:

To export a table

1. Click the appropriate icon in the control to export a table to any of the following file formats:

   Icon	Format
   	Microsoft Excel .XLS
   	Comma-separated .CSV
   	.HTML markup
   	.XML markup

2. You can choose to Open or Save the table.[format] file from the dialog box that pops-up.
   table is the default file name for the format you are exporting to.

To go back to the topic you were on, use your browser's Back button.

To filter domains

1. Click on the Domain Filter tab.
2. Click on the sign on the control.
3. Click the domain you want to filter on from the domain tree view that appears.
   Your current view is now refreshed, and displays details for the selected domain.

To go back to the topic you were on, use your browser's Back button.

To clear the current domain filter

• Click on the Domain Filter tab.
  Your table is refreshed, shows zero results, and a No domain selected label is displayed on the Domain Filter domain name box.

To go back to the topic you were on, use your browser's Back button.

To search for a domain to filter on

1. Click on the Domain Filter tab.
2. Click on the box.
   1. Type the first few characters of the domain name you want to search for.
   2. If the string you entered is found, a dynamic search results list appears.
3. Click on the name of your domain from the search results list.
   Your table is refreshed, and displays details for the searched host.

To go back to the topic you were on, use your browser's Back button.

To show or hide columns in a table

You can use the show/hide cols control located towards the top right side of a table to add columns to, or remove columns from a table.

To do this:

1. Click show/hide cols.
2. Select or clear the check-box against the name of the column you want to show in, or hide from the table.
3. Click Apply.
   The table is refreshed, and displays columns as per your selection.

To go back to the topic you were on, use your browser's Back button.

To filter individual columns in a table using filter operators

1. Click the sign located towards the bottom right side of the column header of the column you want to filter.

2. Select your operator from the Operator list:

   Operator	Meaning and usage
   like	The LIKE operator. For example, Server NameLIKEbcopun
   =	The equals operator. For example, CPU Cores= 4
   !=	The not equals operator. For example, Unused Cores != 1
   >	The greater-than operator. For example, CPU Utilization %> 87
   <	The less-than operator. For example, Physical Cores< 3
   empty	The empty operator. It filters out cells in the selected column that are empty, and do not hold any value in them
   not empty	The not empty operator. It filters out cells in the selected column that are not empty, and do hold a value in them

3. Enter the filter value in the value box located next to the Operator list.
4. Press Enter.
   • If you are filtering a size-based column, such as, Disk Space [GB], Unused Mem [GB], you will see a Size list next to the value box to make a unit of measure (KB, MB, GB) selection.
     In this scenario, you have the following choices to apply the filter:
     • Enter the filter value in the value box, select a unit of measure, and then click the icon.
     • Enter the filter value in the value box, select a unit of measure, click on the value box again (to focus), and then press Enter.
       
       The table is now filtered according to the filter criteria you have specified.

To go back to the topic you were on, use your browser's Back button.

To clear the filter operator criteria from individual columns

1. Click the sign located towards the bottom right side of the column header of the column (or columns) you just applied the filter operator criterion on.
   
   The filter operator criteria is removed, the table is refreshed and reverts to default view.