nService3 reports
Using nService3’s report builder, you can create many
reports with just a few mouse. Here are some examples.
1. Display the number of service requests submitted during a
month. Categorize the numbers by service name.
- Log on
as a system administrator.
- Go to
the Report page and click New Report.
- Select
“Service” from the Category list.
- Select
the “This Month” from the Submitted On list.
- Click
the Run button to run the report.
2. Display the number of service requests closed during a
month. Categorize the numbers by service name.
- Log on
as a system administrator.
- Go to
the Report page and click New Report.
- Select
“Service” from the Category list.
- Select
the “This Month” from the Closed On list.
- Click
the Run button to run the report.
3. Display the number of service requests that are opened
for less than 30 days, from 30 to 59 days, from 60 to 89 days and more than 90
days. Categorize the numbers by service name.
- Log on
as a system administrator.
- Go to
the Report page and click New Report.
- Select
“Service” from the Category list
- Select
“Age 30x4” from the Series list
- Select
the statuses that indicate the requests are still open. By default, it is
the “Open” status.
- Click
the Run button to run the report.
4. Display the numbers of service requests that are closed
within 2 hours. Categorize the numbers by service name.
- Log on
as a system administrator.
- Go to
the Report page and click New Report.
- Select
“Service” from the Category list.
- Select
the status that indicates request having been closed. By default, it is
the “Closed” status.
- Type DATEDIFF(hour, sr_submitted_on,
sr_closed_on) in the SQL Where box.
- Click
the Run button to run the report.
5. Average tier 2 resolution time
- Log on
as a system administrator.
- Go to
the Report page and click New Report.
- Select
“Aggregate” from the report type list.
- Enter
aggregate functions:
count(*), avg(datediff(minute, sr_escalated_on,
sr_closed_on))
- Enter
aggregate labels:
Number of request escalated,
Average tier 2 resolution time in minutes
- Enter
SQL Where: sr_escalated_on IS NOT NULL
- Click
the Run button to run the report.
Sample screen:

6. Average service request resolution time for the current
year.
- Log on
as a system administrator.
- Go to
the Report page and click New Report.
- Select
“Aggregate” from the report type list.
- Enter
aggregate functions:
avg(datediff(hour,
sr_submitted_on, sr_closed_on))
- Enter
aggregate labels:
Average request resolution time
- Select
“This Year” from Closed On list
- Click
the Run button to run the report.