How to query unlocked Tickets with unanswered customer request

Hi Folks, first of all, thanks evryone in advance how can help me.

My Situation is, that i have round about 200 open and new Tickets.
Not all of them are locked by an Agent.

Now I want ot have an overview off all unlocked Tickets where the customer
have done some request to the ticket.
For example.
A customer sends an request to our OTRS-System. But this request will not
get locked by an Agent. Because there is so much work
And after a while the same customer will send to the same ticket a request
to get to know the state of work.
But now one answer to him. And after a while he send the third request to
the same tickets....and so one.


Perhaps this could be done by a datanbase query. Hase anyone some
experinece with that.

Thanks a lot
Bye Marvin

---------------------------------------------------------------------
OTRS mailing list: otrs - Webpage: http://otrs.org/
Archive: http://lists.otrs.org/pipermail/otrs
To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs