Sorting a table in the TrueSight console

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

On some pages, you can show or hide columns in the tables, and also sort the columns based on the available sorting options. For detailed information, see the following sections:

Related topics

Accessing-and-navigating-the-TrueSight-console

Setting-up-and-using-the-Investigate-tool

Using-views-to-analyze-infrastructure-and-virtual-data

To show/hide columns in a table

  1. Click the action menu action_menu.png next to the table title, and click Show/Hide columns.

  2. In the Show/Hide Columns window, select the check box corresponding to the name of the column that you want to display. The column moves under the Selected metrics section. To hide the column, click x.
    view_showhidecols.png

  3. Click Save.
    The table is refreshed and displays the columns as per your selection.

    Notes

    • The sorting preferences are user-specific.
    • Sorting preferences are stored when you log out and log in again.

Sorting options in tables

You can sort columns in tables alphabetically, or by size. You can also use the available filter options to sort columns.

Refer to the following image to see the the different sorting options available for tables:

views_sort_tables.png

1- Sorting options for sorting the column by size, or alphabetically, in case of columns that show values in text format.

For columns that show values in text format, you can sort alphabetically from A to Z or Z to A.

2 - List that displays predefined conditions that you can select from. The conditions differ, depending on whether the column value is in text or numerical format.

For the selected condition, type a corresponding value in the Value box.

3 - Short column description

You can remove the applied sorting by using the Clear sorting option. This option is displayed only if a column is sorted by using any of the available options.

clearsorting.png

To sort columns in tables

In this example, the Capacity tab in the vSphere Infrastructure view displays a table which is not sorted.

sort_columns_before.png

To sort it by the CPU utilization size, perform the following task:

  1. Click the CPU Util [% ] column name.

  2. In the pop-up menu, click the option by which you want to sort the column.
    sort_columns_description.png

    Information

    A short column description is also displayed in the pop-up menu.

  3. The column updates with the selected sorting option. The column also displays an arrowhead icon, denoting that the column is sorted.
    sort_columns_after.png

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*