Query Reports

Query Reports

SupportCenter Plus enables users to generate query reports to fetch information from the database. To create a query report,

  • Go Reports. This opens the All Reports page.

  • Click New Query Report. This opens the Query Editor page.

  • Select the Table Schema from the combo box say,  requests, timespent and so on. Click to view the table schema for the selected option.

  • Specify the Report Title. This is a mandatory field.

  • Specify the query to be executed for getting reports in the Query field. This is a mandatory field.

  • The logs will display all error messages on providing any wrong query.

  • Click Run Report to run query report.

 

Tips

  • Date Formulae: DATE_FORMAT (FROM_UNIXTIME (COLUMN_NAME/1000),'%d-%m-%Y %k: %i') 'Column Alias'.

  • Minutes Formulae: ROUND ((((COLUMN_NAME/1000)/60)) % 60) 'Minutes'.

  • Hours Formulae: ROUND (((COLUMN_NAME/1000)/3600)) 'Hours'.

  • Compare Date: COLUMN_NAME >= (UNIX_TIMESTAMP (DATE ('2006-07-24 00:00:00')) * 1000).

  • Convert Memory in GB: ((((MEMORY_COLUMN)/1024)/1024)/1024)

  • Default Value For Null Data: COALESCE (COLUMN_NAME, 'Unassigned')

  • Group by: Query statement will be ends with order by <column_index>

 

Additional Field tables

  • Request Additional Fields - WorkOrder_Fields

  • Contact Additional Fields - Contact_Fields

  • Support Rep Additional Fields - Support_Rep_Fields


    • Related Articles

    • Generating Reports

      Reports help you have a detailed overview of the organization's work done in a specified duration. In SupportCenter Plus, you can generate a report in two ways: Using a pre-defined report Configuring a custom report Using Pre-defined Reports To view ...
    • Scheduled Reports

      To generate a Scheduled Report, Click Reports>>New Schedule Report. This opens Schedule report settings page. To generate report once, Click Generate Once radio button. Specify the Date and Time on which the report has to be generated using the combo ...
    • Custom Reports

      SupportCenter Plus enables you to create reports that suit your business needs. To create a custom report, Go to Reports and click New Custom Report. Choose the request type. You can create Tabular Reports and Matrix Reports. Choose the module for ...
    • Pre-defined Reports

      SupportCenter Plus provides you with pre-defined reports that can be classified as Accounts, Request, and Request Timespent reports. Support Reps with administrator privilege and complete access permission over Reports module can edit these ...
    • Survey Reports (User Survey)

      You can view reports for an individual request survey or multiple surveys. To view aggregate results of surveys, Go to Admin>>User Survey>>Survey Reports. Select from the following filters and click Apply Filter. Survey's publishing period Survey ...