Querying history of Servicedesk from database using T-SQL in SQL Server

Querying history of Servicedesk from database using T-SQL in SQL Server

HI Team

We use ManageEngine Servicedesk as our ticketing tool.

I want to get a report out of the service desk in which I need to know any request on which I have ever worked upon.

Whenever a request is assigned to us or we forward it to other group, each activity is stored in database and is available under history tab of the request.

Can you please let me know what is the name of this history tab table in database and which columns are used to store information of technician who worked on the request.

For Example:

1) a new request is created by User A and assigned to user B.
2) User B worked on the request and assigned it back to the creator User A.
3) User A closed the ticket.

Now I want to know this ticket number in report on which User B have ever worked.


Can you please let me know if this can be done and let me know if you need any more information from my side or the query is clear to you.


Regards
Rohit Malik

                  New to ADSelfService Plus?