Asset Data Chart

The Asset Data chart allows you to visualize asset field values with each asset displayed as a row in a table or an individual asset card. You can view data for all assets of a particular type, or you can filter the data using a new or saved query.

Visualization Options

You can select to display the asset data in Table or Card view.

Table View

The Table view generates a table to display the data according to the query and fields you select. If you select a saved query, the table's columns will be the same as those used in the query.

Card View

In the Card view, each asset is presented as a separate card. You can choose as many fields as you want. The cards change size to accommodate the number of fields or allow for scrolling within each card.

If the cards you create contain only one field, the cards display the field values without the label, so make sure the chart's title clearly describes the data represented by the field values. If the field includes just a single value, the text is displayed in a larger size to emphasize it in your dashboard. This is especially relevant for dashboards that analyze a single asset.

Refine Data

You can refine the data displayed in the chart for both Table and Card views, with refinements applied separately for each field, just as you can refine data on Asset pages. When you refine data, the query's asset count remains the same, even though Assets containing certain values do not appear on the chart.

When you click from the Dashboard to the relevant asset page, the configured refinement is applied to the asset page. However, when you refine data in a saved query and use it as the base query in the chart configuration, the chart does not automatically apply that refinement to its displayed data.

Create or Edit the Asset Data Chart

You can create or edit the Asset Data chart in the Chart wizard.

To configure an Asset Data chart:

1. In the Chart title text box, enter a title for the chart.
2. (Optional) In the Description text box, you can add a description.
3. From the Widget list, select Asset Data.
4. In the Visualization area, select Table or Cards.
5. Under Select Query, select an asset type module and a query from the Query list.
   When an asset module is selected, but no query is selected, values are displayed for all assets of the selected module.
   The fields section shows the default fields for the chart, based on the selected asset or the saved query.
6. (Optional) To add a filter to the query, click the Filter icon and configure the filter(s) you want.
7. (Optional) To change a field displayed in the chart, in the Fields section, select aggregated data or an adapter, and the field you want to appear.
8. (Optional) To add fields to this chart, click the Add button and select the fields you want to display.
9. (Optional) To refine the values displayed for a field, click the Filter icon corresponding to that field and configure the refinement in the dialog that appears.
10. (Optional) To set the sorting by a specific field click the Sorting icon next to that field. Click it again to change if the assets are sorted in ascending or descending order for that field's values.

12. (Optional) To reset the field list to the default for the selected query, click Reset to Query.

13. (Optional) To reset the field list to the default for the selected asset, click Reset to Asset.

14. (Optional) Set the chart to display results from a relative or fixed historical date. See Viewing Query Results from a Historical Date.

15. (Optional) To split rows with multiple values for complex tables so each value is displayed in its own row, enable the Split by complex table option and select the table you want to split. Any time that complex table contains multiple values, a separate row is created for that value.
    

16. Click Save to save the configuration and add the chart to the dashboard.

The Table visualization is based on the assets tables, meaning any asset table functionality will apply.

Click on the asset link at the bottom of the page to view the Asset summary for the displayed assets. Click the Asset Page to view the assets at their relevant Asset page.

Opening an Asset from the Chart

Use a row or a card in the chart to go from the dashboard to an asset profile.

Permissions: You need the Dashboards > View permission and the permission to view the asset type, for example devices. Without it, rows and cards aren't clickable.

To open an asset profile:

1. Open a dashboard that has an Asset Data chart.
2. Click a row of the table, or click a card. The asset profile opens in a new browser tab.

To open a card with the keyboard, press Tab to move the focus to the card, and then press Enter.

• The pointer changes to a hand when rows or cards are clickable.
• A click doesn't open the profile when you click a link or another control inside the row or card, click in a pop-up that opened from the row or card, or select text in the row or card.
• Rows and cards aren't clickable in the chart preview, in reports, on asset profile dashboards, or when chart click-through is off. They also aren't clickable for modules that have no asset profile, for example Activity Logs.
• View all results in the chart footer still opens the full asset table with the chart query.

A cell that the assets table shows as a link is also a link in the Table view. Examples are Device Count on Aggregated Security Findings or Software, and a CVE ID. Click the link to open the matching assets in a new browser tab. The link doesn't appear when the value is 0, when the chart shows a past date, in the chart preview, in reports, on asset profile dashboards, or when chart click-through is off.

Example: A dashboard has the Asset Data chart "Servers without an EDR agent". Click the row of one server. The profile of that server opens in a new tab, and you can see its adapters and fields.

Aligning Columns

Use alignment to set a column in the Table view to the left, center, or right.

Permissions: To add or edit a chart, you need the Dashboards > Charts > Add or Dashboards > Charts > Edit permission. If you open the chart with View Configuration, the Edit Field popover is read-only.

To align a column:

