Can not Find who set watcher

RT Users
1

hello everyone

I have a ticket and I want to know who set watcher on that ticket. in some tickets from history, I can see who set watcher but in my ticket I cann’t.

I tried to use database to find out who is the actor but I found nothing. can you guide me through this?

thanks in advance

2

Hi Dornaz

Give the following a go, as a start (mysql)

SELECT ObjectId, Creator FROM Transactions WHERE Type='AddWatcher’;

regards
Garry

1 Like
3

Dear G.Booth

many thanks for your help