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 ...

• Generate Audit Reports

  Generate custom reports of audits under Reports > New Custom Report. You can generate reports of single audits or combine multiple audits into a single report. Use the filters to customize your report as preferred.

• 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 ...