Viewing Query History
  • 25 Oct 2021
  • 2 Minutes to read
  • Dark
    Light
  • PDF

Viewing Query History

  • Dark
    Light
  • PDF

Click on Query History to open the Query History page
The Query History page shows information about queries the users run on the system. It doesn't show automatic processes that run queries such as the Dashboard or the Enforcement Center.

QueryHistoryN.png

The following information is displayed

  • Query Name – The name of the query. For saved queries, the name that it was saved under. For queries that were not saved, the query name is displayed as 'Unsaved query'.

  • Start Time – the time it started to run.

  • End Time – the time it finished running.

  • Duration - The time it took the query to run.

  • Run by - The name of the user who ran the query: The user name is displayed with a prefix:

    • Internal - A user defined internally in Axonius by one of the system admins.
    • SAML or LDAP - A user who logged in using the LDAP or SAML based login options.
  • Run from – The way the query was run. The following options can appear:

    • Devices - Run from the Devices page
    • Users – Run from the Users page
    • API - Run using API
    • Export CSV – When the query involves exporting a CSV, in this case the start and end time are the time it took to export the CSV
  • Tags – Tags which are applied to the query

  • # Results - The number of assets (aggregated assets) returned from the query. For Export CSV this is the number returned when exporting the CSV. For instance, if you choose "Split by asset entity" in Export CSV or limit the number of rows for the CSV there will be a different number of results than in the original query.

  • Status – The status of the query. The following status are available:

    • In Progress – the query is still being run.
    • Completed – the query has finished running
    • Cancelled – the query was cancelled by running another query before it finished running
    • Failed – the query failed to run because there was a failure in the system.

Filtering Queries

Use the Filter at the top of the page to filter the list of users displayed.

QueryHistoryFilteRN.png

  • Query name - Choose a Query name from the drop down list of queries.
  • Run by - Select User names from the drop-down.
  • Tags - Choose Tags from the drop-down. This can help locate queries by tags.
  • Run start date - Run end date - You can filter for specific run date, by clicking the date range picker filter.
    * Select two dates to set the date range for which queries run will be displayed.
    * To filter activity logs only for a specific date, select the same date twice.
    * Click Select Time in the date range picker to include specific times in the date range.
    * Click OK to set the date range filter
    image.png


  • Use 'Clear all' to clear all of your selections in a specific filter.

Click Reset to clear the filters.



What's Next
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.