Request missing

Request missing

Use case: In some cases, requests are missing. We would get the ID number from acknowledgement notification but we cannot find that in the tickets. In such cases, please follow below steps to find out the details.

1. Make sure to check the Request List View with All Account & All Requests filters. 

2. Global Search 




2. We can check the query in the database to find the ticket. Go to Reports Tab >> New Query Report and run the below queries one by one

Check the ID Active Requests

Select * from workorder where workorderid='123'

Check the ID Archived Requests

Select * from arc_workorder where workorderid='123'

Check if the ticket is merged

Execute the query in the below link as per the database you are using. You can find DB info from Help->About.


Replace 123 with the Request ID in question. 

3. If it's not available in any report, check if the request is deleted. Under Community tab (headphone icon) next to Reports Tab >> Click on System Log Viewer >> Enable search and use the below filter to trace the logs



                  New to ADSelfService Plus?

                    • Related Articles

                    • Merge Similar Requests

                      Requirement: In an organization, multiple requests being created for the same issue. So we will have to merge all the similar requests. UseCase: Assume there is a printer issue in an organization, and a request has already been registered for the ...
                    • Script to Auto merge requests with exact same subject

                      Use case: Too many alerts for the same reason from a machine keeps generating multiple tickets in SDP MSP. You can use the below script to auto-merge the requests in the application. The Merged tickets description will be added as a note to the ...
                    • Script: Auto merge tickets of similar subject and auto closes the ticket--> Used V1 API dont use

                      Use case:   Too many alerts for the same reason from a machine keeps generating multiple tickets in SDP MSP.  You can use the below script to auto-merge the requests and auto close the ticket. What does this script do ? The Merged tickets description ...
                    • Merged request

                      To make any changes to a query, refer to the KB article below. https://pitstop.manageengine.com/support/manageengine/ShowHomePage.do#Solutions/dv/24000633501275 MSSQL SELECT Workorderid "Parent Request", (SELECT STUFF( (SELECT cast(Child_woid AS ...
                    • Request Merge API using Postman.

                      Currently, the Merge API is not included in our documentation. However, I have tested the following API in Postman, and it is working fine on our end. API used: /api/v3/requests/<request_id>/merge_requests {"merge_requests":[{"id":"1"},{"id":"2"}]} ...