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