1. Display the number of service requests submitted during a month. Categorize the numbers by service name.

• Sign in as a system administrator.
• Go to the Report page and click New Chart 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.

• Sign in as a system administrator.
• Go to the Report page and click New Matrix 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.

• Sign in as a system administrator.
• Go to the Report page and click New Matrix 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.

• Sign in as a system administrator.
• Go to the Report page and click New Matrix Report.
• Select “Service” from the Matrix Row 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) < 2 in the SQL Where box.
• Click the Run button to run the report.

5. Service level agreement violation report.

• Sign in as a system administrator.
• Go to the Report page and click New Matrix Report.
• Select “Service” from the Matrix row.
• Select the status that indicates request having been closed. By default, it is the “Closed” status.
• Type DATEDIFF(minute, sr_close_due, sr_closed_on) > 1 in the SQL Where box.
• Click the Run button to run the report.