Skip to content Skip to site navigation Skip to service navigation

Ad Hoc Endpoint Compliance Reports

You can create your ad hoc reports using all of the tables and columns in the device registry.

Using the ad hoc analysis tool

  1. Go to
  2. To create a new query, click New > Analysis from the menu bar at the top.  Click Open to access an analysis you have previously saved.

    create new ad hoc report
  3. When prompted to select a subject area, click Endpoint Compliance.
  4. The folders displayed on the left represent the tables available.   Expand one or more  of these folders to view the available columns.
  5. Double-click the columns to add them to the query.
  6. Once added, you can drag and drop columns to reorder them.
  7. To add search criteria, click the menu icon to the right of the column name and click Filter.

    select a column to filter
  8. A New Filter dialog box displays. Enter your filter criteria, by either typing in a value, using the down arrow to display the list of values, or clicking the Search icon.  Click OK.

    enter filter criteria in New Filter dialog box
  9. Your search criteria now appears in the Filters section of the screen. Hover your cursor over the filter name to access the controls to edit, copy, paste, or delete the filter.

    controls to edit, copy, paste, and delete filter
  10.  When you are finished creating your analysis, save it by clicking the Save Analysis save icon or Save As save as icon icon in the upper-right corner of the window. Save the analysis in My Folders
  11. To run your report, click the Results tab in the upper-left area of the window.

    click the Results tab to run a report

Tips for using the Endpoint Compliance data

  1. The unique key to a device is  an internal Device Id, which is found only in the Fact Device folder.  Always include this column on your analysis so that each row is unique by device.

  2. If the analysis you create includes feeds from multiple days, include a selection for Reporting Date from the Fact Device folder (usually today's date).

    subject area folders

Last modified August 3, 2015