Table of Contents

Configuring GQI queries for Data Aggregator

Important

After configuring GQI queries for Data Aggregator, a one-time migration process using the Data Aggregator Migrator is required when upgrading from version 2.x.x to 3.0.0 or higher.

Every GQI query you want to execute must be saved in a separate file in JSON format.

To get a correctly configured query, you can make use of the DataMiner Dashboards app:

  1. In the DataMiner Dashboards app, create a dashboard, and then create a query.

  2. Visualize this query on the dashboard, for example using the Table component.

  3. Press F12 to open the developer tools and go to the Network tab.

  4. Press F5 to refresh the dashboard.

  5. In the Name column of the Network tab, select the OpenQuerySession network call.

  6. Go to the Payload subtab, and copy the value of query and connection by right-clicking these and selecting Copy value.

    Developer tools Network tab

  7. Convert the query using the ConvertQueryToProtoJson web method:

    POST https://dataminer.company.local/API/v1/Internal.asmx/ConvertQueryToProtoJson

    Note

    Replace dataminer.company.local with the hostname or IP address of your DataMiner Agent.

    with payload:

    {
  "connection": "", // copied in previous step
  "query": {} // copied in previous step
}

  8. From the received response, copy the value of d:.

    The copied value is a JSON-wrapped JSON string.

  9. Unwrap the JSON string by replacing all instances of \" with ", and all instances of \\ with \.

  10. Paste the copied JSON code into a new file and save it as a .json file.

  11. Add the path to this file to the Data Aggregator configuration file. See GQI queries.

Propose changes