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



          • Related Articles

          • 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

            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 ...
          • Unable to merge or delete requests/ Unable to take a backup in new instance

            Issue: Cannot merge or delete requests. Also, cannot take backup in a new instance with data. Cause: Any of these issues may occur due to orphan entries present in DB. i.e. when we delete a service category in CMDB, it actually gets removed from UI ...
          • Subject Alternative Name missing Error under Browser (SAN Missing)

            Error : Solution: Please find below the commands that can be used to create the keystore and corresponding CSR request with SAN included: Keystore creation:  keytool -genkey -alias <your_alias_name> or [Domain Name] -keyalg RSA -keysize 2048 -sigalg ...
          • What is Data Archiving ?

            Data Archiving is a process where requests will be moved to the archived state (archived requests) and will be removed from the active requests list. In the database perspective, It will be just moved from workorder table to arc_workorder table in ...