Key Task: Analyze Device Inventory (Advanced)

Use the Analyze Device Inventory dashboard to gather information about the inventory of devices in your organization which have an Agent for End User Devices locally deployed. The advanced dashboard allows customizing the layout and data in the dashboard.

For example, you can create a dashboard that displays multiple device attributes, such as model, number of CPU cores and memory size, and show their distribution across your business locations.

If the data you need for your investigation is not available in the non-advanced Analyze dashboard, use the Advanced version to design your own layout, by customizing and displaying only the data which you need.

The Analyze Device Inventory (Advanced) dashboard

There are endless ways you can use the data from this dashboard to check almost anything you want to investigate.

Tip

You can also view and analyze this data using the DEVICE_INVENTORY REST API. (Learn more).

Procedure

  1. Step 1 Open a browser and sign in to Aternity.
  2. Step 2 Select Main Menu > Inventory > Analyze Device Inventory (Advanced).
    Access the Analyze Device Inventory (Advanced) dashboard
  3. Step 3 Customize the dashboard by adding columns, rows, and your own fields with custom calculations.
    Note

    If you saved this dashboard for later viewing, it opens the main sheet (only) in view mode. To further customize (if you have permission), select Edit.

    For example, you can add a column showing the device name to this dashboard by dragging Model from the Measures section of the side bar to the Columns row at the top of the screen.

    Add attribute columns to your advanced dashboard

    Continue to add columns until the data you require for analysis is displayed. For example, add number of CPU cores and memory size to Columns and business location to Rows.

    Create your customized inventory analysis dashboard

    For more information on the full editing capabilities of this dashboard, see http://www.tableau.com/learn/training. View the following training sections:

    • Visual Analytics

    • Calculations

    • Tableau Server

    • How To

  4. Step 4 You can create a custom group for an attribute in any of the advanced Analyze dashboards, from data in Excel (like a CSV file).

    For example, you can create two custom groups to compare their measurements.

    Use CSV data to create a custom group
    1. a Copy the values you want for the group from a CSV file in Excel.

      For example, if you have a CSV file of device names from the device inventory API, choose the names you want as a group and copy them to the clipboard.

    2. b Display the attribute of your group in the dashboard by dragging it from the left pane to the top bar.

      For example, to display rows of hostnames in this dashboard, drag Client Device Name from the left pane to the Rows bar at the top.

      Drag the attribute to the top bar and show its filter
    3. c To display a filter of this value in the right pane of the dashboard, hover over the attribute, open its drop-down menu, and select Show Filter.
      Choose Show filter from the drop-down menu
    4. d To display only the values from your CSV file, change the filter in the right-hand bar by opening its drop-down menu and selecting Multiple values (custom list).

      This displays only several specific values in the dashboard.

      In this example, to display only the specific hostnames from your CSV file, in the right hand bar, select Client Device Name > Multiple values (custom list).

      Display only specific values in the dashboard
    5. e To display only the items from your CSV file, paste them into the filter field.
      Paste your data into the filter field
    6. f Create a group by selecting the group members, then in the pop-up select the group icon .
      Select items and create a group

      It creates a custom group as a new object in the left sidebar. You can now use it as part of your analysis like any other object.

    7. g To create a second custom group for comparison with your first group, select Clear List to clear the first group's data from the filter, and repeat the process.

      Paste a second set in the filter field to display them, select them in the dashboard, then group them.

      Clear the data from the filter
    8. h Clear the filter and now paste both lists into the filter so you can see all values from both groups in the dashboard.

      This displays all members of the groups in their respective groups so you can compare them side by side.

      View a comparison of two custom groups