Skip to content

Web Application - Admin User Manuals

Scheduling and Downloading Service Request Report

4 min readUpdated

  1. In the Main Menu, under the ADMIN OPTIONS, in the Service Request subsection, click Service Requests.
    ‎The Service Requests tab opens by default.
  2. 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.
  3. 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.

  4. Click Refresh to refresh the list of request IDs.
  5. 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. 
Was this page helpful?