1. Add an Asset Data chart, or edit one. In Widget, select Asset Data, and in Visualization, select Table.
2. Select the module and the query, and add the fields you want.
3. In the Fields section, click the pencil icon next to a field. The Edit Field popover opens.
4. In Alignment, select Left, Center, or Right.
5. (Optional) In Field Display Name, enter a custom column header.
6. Click Apply.
7. Click Save.

• Left is the default. Fields that you don't change stay left-aligned.
• The alignment applies to the column header and to the cells of that field.
• The alignment applies to the Table view only. The Cards view doesn't use it.
• Apply is enabled after you change a value.
• Clear all sets the display name and the alignment back to their defaults. Click Apply after Clear all to keep the change.
• The pencil icon changes when the field has a custom display name or an alignment other than Left.

Example: An Asset Data table on Devices shows Host Name and Last Seen. Set Alignment to Right for Last Seen. The Last Seen header and dates align to the right, and Host Name stays left-aligned.

Coloring Cells by Rules

Use cell color rules to highlight the cells of a column in the Table view that match a value, for example all Windows devices.

Permissions: To add or edit a chart, you need the Dashboards > Charts > Add or Dashboards > Charts > Edit permission. If you open the chart with View Configuration, you can open the Cell colors popover only when the field has rules, and the rules are read-only.

To add cell color rules:

1. Add an Asset Data chart, or edit one. In Widget, select Asset Data, and in Visualization, select Table.
2. Select the module and the query, and add the fields you want.
3. In the Fields section, click the palette icon (Cell colors) next to a field. The Cell colors popover opens with one empty rule.
4. From the condition list, select Equals, Contains, Greater than, or Less than.
5. In Value, enter the value to match.
6. Click the color box and select a palette color or a custom color.
7. (Optional) To add another rule, click Add rule.
8. Click Apply.
9. Click Save.

• Each field can have up to 5 rules. Add rule is disabled when the field has 5 rules.
• A cell gets the color of the first rule that its value matches. The order of the rules in the popover is the order that Axonius checks.
• Equals and Contains compare text and ignore uppercase and lowercase letters and spaces before and after the value. Equals compares numbers as numbers when the cell value and the rule value are both numbers, so 7 matches 7.0.
• Greater than and Less than compare numbers only. A text value never matches these conditions.
• A cell with many values gets the color when any one of its values matches.
• The rule color is the cell background. The text color changes to a light or dark color so that the text stays readable.
• Value holds up to 200 characters. Axonius removes a rule with an empty value when you click Apply.
• To remove a rule, click Remove next to it, and then click Apply.
• The cell colors apply to the Table view only. The Cards view doesn't use them.

Example: An Asset Data table on Devices shows Host Name and OS: Type. For OS: Type, add the rule Equals "windows" with a red color. The cells that contain Windows get a red background. The Linux cells and the Host Name cells don't change.

Resizing Columns

Use column resizing to set the width of the columns in the Table view.

Permissions: Every user can resize a column on the dashboard. Axonius saves the widths only for users who can edit the chart. For other users, the widths last until they leave the page.

To resize a column:

1. Open a dashboard that has an Asset Data chart in the Table view.
2. Drag the right border of a column header to the width you want.
3. Release the border.

• Saved widths also apply in report PDFs.
• You can't resize columns in the chart preview of the chart configuration.
• Charts without saved widths keep their default widths.

Hiding the Total Count

Use Show total calculation to hide the total number of assets in the chart footer. When you disable this option, the footer shows only the number of displayed rows or cards, for example "Displays 10" in place of "Displays 10 out of 4,853". See Hiding the Total Asset Count.

Showing Asset Investigation Events

Use an Asset Data chart to list the field change events of a saved Asset Investigation query on a dashboard.

Permissions: To add or edit a chart, you need the Dashboards > Charts > Add or Dashboards > Charts > Edit permission. You also need the Asset Investigation > View permission to select the module and its saved queries. A user inside a data scope sees an empty chart.

To show Asset Investigation events:

1. On the Asset Investigation page of an asset type, save a query that selects the field change events you want. See Asset Investigation.
2. On a dashboard, click Add Chart.
3. In Widget, select Asset Data.
4. Select the module Asset Investigation - , for example Asset Investigation - Devices, and select the saved query.
5. Select the columns: Date, Asset, Field Name, Event Type, Values Added, Values Removed, and Adapters Connections.
6. (Optional) To sort the events, sort by Date.
7. Click Save.

• The chart lists events, not assets. The latest events appear first by default. An empty query selects all the events.
• Only the Date column can be sorted. The other columns show "Sorting not available".
• The chart always shows the current events. The Query Wizard, historical date, net change, and Refine Data aren't available for these modules.
• When you click a row, the Asset Investigation page opens with the filters of the saved query.

Example: Save an Asset Investigation query "OS changes, last 7 days" on Devices. Add an Asset Data chart on this query with the columns Date, Asset, Field Name, Values Added, and Values Removed.