Page MenuHomePhabricator

Create additional dynamic (and auto) report for OTRS tickets locked to closed agents
Closed, DeclinedPublic

Description

A while ago, to address the issue of the admins constantly having to poke ops to run queries for agent activity report, an automatically-updating list was made available (to OTRS admins) at https://ticket.wikimedia.org/otrs/idle_agent_report.

One more common request we ask for is a query for all tickets that are locked, but belong to invalid (closed) accounts. If this could be incorporated into the above link - would probably need a page title change - (or a new page is created specifically for this) that would be helpful to us. Should help ops as we won't need to poke anybody regularly to ask for this report.


Version: wmf-deployment
Severity: enhancement

Details

Reference
bz61745

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 22 2014, 3:00 AM
bzimport added a project: Znuny.
bzimport set Reference to bz61745.
bzimport added a subscriber: Unknown Object (MLST).

I suggest to close this bug. The requested report can be generated by OTRS admins via OTRS' SQL box. The syntax is at https://otrs-wiki.wikimedia.org/wiki/Queries/Locked_to_closed_accounts#Queries (works under 3.2)