Query Reports

Role Required: SDAdmin

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.  
   

 

 

  Data for query reports will not be scoped to the customer selected in the filter in the header.

• Related Articles

• Overview - Reports

  ServiceDesk Plus MSP 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 ...

• Predefined Reports

  ServiceDesk Plus MSP Cloud provides predefined reports to view information instantly. Predefined reports can also be edited to fine-tune the data as needed. Role Required: SDAdmin, SDReport, Technicians with View access to reports, Account Manager ...

• Schedule Reports

  Role Required: SDAdmin, SDReport, Technicians with View access to reports, Account Manager and Point of Contact of customers with View Reports access. Schedule report settings allow you to automatically generate multiple reports at a scheduled time. ...

• Email Reports

  Role Required: SDAdmin, SDReport, Technicians with View access to reports, Account Manager and Point of Contact of customers with View Reports access To email a report, Go to the Reports module and open a report. Click Mail this Report displayed at ...

• Custom Reports

  You can create customized reports to meet the unique needs of your organization. Role Required: SDAdmin, SDReport, Technicians with Add access to reports, Account Manager and Point of Contact of customers with View Reports access. To create a custom ...