Last modified: 2014-09-22 10:49:35 UTC

Wikimedia Bugzilla is closed!

Wikimedia migrated from Bugzilla to Phabricator. Bug reports are handled in Wikimedia Phabricator.
This static website is read-only and for historical purposes. It is not possible to log in and except for displaying bug reports and their history, links might be broken. See T63745, the corresponding Phabricator task for complete and up-to-date bug report information.
Bug 61745 - Create additional dynamic (and auto) report for OTRS tickets locked to closed agents
Create additional dynamic (and auto) report for OTRS tickets locked to closed...
Status: RESOLVED WORKSFORME
Product: Wikimedia
Classification: Unclassified
OTRS (Other open bugs)
wmf-deployment
All All
: Normal enhancement (vote)
: ---
Assigned To: Nobody - You can work on this!
:
Depends on:
Blocks:
  Show dependency treegraph
 
Reported: 2014-02-21 12:04 UTC by Ryan (Rjd0060)
Modified: 2014-09-22 10:49 UTC (History)
5 users (show)

See Also:
Web browser: ---
Mobile Platform: ---
Assignee Huggle Beta Tester: ---


Attachments

Description Ryan (Rjd0060) 2014-02-21 12:04:21 UTC
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.
Comment 1 Patrik (pajz) 2014-09-02 12:00:08 UTC
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)
Comment 2 Andre Klapper 2014-09-22 10:49:35 UTC
Closing per comment 1

Note You need to log in before you can comment on or make changes to this bug.


Navigation
Links