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.

Setting Page Columns Display

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.

2. In the Available Columns pane, select an adapter from the dropdown menu to view its available columns. (This step applies to Assets pages only.)

3. 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:

And the same field expanded:

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.

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.

4. To remove columns from the page, select the required columns in the Displayed Columns list and click Remove.
5. 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.
6. To cancel any changes that you made to the column display and return to the default view, click Reset.
7. 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.

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

In Edit Columns, you can give a column a custom display name. Axonius saves the display name with the query.

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.