Setting Page Columns Display

Your system includes predefined columns for each Assets table, as well as the Adapter Connections and Adapter Fetch History pages. You can change those default displays and customize which columns appear on each page in which order. When you export tables to CSV files, the column order in the exported file matches the table display order.

Each Assets page maintains its own column configuration, displaying only columns relevant to that specific asset type.

You can save columns in sets of Views that you can load as required. See Saved Views for more information.

EditTbleMenu2.png

Setting Page Columns Display

Note

Applies to Assets tables, Adapter Connections page and Adapters Fetch History page.

You can set the columns displayed on the page, change their order, or pin specific columns so that they are not scrolled.

To change the displayed columns:

  1. Click Edit Table, then select Edit Columns from the dropdown menu.
EditColumnsNEw2.png
  1. In the Available Columns pane, select an adapter from the dropdown menu to view its available columns. (This step applies to Assets pages only.)
  1. To add columns to the page, select the required columns in the Available Columns list and then click Add. Columns available depend on the adapter you select. Note that Custom Data is also an option in the adapter list.

The Available Columns list is hierarchical, like the Query Wizard. The sub-fields of a complex field are indented under it, behind a chevron, and nested complex fields go one level deeper. Complex fields start collapsed. Search lists every matching field, including sub-fields, in a flat list.

See for example the Direct Connected Devices complex field, collapsed:

ComplexFieldCollapsed

And the same field expanded:

ComplexFieldExpanded

When you click Select All at the bottom of the Available Columns list, it selects what the list shows. Therefore, on a collapsed list display, it adds all sub-fields displayed to the table. If you want to add only specific sub-fields, select them manually.

Hover over complex fields with long names to see their full names.

Complex Fields in Available Columns and Displayed Columns

Both lists show a complex field as a tree:

  • When a complex field is in Displayed Columns, Available Columns shows it as a gray, disabled parent row. Its sub-fields that aren't displayed appear under this row, with their short titles (for example, MAC under Network Interfaces).

  • When a sub-field of a complex field is displayed but the complex field itself isn't, Displayed Columns shows the complex field as a gray parent row above its sub-fields.

  • The gray row is collapsed by default. Click the arrow at its left to show or hide its sub-fields. You can't add the gray row itself.

  • When you remove a sub-field from Displayed Columns, it returns under the gray row in Available Columns.

Selecting Complex Fields and Sub-Fields

  • Selecting a complex field selects only that field. Its sub-fields don't change. Clearing a complex field clears only that field; its selected sub-fields stay selected. The checkbox of a complex field shows only its own state.
  • When some of its sub-fields are selected, the number of selected sub-fields appears after the field name (for example, 2 of 5). The count includes sub-fields at all levels, and doesn't include the complex field itself.
  • To add a complex field together with only some of its sub-fields, select the complex field and each sub-field that you want, then click Add. For example, to add Installed Software with Software Name, Software Vendor, and Software Version, select these four rows and click Add.
  • To select a complex field with all of its sub-fields, search for the field and click Select All. Select All also selects the sub-fields of a closed complex field.
  • Shift+click selects a range of the rows that the list shows. When a complex field is collapsed, the range skips its sub-fields.

The selection behavior is the same in New View and, under Available Fields, in the asset profile's Edit Fields Display dialog.

Added Columns Behavior

  • Added columns appear right after the last pinned column. When no columns are pinned, they appear from the second position and the existing columns shift down.
  • The asset profile's Edit Fields Display and the Saved Queries page still append columns at the end.
  • Columns that you add in one Add action go in as one contiguous block, in the Available Columns order. The new rows are briefly highlighted, and Displayed Columns scrolls to the insertion point when it's out of view. This applies to Edit Columns on all Assets tables, including New View and Edit View.
πŸ“˜

Note

It is not recommended to add more than 50 columns to a table, as this may affect optimal table behavior.

  1. To remove columns from the page, select the required columns in the Displayed Columns list and click Remove.
  2. To change the order in which the columns appear, move them up or down in the Displayed Columns pane. To move several columns together, select them and move them as a group to the top, up, down, or to the bottom. Alt+Up and Alt+Down also move the selected columns.
  3. To cancel any changes that you made to the column display and return to the default view, click Reset.
  4. Click Save when you finish your configuration. To save a view as your default view, see Saved Views.

To return to your default column view and clear all filters, click Clear query above the search bar.

Note

On Assets pages, you can save queries with the columns in the Displayed Columns pane even when no query expression has been defined. Then, you can load these saved queries and use them as a template for building new saved queries that include the predefined columns and column filters.

Changing the Order Columns are Displayed

You can change the order of columns in tables in the system directly from the table. Drag and drop columns on the table to arrange them in the order you want. Use Edit Columns to save your changes.

Removing a Column from Its Header

On Assets pages, remove a column directly from the table. Hover over the column header and click Remove column. You don't need to open Edit Columns.

Setting a Custom Display Name

You can give a column a custom display name. Axonius saves the display name with the saved query.

The edited display names belong to the saved query that you saved them with. Another saved query or view does not keep them.

To edit a column display name:

  1. In the Edit Columns dialog, go to Displayed Columns.

  2. Hover over the relevant column and click the Edit icon that appears.

  3. Type the custom name and press Enter. The new name appears with the original column name in gray brackets. For example, here we changed Tags to Tag List:

  4. Click Save.

Note

When you edit a column's display name, it changes only the column header in the table of this query. The Query Wizard, CSV exports, charts, field search and the API still use the field's original name. You can rename a column only in the table's own Edit Columns dialog.

Pinning the Columns Displayed

Pin columns so you can scroll horizontally while the pinned columns are always visible. A pinned column has a black pin icon in its header; an unpinned column has a white pin icon. By default, on Assets pages, the Adapter Connections column is always displayed (pinned) when you scroll horizontally.

To pin columns from an Assets/Adapter Connections/Fetch History page, hover over a column heading and click on the pin icon.

All the columns up to and including the selected column are pinned (black pin icon). In the following example, all columns up to Host Name are pinned - see the difference between the pinned headers (circled in red) and the unpinned headers (circled in green):

You can also pin the column display using the Edit Columns dialog. Any pinned columns are displayed at the top of the Displayed Columns pane, in a shaded area.

  1. Click Edit Table, then select Edit Columns from the dropdown menu.

  2. Drag the field you want to set to pin near to the top of the Displayed Column pane.

  3. Hover over the column name to see the pin icon next to it.

  4. Click the icon to set the column name to be pinned. This column and all columns above it are then pinned.

  5. Click Apply.

On Assets pages, the system informs you if you choose too many columns to properly display the Assets table. In that case, either change your screen resolution or select fewer columns.

To unpin a column, drag the column header out of the pinned (shaded) area, or click the pin icon again to unpin this column and all columns below it.

ColumnsEditLock2


Did this page help you?