Online Help

Customizing data views

This article explains how to customize data views in AlloyScan to display exactly what you want to see.

A data view is a visual representation of structured data in a tabular format, such as a list of devices in the Inventory section or a list of user accounts in the Admin Center's Users section. Each row in a data view represents a single record, such as an audited device or user account, with specific details displayed across columns. Typically, data views show only a limited set of columns by default, with some hidden. You have control over how much details your data views display. Once a data view shows what you need, you can sort and filter the displayed information for quick and efficient data analysis.

Organizing columns

In a data view, each column represents a specific record field. You can show and hide columns and change their display order. Please note that adding too many columns may clutter your interface.

  1. Click Customize view in top-right corner of the data view. This action opens the Customize view dialog box with a list of all possible columns this data view can display.

  2. Every column has an eye icon associated with it, which serves as a toggle for showing or hiding the column. To determine whether a specific column should be visible or not, click on the corresponding eye icon.

    To change the display order, simply drag the columns to the desired position.

    NOTE: The top item in the list, marked by a red asterisk , is a system column. This column is fixed and cannot be hidden or rearranged.

  3. Data views for hierarchical structures, like device groups in the Inventory section, have the Apply to all subgroups checkbox in this dialog box. Keep the checkbox selected to immediately apply your view customizations to all existing subgroups.

  4. Click Save to apply and save your changes.

Sorting and filtering records

See how you can sort and filter records in a data view.

Sorting

To sort records in a data view, click on the header of a column you want to sort by and observe the arrow that appears. The up arrow indicates ascending sort order, while the down arrow indicates descending order. To change the sorting order, click the column header again.

You can only sort a data view by one column at a time.

In the screenshot on the left, the records are sorted by platform, in descending alphabetical order.

Filtering

To filter records by a column, click the filter icon in the column header. This will display a list of all unique column values in the data view. Then, select the values by which you want to filter the records.

You can filter a data view by multiple values of multiple columns. Filtered columns receive a colorful filter icon in their header.

In the screenshot on the left, the records are filtered by platform, with the Windows platform filtered out.