Query Reports

Query Reports

Role Required: Technicians with Add access to reports.
Query reports are predefined reports generated using an SQL query. They display data in a tabular format. You can customize query reports only for date and time columns, like Created Time, Completed Time, Scheduled Start, and Scheduled End.

To generate a query report,
  1. Go to the Reports module and click Query Reports.
  2. Go to your preferred report folder and open a report.



To generate a custom query report, click on a report in the list view.
  1. In the Edit Query Report pop-up, select a Filter By criteria from the following options: Created Time, Completed Time, Scheduled Start, Scheduled End.
  2. Choose a preferred time to generate the report or specify a time.
  3. Finally, click Save or Save and Run Report.  
 

    • Related Articles

    • Overview - Reports

      AssetExplorer Cloud allows you to generate various reports across modules. You can use predefined reports or generate custom reports as required. To generate or view reports, go to the Reports module. Filter the reports per customers by using the ...
    • Schedule Reports

      Role Required: SDAdmin, SDReport, Technicians with View access to reports Schedule report settings allow you to automatically generate multiple reports at a scheduled time. These reports can be generated in PDF, XLS, XLSX, HTML, Inline HTML, or CSV ...
    • Email Reports

      Role Required: SDAdmin, SDReport, Technicians with View access to reports. To email a report, Go to the Reports module and open a report. Click Mail this Report displayed at the top. Choose your preferred Format for the report. The available formats ...
    • Export and Print Reports

      Export Reports Role Required: SDAdmin, SDReport, Technicians with View access to reports. To export a report, Go to the Reports module. Click the Export as drop-down on the top right. Choose the export file type from the drop-down. You can export the ...
    • Edit and Save Reports

      Edit Reports Role Required: SDAdmin, SDReport, Technicians with Edit access to reports. To edit a report, Go to the Reports module and open a report you want to edit. Click Edit on the top-left. Alternatively, you can also click against the report ...