Setting Page Columns Display
  • 15 Feb 2024
  • 10 Minutes to read
  • Dark
    Light
  • PDF

Setting Page Columns Display

  • Dark
    Light
  • PDF

Article Summary

Your system comes with a set of predefined columns in each asset table. You can edit this predefined set and configure the columns which are displayed on the page. When you export tables to CSV files, the columns in the CSV file are ordered like in the table.

The column view is set on each asset page separately and displays columns appropriate for that asset.

You can save columns in sets of Views that you can load as required, see Saved Views

DeviceWithColumnsEdit1

Setting Page Columns Display

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

Changing Columns Displayed

To change the displayed columns

  1. Click Edit Columns and from the drop-down menu, select Edit Columns:

EditColumnsNEw

  1. In the Available Columns pane, from the adapter drop-down,elect the adapter from which you want to select columns.
    Columnadapter

  2. 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.

Note:

It is not reccomended 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 then click Remove.
  2. You can also change the order that the columns appear by moving them up or down in the Displayed Columns pane.
  3. Click Reset to cancel any changes that you made to the column display, and return to the default view.
  4. Click Save when you have finished your configuration. To save a view as your default view, refer to Saved Views.

Click Reset above the search bar to reset the asset page to your default column view with no filtering and display all assets.

Note:
Queries can be saved with the columns in the Displayed Columns pane even when no query expression has been defined. These saved queries can then be loaded and used as a template for building new saved queries with 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.

Freezing the Columns Displayed

You can freeze the columns displayed on the Assets pages. This means that when you scroll horizontally, the frozen columns are always visible.
A frozen column has a lock icon in its header; an unfrozen column has an unlock icon.
By default, the Adapter Connections column is always displayed (frozen) when you scroll horizontally.

Freezing Columns from an Asset Page

To freeze the columns displayed

  1. Mouse over a column heading.

LockIcon

  1. Click the unlock icon on the column. All the columns up to and including the selected column are frozen (closed lock icon).

Freezing Columns using Edit Columns

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

  1. Click Edit Columns and from the drop-down menu select Edit Columns.

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

  3. Mouse over the column name to see the lock/unlock icon.

  4. Click the icon to set the column name to be locked. The column, and all of the columns listed above are then frozen.

  5. Click Apply. If you have chosen too many columns the system informs you that you have chosen too many columns to properly display the Asset Table. You should either change your screen resolution, or select fewer columns.

ColumnsEditLock2

Note:

To unfreeze, drag the column header out of the frozen (shaded area). Or click the unlock icon to unfreeze a column and all the columns below it.

Saved Views

Views are the arrangement of columns displayed in the Asset tables. Use Saved Views to create views most relevant for specific use cases.

Using Views you can define a set of columns as a "View" and save it. You can make a collection of Saved Views for Asset Table columns to easily switch to the view that is most convenient for you. You can easily change the table view and thus see fields most relevant to you. You can define a different set of views for each asset type. Each user can create their own set of Views, however, users cannot share a view.

Creating a New View

To create a new view:

  1. Select Edit Columns

  2. From Saved Views select + New View;
    AddNEwView

  3. The New View dialog opens. Enter a name for your view. If you don't add a name for the View you can't save it.
    ColumnsNewView

  4. From the Available Columns pane select the columns you want, and use Add to move them to the Displayed Columns pane.

Note:

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

  1. Use Remove to remove columns from the Displayed Columns pane. Note that the columns available change according to the adapter you select.
  2. Refer to Setting Page Column Display to learn more
  3. You can drag the columns up and down to change the order in which you want to display them.
  4. If you want, you can toggle on Set as Default to make this view the default.
  5. Save the View.

Once you save the view, the system notifies you that the view was saved, and it is loaded.
On each Asset page you can select a View and set it as default.

Note:

The view is only saved to the Asset Type it was created from.

Loading a View

  1. From Edit Columns, mouse over Saved Views, all available views for this asset are listed.
    ViewsLoadingView

  2. From the list that opens, click the view you want to load.

Note that System Default view is the default set of columns that Axonius provides for this asset. You can set any view that you want as your own default view. Once you set a view as deafult, this is the view that loads each time you open this specific asset table.

Edit View

  1. From Edit Columns hover over Saved Views.

  2. From the View you want select the 3-dot menu and choose Edit , the Edit View dialog opens.
    SSavedViews3DotMenu

  3. Edit the View as required and choose Save, the edited view is loaded.

Deleting a view

  1. From the Edit columns mouse over Saved Views

  2. From the View you want select the 3-dot menu and choose Delete. The system asks you to confirm your choice, and the view is deleted.

    • Once you delete a view, if you deleted your default view the System Default view becomes the default view for that specific asset page. Note that you can't delete the System Default view.
    • If you deleted a view, the current column view continues to be displayed, but that arrangement is no longer saved as a view.

Making a View the Default View

The system comes with a System Default View. You can set any view as your own Default View. The default view is the view displayed when you open an asset table. You can set a default view for each asset table.

  1. From Edit Columns select Saved Views.
  2. From the View you want select the 3-dot menu and choose Set as Default.
    SetAsDefaultinColumnView

Changing the System View

The system comes with a System Default View for each asset type. This is the View (column arrangement) that any user sees on each asset page the first time they use the system and the view that will be displayed if a user does not create, or removes, all their own custom views. An admin user can edit the System View. This creates a new System View for all users.

  1. From Edit Columns select Saved Views.

  2. From the System View, select the 3-dot menu and choose Edit.
    EditSystemViewColoumns

  3. Edit the System View as required, note that you can't rename the view.

  4. Select Change. The System View is now updated for all users of your system.

Additional Pre-defined Views

Axonius supplies various column arrangements for Search for speficic parametres
these include refer to System Search Default to set the columns to be displayed in system searches. Refer to Free Text Search in Table.

  • System search (Host Name) (Default)
  • System search (Last Used Users) (Default)
  • System search (IP Address) (Default)
  • System search (Installed Software Name) (Default)

Refining the Data Displayed in Table Columns and Rows

You can use complex expressions to refine the display in asset pages in order to be able to zoom in on precisely the information that interests you to see. You can use the following types of data refinement:

  • Refine field values by condition
  • Refine field values by adapter connection
  • Refine Asset entities by condition
  • Refine Asset entities by adapter connection

Data refinement does not impact the 'Count' of the results, only the results that are displayed.

On the right of each field, click Filtericon.png to open the Refine Data Display dialog.

RefineDateDisplay

Once you configure data refinement:

  • This sets the columns and rows displayed in the queries that you create.
  • This sets the way CSV export is displayed, including report or enforcement actions that export data as CSV files.
  • An enforcement set configured with a dynamic value statement runs only on query results filtered according to the data refinement configuration. This is the case for queries filtered with all data refinement options, except "Refine field values by adapter connection".
Note:

An enforcement set that is not configured with a dynamic value statement runs on all assets, as data refinement does not remove assets from the query.

Refine Field Values by Condition

You can use complex expressions to create sophisticated filters to refine the display and search for specific values to be displayed in each table column on the page, including multi-field columns. Open the Field values - refine by condition pane. This acts as a sophisticated column filter. Use the parameters below to set conditions as required.

FieldValues_condition

Each row in the Field values - refine by condition pane is a filter expression that consists of the following elements:

  1. AND / OR switch
  2. NOT Flag
  3. Field drop-down
  4. Operator drop-down
  5. Value field
  6. Parentheses controls

Refer to the Query Wizard for detailed explanations of each field and the parameters it can contain.

Note the following: Field Name Drop-Down The field name drop-down shows the column on which you are filtering. The options available depend on the column on which you are filtering. If this is a complex field, all of the values that are part of the complex field are displayed and you can choose the field by which to filter. If for instance, you filter on the Installed Software column, the field drop-down contains a range of possible values to filter by.

ColumFilterSW

When complex filters are defined, Axonius will display only values that match the complete filter.

Refining Field Values by Adapter Connection

You can configure the system to not show values from a specific adapter connection, that is from specific adapters or from connections for a defined adapter, in a selected column. Only values from adapters which are not excluded will be displayed in that column.

  1. Open Field values - refine by adapter connection.
  2. Click in the Exclude values from adapter connections field; all adapters connected and their connections are displayed.

ColumFilterAdapter

  1. Start typing to search for a specific adapter or connection name, then select the adapter or connection that you want to exclude values from.

  2. Click next to the adapter to choose all connections for the adapter; or choose specific connections.

  3. Choose as many adapters or connections as required and click in the Refine Data Display dialog to close this drop-down..

Use Select All or Clear All to change your selections.


Refining Asset Entities by Condition

Use Asset entities - refine by condition to refine the contents of the asset entity that are displayed according to the rows, for instance, you can hide a row, an asset entity, which contains a Software Version with a specific value.

  1. Open Asset entities - refine by condition

AssetEntitybyConditin

  1. Create a filter as explained in Refine Field Values by Condition

Refining Asset Entities by Adapter Connection

Use Asset entities - refine by adapter connection to not show asset entities from a specific adapter connection, that is from specific adapters or from connections for a defined adapter,
In this way you can hide a row, an asset entity, if it comes from a specific adapter, or adapter connection. An asset without any asset entities might be completely hidden.

  1. Open Asset entities - refine by adapter connection
  2. Create a filter as explained in Refining Field Values by Adapter Connection.



Was this article helpful?

Changing your password will log you out immediately. Use the new password to log back in.
First name must have atleast 2 characters. Numbers and special characters are not allowed.
Last name must have atleast 1 characters. Numbers and special characters are not allowed.
Enter a valid email
Enter a valid password
Your profile has been successfully updated.