Hi,

I would like you, not to quote unnecessary information in your mails.
Thanks.

13.11.2016 12:46 - OTRS Ziege schrieb:

> my Goal is to get a list of all unanwsered (by an Agent) and unlocked tickets.

> I think i have to do it with an Database Query.

> But thats the step I need some help.

You can use the built in search function or the stats module.
Search options are "state = new" and "unlocked" for example.

regards,

--
Florian