- In the Main Menu, under the ADMIN OPTIONS, in the Service Request subsection, click Service Requests.
The Service Requests tab opens by default. - Click Schedule Service Requests Report Download.
A Request ID for Service Request Report Download is generated and the report is available for download under the Scheduled Report tab. - Click the Scheduled Report tab.
A list of request IDs are displayed.Note: You can also access the Scheduled Report tab from the main menu by navigating to ADMIN OPTIONS > Service Request > Scheduled Report.
- Click Refresh to refresh the list of request IDs.
- Under the Action column for your request ID, click Download.
The service request report is downloaded and includes the following information:- Report Sheet: provides a comprehensive overview of service requests, including request details,assignment, timelines, escalations, and resolution tracking.
- Change History Sheet: provides a log of status updates for service requests along with the user, time, and comments for each action.
- Summary Sheet: provides a summary of service request counts by status including total, open, acknowledged, resolved, and so on.
The Report sheet displays the following information:
| Column | Description |
|---|---|
|
Service Request Id |
Displays the service request Id. |
| Resource Type |
Displays the type of resource for which the service request is raised. For example, asset. |
|
Resource Name |
Displays the name of the resource for which the service request is raised. For example, keyboard. |
|
Location |
Displays the location where the service request is raised. For example, Pune. |
|
Service Type |
Displays the service type selected when raising the service request. For example, Servicing. |
|
Sub Service Type |
Displays the service type selected when raising the service request. For example, Repairing. |
|
Additional Info Reference |
Displays a link to a corresponding row in another sheet within the Excel file. This additional sheet is generated only if the service request has an associated form and contains the questions and responses submitted by the user when raising the request. Each form has its own dedicated sheet, as the questions are unique to that form. |
|
Tags |
Displays any tags associated with the service request. |
|
Title |
Displays the title of the service request. |
|
Priority |
Displays the priority level of the service request. |
|
Status |
Displays the status of the service request. |
|
Created By Name |
Displays the name of the user who created the service request. |
|
Created By Email |
Displays the email id of the user who created the service request. |
|
Assigned To Name |
Displays the name of the user the service request is assigned to. |
|
Assigned To Email |
Displays the email id of the user the service request is assigned to. |
|
Created On |
Displays the date and time when the service request was created. |
|
Last Updated On |
Displays the date and time when the service request was last updated. |
|
Repeat Flags |
Displays the number of times the same service request was triggered (Applicable to service requests triggered automatically through digital checklists). |
|
Digital Checklist |
Displays the name of the digital checklist that triggered the service request. |
|
Acknowledgement At |
Displays the date and time at which the service request was acknowledged. |
|
Acknowledgement Escalation Time |
Displays the date and time at which the acknowledgement escalation was raised. |
|
Time to Acknowledgement (in minutes) |
Displays the time it took to acknowledge the service request. |
|
Resolution At |
Displays the date and time at which the service request was resolved. |
|
Resolution Escalation Time |
Displays the date and time at which the resolution escalation was raised. |
|
Time to Resolution (in minutes) |
Displays the time it took to resolve the service request. |
|
Escalation Paused Until |
Displays the time until which the repeated escalation of the issue is paused. |
The Change History sheet displays the following information:
| Column | Description |
|---|---|
|
Service Request Id |
Displays the service request Id. |
| Status |
Displays the status of the service request. |
|
Action By |
Displays the name of the user who updated the service request status. |
|
Action At |
Displays the date and time at which the service request status was updated. |
|
Comment |
Displays any comments added by the user who updated the service request status. |
The Summary sheet displays the following information:
| Column | Description |
|---|---|
|
Total |
Displays the total number of service requests. |
| Open |
Displays the total number of service requests that are open. |
|
Acknowledged |
Displays the total number of service requests that are acknowledged. |
|
Acknowledgement Delay |
Displays the total number of service requests where there was a delay in acknowledgement. |
|
Resolved |
Displays the total number of service requests that are resolved. |
|
Resolution Delay |
Displays the total number of service requests where there was a delay in resolution. |
|
Approval Pending |
Displays the total number of service requests where the approval is pending. |
|
Rejected |
Displays the total number of service requests that were rejected. |
|
Cancelled |
Displays the total number of service requests that were cancelled. |

