Ticket resolution report for Requests

31 Mar - 02 May

RT	Created	Closed	Resolution time	Client	Subject
54156	17 Mar, 15:05	31 Mar, 10:40	9.56d	Cambridge Flow Solutions	Tiger P12 certificate renewal
54286	28 Mar, 08:55	31 Mar, 11:21	1.24d	Trident Honda	Backup service
54295	28 Mar, 09:22	31 Mar, 12:22	1.30d	OpenCorporates	Pls Remove
54312	31 Mar, 13:59	31 Mar, 14:15	0.03d	Entrepreneurs Circle	IP Address Change - SFTP
53798	06 Feb, 09:58	31 Mar, 15:13	37.52d	Quickline	Out of band access
54260	26 Mar, 16:04	31 Mar, 15:44	2.97d	Internal	Indie checks for rc-mss.reigate.ac.uk
54179	20 Mar, 10:34	31 Mar, 17:22	7.68d	Internal	Switch from mlocate to plocate for debian 12/ubuntu 24.04
54268	27 Mar, 09:25	31 Mar, 17:29	2.81d	OpenCorporates	downgrade all the search1-5 from premier to business
54287	28 Mar, 09:15	01 Apr, 10:22	2.11d	Internal	I can't access Slack
54316	01 Apr, 00:00	01 Apr, 15:46	0.78d	Internal	Weekly checks
54317	01 Apr, 00:00	01 Apr, 16:06	0.81d	Internal	Purge old client password records
54238	25 Mar, 12:16	02 Apr, 12:22	6.01d	Edinburgh University	mathsgpu3
54327	02 Apr, 08:00	03 Apr, 14:50	1.68d	ITC Compliance	System uptime
54340	03 Apr, 09:02	03 Apr, 15:56	0.69d	NFW	Allias
54323	01 Apr, 12:55	03 Apr, 15:57	2.30d	Entrepreneurs Circle	Request for IP Update – inprog.entrepreneurscircle.org - Access Issue
54028	03 Mar, 16:57	03 Apr, 17:29	23.05d	Rotastat	Expiring certificate \| gallus.rotastat.com
54348	04 Apr, 00:00	04 Apr, 08:21	0.04d	Sylvera	Sylvera monthly backup check and tape swap
54345	03 Apr, 16:13	04 Apr, 08:50	0.26d	AskBio	URGENT - Encryption Keys for COLL, JURA, IONA, MULL
54355	04 Apr, 11:49	04 Apr, 14:04	0.23d	Cambridge Flow Solutions	cfsj03 node reboot
54367	07 Apr, 00:00	07 Apr, 08:59	0.10d	Ingeus	Ingeus: login to Azure
54371	07 Apr, 09:09	07 Apr, 09:17	0.01d	Edinburgh University	mathsgpu2/3
54205	21 Mar, 16:45	07 Apr, 10:09	10.34d	eTherapeutics	FW: Product Update: Upgrade to Bitnami package for PostgreSQL new version
54374	07 Apr, 11:22	07 Apr, 16:08	0.48d	AskBio	UPS beeping
54350	04 Apr, 08:34	07 Apr, 16:58	1.84d	TCV	Cron <root@mis> /usr/sbin/ntpdate-debian > /dev/null
54369	07 Apr, 07:00	07 Apr, 17:11	0.92d	Tusk IC	update user details
54294	28 Mar, 11:54	07 Apr, 17:12	6.53d	DLS Plastics	DLS potential ransomware infection
54332	02 Apr, 09:34	08 Apr, 10:35	4.10d	Internal	Update Lime Survey installation
54379	08 Apr, 00:00	08 Apr, 10:43	0.27d	Internal	Weekly checks
54385	08 Apr, 11:15	08 Apr, 11:30	0.02d	Internal	A verified domain was added to your Microsoft 365 account
54368	07 Apr, 00:00	09 Apr, 08:18	2.03d	Internal	Quarterly Ouse Failover Test
54230	25 Mar, 09:56	09 Apr, 08:44	10.88d	Visku	Maintenance window
54228	25 Mar, 09:28	09 Apr, 08:45	10.93d	ERF Electrical	Maintenance window
54227	25 Mar, 09:11	09 Apr, 08:45	10.96d	Imoves	Maintenance window
54364	07 Apr, 00:00	09 Apr, 14:05	2.61d	Internal	Monthly certificate expiry check
54394	09 Apr, 15:04	09 Apr, 16:15	0.12d	OpenCorporates	Ad hoc support requests next week
54400	09 Apr, 16:26	10 Apr, 09:02	0.26d	eTherapeutics	ETX Gitlab upgrade (17.10.4)
54399	09 Apr, 16:07	10 Apr, 09:28	0.33d	OpenCorporates	OpenCorporates Gitlab upgrade (17.10.4)
54398	09 Apr, 16:00	10 Apr, 10:06	0.41d	Geograph	Geograph Gitlab upgrade (17.10.4)
54395	09 Apr, 15:37	10 Apr, 10:25	0.48d	Internal	Gitlab upgrade (17.10.4)
54403	10 Apr, 09:07	10 Apr, 13:16	0.41d	Kahootz	Backups
54201	21 Mar, 14:04	10 Apr, 20:50	14.39d	OpenCorporates	Bot1 running slow
54375	07 Apr, 15:59	10 Apr, 21:06	3.20d	Kahootz	Expired Puppet Release Key on Golf
54377	07 Apr, 19:20	11 Apr, 00:21	3.00d	AskBio	List of Managed Servers
51406	03 Jul, 14:39	11 Apr, 09:30	197.48d	NovaData	Novadata CentOS7 EOL
54354	04 Apr, 11:44	11 Apr, 10:12	4.85d	Kahootz	Apache Logs
54404	10 Apr, 09:12	11 Apr, 11:40	1.25d	OpenCorporates	Staging Mesos
54008	27 Feb, 12:23	11 Apr, 16:48	31.44d	BD Group	Stage Server
54474	10 Apr, 14:30	11 Apr, 18:28	1.35d	Kahootz	Tomcat startup
54388	08 Apr, 15:41	14 Apr, 10:09	3.45d	AskBio	Odd tcl/Docker behaviour
54483	11 Apr, 11:25	14 Apr, 10:28	0.91d	OpenCorporates	OpenC Release
54515	14 Apr, 11:29	14 Apr, 11:36	0.01d	OpenCorporates	Openc API - Release code to pre-production environment
54387	08 Apr, 15:28	14 Apr, 11:42	3.62d	OpenCorporates	Creating an RDP snapshot of frontend Redis (10.43.15.31)
54311	31 Mar, 13:43	14 Apr, 12:02	9.83d	Sucden	Load monitoring of Interstar01-06
54134	13 Mar, 10:53	14 Apr, 12:15	22.14d	AskBio	Email from Iona and other datacentre servers
54196	21 Mar, 10:30	14 Apr, 12:32	16.20d	eTherapeutics	Remove stardrop from support
54520	14 Apr, 14:27	15 Apr, 13:05	0.86d	AskBio	/tmp cleared on Coll, Jura, Mull and Iona
54567	15 Apr, 13:56	15 Apr, 14:12	0.03d	OpenCorporates	OpenC API - PR to remove Circle CI tests and replace with GitHub Workflow
54519	14 Apr, 14:18	15 Apr, 14:13	0.99d	OpenCorporates	Openc API - GitHub repo, remove CircleCI
54559	15 Apr, 00:00	15 Apr, 14:54	0.69d	Internal	Weekly checks
53945	24 Feb, 11:02	15 Apr, 17:45	36.67d	NovaData	Novadata backup cost
54335	02 Apr, 11:29	16 Apr, 10:28	9.90d	Cambridge Flow Solutions	Ansys CFX 2024R2 not running on J cluster using slurm job scheduler
54352	04 Apr, 09:26	16 Apr, 10:32	8.11d	TCV	TCV Domains
54575	16 Apr, 10:35	16 Apr, 10:40	0.01d	OpenCorporates	OpenC - GitHub PR to deploy code to PreProd environment
54576	16 Apr, 10:46	16 Apr, 11:27	0.07d	BD Group	PEN Tests
54580	16 Apr, 15:40	16 Apr, 15:45	0.01d	OpenCorporates	OpenC - GitHub PR to deploy release 1.1.5 to Production
54239	25 Mar, 12:17	16 Apr, 16:48	16.45d	Ingeus	Fwd: Azure DevOps personal access token nearing expiration
54271	27 Mar, 10:22	16 Apr, 16:50	14.65d	Internal	Eibhlín account details (technical)
53983	24 Feb, 16:23	16 Apr, 17:48	37.14d	Internal	Test restore NetBox
54343	03 Apr, 13:17	17 Apr, 11:59	9.87d	BD Group	Server Time Configuration
54324	01 Apr, 16:09	17 Apr, 12:02	11.59d	Sucden	Onboarding of svaolmgs201
54361	06 Apr, 13:44	17 Apr, 12:11	8.42d	OGT	Create client services account for Jolyon Holdstock
54589	17 Apr, 12:01	17 Apr, 15:35	0.36d	Sucden	Indie check of svaolmgs201
54145	14 Mar, 14:29	17 Apr, 15:56	24.15d	OpenCorporates	DB Cleanup tasks
54497	11 Apr, 15:25	17 Apr, 16:00	4.06d	Sucden	FW: STAR hardware decommission
54597	22 Apr, 00:00	22 Apr, 12:10	0.42d	Internal	Weekly checks
54600	22 Apr, 11:45	22 Apr, 14:15	0.25d	Entrepreneurs Circle	Urgent Update Required: IP Address Change for New HQ
54077	06 Mar, 12:27	23 Apr, 09:09	31.67d	Sucden	Support for svaolmgs201
54382	08 Apr, 10:02	23 Apr, 09:27	8.94d	JISC	Google Cloud Armor WAF Implementation Testing
53873	13 Feb, 17:21	23 Apr, 10:13	46.29d	Entrepreneurs Circle	Introducing Usama and OpenVPN Setup Assistance
53891	17 Feb, 11:03	23 Apr, 11:08	45.01d	DLS Plastics	Email issue (not normal support question)
54608	23 Apr, 10:04	23 Apr, 16:21	0.63d	Sucden	Service Removals
54372	07 Apr, 09:10	23 Apr, 17:04	10.79d	OpenCorporates	Improve OC mysql cluster monitoring
54606	23 Apr, 08:36	24 Apr, 08:25	0.98d	JISC	OpenAthens patching
54613	24 Apr, 08:13	24 Apr, 10:08	0.19d	Internal	Gitlab upgrade (17.11.1)
54601	22 Apr, 12:29	24 Apr, 10:46	1.83d	OpenCorporates	Frontend Redis Dump
54598	22 Apr, 09:45	24 Apr, 11:00	2.13d	Gravytrain	prod.gt1.grvytrn.co.uk disk full
54617	24 Apr, 09:05	24 Apr, 12:35	0.35d	Geograph	Geograph Gitlab upgrade (17.11.1)
54615	24 Apr, 08:34	24 Apr, 13:42	0.51d	Kahootz	Daily dashboard (RT-34259) empty again
54614	24 Apr, 08:14	24 Apr, 14:41	0.64d	OpenCorporates	OpenCorporates Gitlab upgrade 17.11.1
54616	24 Apr, 08:59	25 Apr, 08:55	0.99d	eTherapeutics	ETX Gitlab upgrade (17.11.1)
54622	24 Apr, 15:17	25 Apr, 11:03	0.58d	BD Group	IP Whitelisting
54277	27 Mar, 16:03	25 Apr, 16:14	19.02d	Gravytrain	PCCs for Gravytrain
54574	16 Apr, 08:32	25 Apr, 16:47	5.82d	OpenCorporates	Better uptime
54607	23 Apr, 09:33	28 Apr, 08:52	2.93d	Tusk IC	'arpanpal' gid
54634	25 Apr, 12:15	28 Apr, 11:51	0.96d	Kahootz	Puppet config
54164	18 Mar, 08:31	28 Apr, 12:17	27.38d	Sucden	Sucden systems monitoring cleanup
54397	09 Apr, 15:52	28 Apr, 16:21	11.05d	Ingeus	Fwd: PIM: Tiger Admin 365's Owner role expires in 14 day(s)
54202	21 Mar, 15:38	28 Apr, 16:24	24.08d	OpenCorporates	RDS monitoring
54198	21 Mar, 11:20	28 Apr, 16:26	24.51d	OpenCorporates	Support for OC web and api
54657	29 Apr, 00:00	29 Apr, 10:05	0.21d	Internal	Weekly checks
54658	29 Apr, 08:59	29 Apr, 10:43	0.17d	Sysdoc	Fw: Microsoft Defender for Cloud has detected suspicious activity in your environment
54654	28 Apr, 17:24	29 Apr, 11:43	0.43d	Cambridge Flow Solutions	cfsj01 node reboot
54270	24 Mar, 14:44	29 Apr, 11:50	23.71d	OpenCorporates	Server support removals
54659	29 Apr, 11:51	29 Apr, 12:42	0.08d	OpenCorporates	OC system removals
54240	25 Mar, 12:26	29 Apr, 17:55	23.55d	Sucden	OLM / Patching
54665	30 Apr, 11:58	30 Apr, 14:41	0.27d	Kahootz	EC private key for a client TLS certificate
54666	30 Apr, 13:37	30 Apr, 16:37	0.30d	Sucden	*.sucden.co.uk unmerged configuration files
54344	03 Apr, 14:54	01 May, 09:38	17.47d	Internal	Edit organisational chart
54593	17 Apr, 16:27	01 May, 14:57	7.85d	Internal	Switch from Puppet Agent to OpenVox Agent
54393	09 Apr, 14:17	01 May, 16:01	14.17d	TCV	Test domain?
54663	30 Apr, 09:59	02 May, 11:40	2.17d	AskBio	group change for Andrew Kirkwood
54672	01 May, 09:15	02 May, 17:03	1.78d	Kahootz	Add pmohq.shepherdsafetyservices.com to named.conf.local on oscar.

git hash: master (6c029d07)

Package	Version	Homepage	Summary
alchemical	1.0.3	None	Modern SQLAlchemy simplified
alembic	1.18.5	None	A database migration tool for SQLAlchemy.
annotated-types	0.7.0	None	Reusable constraint types to use with typing.Annotated
anyio	4.14.1	None	High-level concurrency and networking framework on top of asyncio or Trio
ast_serialize	0.6.0	None	Python bindings for mypy AST serialization
asttokens	3.0.1	https://github.com/gristlabs/asttokens	Annotate AST trees with source code positions
backoff	2.2.1	https://github.com/litl/backoff	Function decoration for backoff and retry
blinker	1.9.0	None	Fast, simple object-to-object and broadcast signaling
Bootstrap-Flask	2.5.0	None	Bootstrap 4 & 5 helper for your Flask projects.
certifi	2026.6.17	https://github.com/certifi/python-certifi	Python package for providing Mozilla's CA Bundle.
charset-normalizer	3.4.7	None	The Real First Universal Charset Detector. Open, modern and actively maintained alternative to Chardet.
click	8.4.2	None	Composable command line interface toolkit
colorlog	6.10.1	https://github.com/borntyping/python-colorlog	Add colours to the output of Python's logging module.
decorator	5.3.1	None	Decorators for Humans
executing	2.2.1	https://github.com/alexmojaki/executing	Get the currently executing AST node of a frame, and other information
Flask	3.1.3	None	A simple framework for building complex web applications.
Flask-DebugToolbar	0.16.0	None	A toolbar overlay for debugging Flask applications.
Flask-DebugToolbar-LineProfilerPanel	1.0.2	https://github.com/phleet/flask_debugtoolbar_lineprofilerpanel	Panel for the Flask Debug toolbar to capture and view line-by-line profiling stats
Flask-Migrate	4.1.0	None	SQLAlchemy database migrations for Flask applications using Alembic.
Flask-SQLAlchemy	3.1.1	None	Add SQLAlchemy support to your Flask application.
Flask-WTF	1.3.0	None	Form rendering, validation, and CSRF protection for Flask with WTForms.
freezegun	1.5.5	https://github.com/spulec/freezegun	Let your Python tests travel through time
gql	4.0.0	https://github.com/graphql-python/gql	GraphQL client for Python
graphql-core	3.2.11	https://github.com/graphql-python/graphql-core	GraphQL implementation for Python, a port of GraphQL.js, the JavaScript reference implementation for GraphQL.
greenlet	3.5.3	None	Lightweight in-process concurrent programming
gunicorn	26.0.0	None	WSGI HTTP Server for UNIX
h11	0.16.0	https://github.com/python-hyper/h11	A pure-Python, bring-your-own-I/O implementation of HTTP/1.1
httpcore	1.0.9	None	A minimal low-level HTTP client.
httpx	0.28.1	None	The next generation HTTP client.
idna	3.18	None	Internationalized Domain Names in Applications (IDNA)
ilock	1.0.3	https://github.com/symonsoft/ilock	Inter-process named lock library
ipython	9.15.0	None	IPython: Productive Interactive Computing
ipython_pygments_lexers	1.1.1	None	Defines a variety of Pygments lexers for highlighting IPython code.
itsdangerous	2.2.0	None	Safely pass data to untrusted environments and back.
jedi	0.20.0	https://github.com/davidhalter/jedi	An autocompletion tool for Python that can be used for text editors.
Jinja2	3.1.6	None	A very fast and expressive template engine.
librt	0.12.0	None	Mypyc runtime library
line_profiler	5.0.2	https://github.com/pyutils/line_profiler	Line-by-line profiler
Mako	1.3.12	https://www.makotemplates.org/	A super-fast templating language that borrows the best ideas from the existing templating languages.
MarkupSafe	3.0.3	None	Safely add untrusted strings to HTML/XML markup.
matplotlib-inline	0.2.2	None	Inline Matplotlib backend for Jupyter
multidict	6.7.1	https://github.com/aio-libs/multidict	multidict implementation
mypy	2.2.0	None	Optional static typing for Python
mypy_extensions	1.1.0	None	Type system extensions for programs checked with the mypy type checker.
packaging	26.2	None	Core utilities for Python packages
parso	0.8.7	https://github.com/davidhalter/parso	A Python Parser
pathspec	1.1.1	None	Utility library for gitignore style pattern matching of file paths.
pdbp	1.8.2	https://github.com/mdmintz/pdbp	pdbp (Pdb+): A drop-in replacement for pdb and pdbpp.
pexpect	4.9.0	https://pexpect.readthedocs.io/	Pexpect allows easy control of interactive console applications.
portalocker	3.2.0	None	Wraps the portalocker recipe for easy usage
prompt_toolkit	3.0.52	None	Library for building powerful interactive command lines in Python
propcache	0.5.2	https://github.com/aio-libs/propcache	Accelerated property cache
psutil	7.2.2	https://github.com/giampaolo/psutil	Cross-platform lib for process and system monitoring.
psycopg	3.3.4	None	PostgreSQL database adapter for Python
psycopg-binary	3.3.4	None	PostgreSQL database adapter for Python -- C optimisation distribution
ptyprocess	0.7.0	https://github.com/pexpect/ptyprocess	Run a subprocess in a pseudo terminal
pure_eval	0.2.3	http://github.com/alexmojaki/pure_eval	Safely evaluate AST nodes without side effects
pydantic	2.13.4	None	Data validation using Python type hints
pydantic_core	2.46.4	https://github.com/pydantic/pydantic	Core functionality for Pydantic validation and serialization
Pygments	2.20.0	None	Pygments is a syntax highlighting package written in Python.
python-dateutil	2.9.0.post0	https://github.com/dateutil/dateutil	Extensions to the standard Python datetime module
python-dotenv	1.2.2	None	Read key-value pairs from a .env file and set them as environment variables
pytz	2026.2	http://pythonhosted.org/pytz	World timezone definitions, modern and historical
requests	2.34.2	None	Python HTTP for Humans.
requests-toolbelt	1.0.0	https://toolbelt.readthedocs.io/	A utility belt for advanced users of python-requests
rt	3.7.1	None	Python interface to Request Tracker API
six	1.17.0	https://github.com/benjaminp/six	Python 2 and 3 compatibility utilities
SQLAlchemy	2.0.51	https://www.sqlalchemy.org	Database Abstraction Library
stack-data	0.6.3	http://github.com/alexmojaki/stack_data	Extract data from python stack frames and tracebacks for informative displays
stackprinter	0.2.13	https://github.com/cknd/stackprinter	Debug-friendly stack traces, with variable values and semantic highlighting
tabcompleter	1.4.1	https://github.com/mdmintz/tabcompleter	tabcompleter --- Autocompletion in the Python console.
traitlets	5.15.1	None	Traitlets Python configuration system
types-pytz	2026.2.0.20260518	None	Typing stubs for pytz
typing-inspection	0.4.2	None	Runtime typing introspection tools
typing_extensions	4.16.0	None	Backported and Experimental Type Hints for Python 3.9+
urllib3	2.7.0	None	HTTP library with thread-safe connection pooling, file post, and more.
wcwidth	0.8.2	None	Measures the displayed width of unicode strings in a terminal
Werkzeug	3.1.8	None	The comprehensive WSGI web application library.
WTForms	3.2.2	None	Form validation and rendering for Python web development.
yarl	1.24.2	https://github.com/aio-libs/yarl	Yet another URL library

Resource	Value
User CPU time	70.079 msec
System CPU time	0.000 msec
Total CPU time	70.079 msec
Elapsed time	83.441 msec
Context switches	53 voluntary, 10 involuntary

Key	Value
HTTP_ACCEPT	/
HTTP_ACCEPT_ENCODING	gzip, br, zstd, deflate
HTTP_HOST	dashboard.uat.tigr.uk
HTTP_USER_AGENT	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
QUERY_STRING	end=2025-05-02&queue=Requests&start=2025-03-31
REMOTE_ADDR	10.42.140.143
REQUEST_METHOD	GET
SCRIPT_NAME
SERVER_NAME	0.0.0.0
SERVER_PORT	8000
SERVER_PROTOCOL	HTTP/1.1
SERVER_SOFTWARE	gunicorn/26.0.0

Variable	Value
'end'	'2025-05-02'
'queue'	'Requests'
'start'	'2025-03-31'

Variable	Value
g	<flask.g of 'app'>
meta	{'title': 'Ticket resolution report for Requests', 'start': datetime.date(2025, 3, 31), 'end': datetime.date(2025, 5, 2)}
request	<Request 'http://dashboard.uat.tigr.uk/resolutions_report_drilldown?end=2025-05-02&queue=Requests&start=2025-03-31' [GET]>
tickets	[<Ticket(id=4886, rt_number=54156, queue=Requests, subject=Tiger P12 certificate renewal, ticket_status=closed, client=Cambridge Flow Solutions, priority=42, created=2025-03-17 15:05:51, last_txn_id=2309377>, <Ticket(id=5015, rt_number=54286, queue=Requests, subject=Backup service, ticket_status=closed, client=Trident Honda, priority=41, created=2025-03-28 08:55:55, last_txn_id=0>, <Ticket(id=5024, rt_number=54295, queue=Requests, subject=Pls Remove, ticket_status=closed, client=OpenCorporates, priority=61, created=2025-03-28 09:22:47, last_txn_id=2311950>, <Ticket(id=5041, rt_number=54312, queue=Requests, subject=IP Address Change - SFTP, ticket_status=closed, client=Entrepreneurs Circle, priority=0, created=2025-03-31 13:59:35, last_txn_id=0>, <Ticket(id=4526, rt_number=53798, queue=Requests, subject=Out of band access, ticket_status=closed, client=Quickline, priority=5, created=2025-02-06 09:58:09, last_txn_id=2295430>, <Ticket(id=4990, rt_number=54260, queue=Requests, subject=Indie checks for rc-mss.reigate.ac.uk, ticket_status=closed, client=Internal, priority=41, created=2025-03-26 16:04:30, last_txn_id=0>, <Ticket(id=4909, rt_number=54179, queue=Requests, subject=Switch from mlocate to plocate for debian 12/ubuntu 24.04, ticket_status=closed, client=Internal, priority=42, created=2025-03-20 10:34:15, last_txn_id=0>, <Ticket(id=4998, rt_number=54268, queue=Requests, subject=downgrade all the search1-5 from premier to business, ticket_status=closed, client=OpenCorporates, priority=61, created=2025-03-27 09:25:35, last_txn_id=0>, <Ticket(id=5016, rt_number=54287, queue=Requests, subject=I can't access Slack, ticket_status=closed, client=Internal, priority=41, created=2025-03-28 09:15:49, last_txn_id=0>, <Ticket(id=5046, rt_number=54316, queue=Requests, subject=Weekly checks, ticket_status=closed, client=Internal, priority=1, created=2025-04-01 00:00:07, last_txn_id=0>, <Ticket(id=5047, rt_number=54317, queue=Requests, subject=Purge old client password records, ticket_status=closed, client=Internal, priority=41, created=2025-04-01 00:00:08, last_txn_id=0>, <Ticket(id=4968, rt_number=54238, queue=Requests, subject=mathsgpu3, ticket_status=closed, client=Edinburgh University, priority=42, created=2025-03-25 12:16:43, last_txn_id=0>, <Ticket(id=5057, rt_number=54327, queue=Requests, subject=System uptime, ticket_status=closed, client=ITC Compliance, priority=41, created=2025-04-02 08:00:21, last_txn_id=0>, <Ticket(id=5070, rt_number=54340, queue=Requests, subject=Allias, ticket_status=closed, client=NFW, priority=0, created=2025-04-03 09:02:16, last_txn_id=0>, <Ticket(id=5053, rt_number=54323, queue=Requests, subject=Request for IP Update – inprog.entrepreneurscircle.org - Access Issue, ticket_status=closed, client=Entrepreneurs Circle, priority=61, created=2025-04-01 12:55:04, last_txn_id=0>, <Ticket(id=4758, rt_number=54028, queue=Requests, subject=Expiring certificate \| gallus.rotastat.com, ticket_status=closed, client=Rotastat, priority=44, created=2025-03-03 16:57:57, last_txn_id=2297508>, <Ticket(id=5079, rt_number=54348, queue=Requests, subject=Sylvera monthly backup check and tape swap, ticket_status=closed, client=Sylvera, priority=55, created=2025-04-04 00:00:05, last_txn_id=0>, <Ticket(id=5076, rt_number=54345, queue=Requests, subject=URGENT - Encryption Keys for COLL, JURA, IONA, MULL , ticket_status=closed, client=AskBio, priority=41, created=2025-04-03 16:13:22, last_txn_id=0>, <Ticket(id=5086, rt_number=54355, queue=Requests, subject=cfsj03 node reboot, ticket_status=closed, client=Cambridge Flow Solutions, priority=40, created=2025-04-04 11:49:08, last_txn_id=0>, <Ticket(id=5098, rt_number=54367, queue=Requests, subject=Ingeus: login to Azure, ticket_status=closed, client=Ingeus, priority=40, created=2025-04-07 00:00:11, last_txn_id=0>, <Ticket(id=5104, rt_number=54371, queue=Requests, subject=mathsgpu2/3, ticket_status=closed, client=Edinburgh University, priority=0, created=2025-04-07 09:09:48, last_txn_id=0>, <Ticket(id=4935, rt_number=54205, queue=Requests, subject=FW: Product Update: Upgrade to Bitnami package for PostgreSQL new version, ticket_status=closed, client=eTherapeutics, priority=43, created=2025-03-21 16:45:19, last_txn_id=0>, <Ticket(id=5107, rt_number=54374, queue=Requests, subject=UPS beeping, ticket_status=closed, client=AskBio, priority=0, created=2025-04-07 11:22:37, last_txn_id=0>, <Ticket(id=5081, rt_number=54350, queue=Requests, subject=Cron <root@mis> /usr/sbin/ntpdate-debian > /dev/null, ticket_status=closed, client=TCV, priority=41, created=2025-04-04 08:34:45, last_txn_id=0>, <Ticket(id=5100, rt_number=54369, queue=Requests, subject=update user details, ticket_status=closed, client=Tusk IC, priority=0, created=2025-04-07 07:00:08, last_txn_id=0>, <Ticket(id=5023, rt_number=54294, queue=Requests, subject=DLS potential ransomware infection, ticket_status=closed, client=DLS Plastics, priority=42, created=2025-03-28 11:54:35, last_txn_id=0>, <Ticket(id=5062, rt_number=54332, queue=Requests, subject=Update Lime Survey installation, ticket_status=closed, client=Internal, priority=42, created=2025-04-02 09:34:45, last_txn_id=0>, <Ticket(id=5112, rt_number=54379, queue=Requests, subject=Weekly checks, ticket_status=closed, client=Internal, priority=1, created=2025-04-08 00:00:06, last_txn_id=0>, <Ticket(id=5118, rt_number=54385, queue=Requests, subject=A verified domain was added to your Microsoft 365 account, ticket_status=closed, client=Internal, priority=0, created=2025-04-08 11:15:38, last_txn_id=0>, <Ticket(id=5099, rt_number=54368, queue=Requests, subject=Quarterly Ouse Failover Test, ticket_status=closed, client=Internal, priority=41, created=2025-04-07 00:00:12, last_txn_id=0>, <Ticket(id=4960, rt_number=54230, queue=Requests, subject=Maintenance window, ticket_status=closed, client=Visku, priority=43, created=2025-03-25 09:56:52, last_txn_id=0>, <Ticket(id=4958, rt_number=54228, queue=Requests, subject=Maintenance window, ticket_status=closed, client=ERF Electrical, priority=43, created=2025-03-25 09:28:48, last_txn_id=0>, <Ticket(id=4957, rt_number=54227, queue=Requests, subject=Maintenance window, ticket_status=closed, client=Imoves, priority=43, created=2025-03-25 09:11:46, last_txn_id=0>, <Ticket(id=5095, rt_number=54364, queue=Requests, subject=Monthly certificate expiry check, ticket_status=closed, client=Internal, priority=1, created=2025-04-07 00:00:06, last_txn_id=0>, <Ticket(id=5127, rt_number=54394, queue=Requests, subject=Ad hoc support requests next week, ticket_status=closed, client=OpenCorporates, priority=60, created=2025-04-09 15:04:45, last_txn_id=0>, <Ticket(id=5133, rt_number=54400, queue=Requests, subject=ETX Gitlab upgrade (17.10.4), ticket_status=closed, client=eTherapeutics, priority=41, created=2025-04-09 16:26:33, last_txn_id=0>, <Ticket(id=5132, rt_number=54399, queue=Requests, subject=OpenCorporates Gitlab upgrade (17.10.4), ticket_status=closed, client=OpenCorporates, priority=41, created=2025-04-09 16:07:57, last_txn_id=0>, <Ticket(id=5131, rt_number=54398, queue=Requests, subject= Geograph Gitlab upgrade (17.10.4), ticket_status=closed, client=Geograph, priority=41, created=2025-04-09 16:00:46, last_txn_id=0>, <Ticket(id=5128, rt_number=54395, queue=Requests, subject=Gitlab upgrade (17.10.4), ticket_status=closed, client=Internal, priority=41, created=2025-04-09 15:37:26, last_txn_id=0>, <Ticket(id=5136, rt_number=54403, queue=Requests, subject=Backups, ticket_status=closed, client=Kahootz, priority=60, created=2025-04-10 09:07:21, last_txn_id=0>, <Ticket(id=4931, rt_number=54201, queue=Requests, subject=Bot1 running slow, ticket_status=closed, client=OpenCorporates, priority=43, created=2025-03-21 14:04:54, last_txn_id=0>, <Ticket(id=5108, rt_number=54375, queue=Requests, subject=Expired Puppet Release Key on Golf, ticket_status=closed, client=Kahootz, priority=61, created=2025-04-07 15:59:17, last_txn_id=0>, <Ticket(id=5110, rt_number=54377, queue=Requests, subject=List of Managed Servers, ticket_status=closed, client=AskBio, priority=61, created=2025-04-07 19:20:18, last_txn_id=0>, <Ticket(id=3762, rt_number=51406, queue=Requests, subject=Novadata CentOS7 EOL , ticket_status=closed, client=NovaData, priority=53, created=2024-07-03 14:39:07, last_txn_id=2305090>, <Ticket(id=5085, rt_number=54354, queue=Requests, subject=Apache Logs, ticket_status=closed, client=Kahootz, priority=62, created=2025-04-04 11:44:25, last_txn_id=0>, <Ticket(id=5137, rt_number=54404, queue=Requests, subject=Staging Mesos, ticket_status=closed, client=OpenCorporates, priority=41, created=2025-04-10 09:12:25, last_txn_id=0>, <Ticket(id=4738, rt_number=54008, queue=Requests, subject=Stage Server, ticket_status=closed, client=BD Group, priority=45, created=2025-02-27 12:23:15, last_txn_id=2295599>, <Ticket(id=5207, rt_number=54474, queue=Requests, subject=Tomcat startup, ticket_status=closed, client=Kahootz, priority=61, created=2025-04-10 14:30:41, last_txn_id=0>, <Ticket(id=5121, rt_number=54388, queue=Requests, subject=Odd tcl/Docker behaviour, ticket_status=closed, client=AskBio, priority=61, created=2025-04-08 15:41:24, last_txn_id=0>, <Ticket(id=5220, rt_number=54483, queue=Requests, subject=OpenC Release, ticket_status=closed, client=OpenCorporates, priority=41, created=2025-04-11 11:25:27, last_txn_id=0>, <Ticket(id=5251, rt_number=54515, queue=Requests, subject=Openc API - Release code to pre-production environment, ticket_status=closed, client=OpenCorporates, priority=0, created=2025-04-14 11:29:00, last_txn_id=0>, <Ticket(id=5120, rt_number=54387, queue=Requests, subject=Creating an RDP snapshot of frontend Redis (10.43.15.31) , ticket_status=closed, client=OpenCorporates, priority=41, created=2025-04-08 15:28:40, last_txn_id=0>, <Ticket(id=5040, rt_number=54311, queue=Requests, subject=Load monitoring of Interstar01-06, ticket_status=closed, client=Sucden, priority=2, created=2025-03-31 13:43:19, last_txn_id=0>, <Ticket(id=4864, rt_number=54134, queue=Requests, subject=Email from Iona and other datacentre servers, ticket_status=closed, client=AskBio, priority=64, created=2025-03-13 10:53:11, last_txn_id=2310687>, <Ticket(id=4926, rt_number=54196, queue=Requests, subject=Remove stardrop from support, ticket_status=closed, client=eTherapeutics, priority=3, created=2025-03-21 10:30:10, last_txn_id=0>, <Ticket(id=5256, rt_number=54520, queue=Requests, subject=/tmp cleared on Coll, Jura, Mull and Iona, ticket_status=closed, client=AskBio, priority=1, created=2025-04-14 14:27:10, last_txn_id=0>, <Ticket(id=5270, rt_number=54567, queue=Requests, subject=OpenC API - PR to remove Circle CI tests and replace with GitHub Workflow, ticket_status=closed, client=OpenCorporates, priority=60, created=2025-04-15 13:56:55, last_txn_id=0>, <Ticket(id=5255, rt_number=54519, queue=Requests, subject=Openc API - GitHub repo, remove CircleCI, ticket_status=closed, client=OpenCorporates, priority=41, created=2025-04-14 14:18:20, last_txn_id=0>, <Ticket(id=5263, rt_number=54559, queue=Requests, subject=Weekly checks, ticket_status=closed, client=Internal, priority=1, created=2025-04-15 00:00:06, last_txn_id=0>, <Ticket(id=4706, rt_number=53945, queue=Requests, subject=Novadata backup cost, ticket_status=closed, client=NovaData, priority=45, created=2025-02-24 11:02:58, last_txn_id=2293337>, <Ticket(id=5065, rt_number=54335, queue=Requests, subject=Ansys CFX 2024R2 not running on J cluster using slurm job scheduler, ticket_status=closed, client=Cambridge Flow Solutions, priority=42, created=2025-04-02 11:29:10, last_txn_id=0>, <Ticket(id=5083, rt_number=54352, queue=Requests, subject=TCV Domains , ticket_status=closed, client=TCV, priority=42, created=2025-04-04 09:26:12, last_txn_id=0>, <Ticket(id=5279, rt_number=54575, queue=Requests, subject=OpenC - GitHub PR to deploy code to PreProd environment, ticket_status=closed, client=OpenCorporates, priority=40, created=2025-04-16 10:35:35, last_txn_id=0>, <Ticket(id=5280, rt_number=54576, queue=Requests, subject=PEN Tests, ticket_status=closed, client=BD Group, priority=40, created=2025-04-16 10:46:23, last_txn_id=0>, <Ticket(id=5285, rt_number=54580, queue=Requests, subject=OpenC - GitHub PR to deploy release 1.1.5 to Production, ticket_status=closed, client=OpenCorporates, priority=60, created=2025-04-16 15:40:36, last_txn_id=0>, <Ticket(id=4969, rt_number=54239, queue=Requests, subject=Fwd: Azure DevOps personal access token nearing expiration, ticket_status=closed, client=Ingeus, priority=43, created=2025-03-25 12:17:57, last_txn_id=0>, <Ticket(id=5001, rt_number=54271, queue=Requests, subject=Eibhlín account details (technical) , ticket_status=closed, client=Internal, priority=3, created=2025-03-27 10:22:04, last_txn_id=0>, <Ticket(id=4712, rt_number=53983, queue=Requests, subject=Test restore NetBox, ticket_status=closed, client=Internal, priority=45, created=2025-02-24 16:23:57, last_txn_id=2293701>, <Ticket(id=5074, rt_number=54343, queue=Requests, subject=Server Time Configuration, ticket_status=closed, client=BD Group, priority=62, created=2025-04-03 13:17:54, last_txn_id=0>, <Ticket(id=5054, rt_number=54324, queue=Requests, subject=Onboarding of svaolmgs201, ticket_status=closed, client=Sucden, priority=43, created=2025-04-01 16:09:57, last_txn_id=0>, <Ticket(id=5092, rt_number=54361, queue=Requests, subject=Create client services account for Jolyon Holdstock, ticket_status=closed, client=OGT, priority=42, created=2025-04-06 13:44:09, last_txn_id=0>, <Ticket(id=5294, rt_number=54589, queue=Requests, subject=Indie check of svaolmgs201, ticket_status=closed, client=Sucden, priority=40, created=2025-04-17 12:01:33, last_txn_id=0>, <Ticket(id=4875, rt_number=54145, queue=Requests, subject=DB Cleanup tasks, ticket_status=closed, client=OpenCorporates, priority=64, created=2025-03-14 14:29:06, last_txn_id=2303102>, <Ticket(id=5234, rt_number=54497, queue=Requests, subject=FW: STAR hardware decommission, ticket_status=closed, client=Sucden, priority=62, created=2025-04-11 15:25:10, last_txn_id=0>, <Ticket(id=5302, rt_number=54597, queue=Requests, subject=Weekly checks, ticket_status=closed, client=Internal, priority=1, created=2025-04-22 00:00:04, last_txn_id=0>, <Ticket(id=5305, rt_number=54600, queue=Requests, subject=Urgent Update Required: IP Address Change for New HQ, ticket_status=closed, client=Entrepreneurs Circle, priority=60, created=2025-04-22 11:45:54, last_txn_id=0>, <Ticket(id=4807, rt_number=54077, queue=Requests, subject=Support for svaolmgs201, ticket_status=closed, client=Sucden, priority=5, created=2025-03-06 12:27:27, last_txn_id=2313162>, <Ticket(id=5115, rt_number=54382, queue=Requests, subject=Google Cloud Armor WAF Implementation Testing, ticket_status=closed, client=JISC, priority=63, created=2025-04-08 10:02:15, last_txn_id=0>, <Ticket(id=4600, rt_number=53873, queue=Requests, subject=Introducing Usama and OpenVPN Setup Assistance, ticket_status=closed, client=Entrepreneurs Circle, priority=66, created=2025-02-13 17:21:25, last_txn_id=2293373>, <Ticket(id=4650, rt_number=53891, queue=Requests, subject=Email issue (not normal support question), ticket_status=closed, client=DLS Plastics, priority=46, created=2025-02-17 11:03:49, last_txn_id=2295435>, <Ticket(id=5313, rt_number=54608, queue=Requests, subject=Service Removals, ticket_status=closed, client=Sucden, priority=0, created=2025-04-23 10:04:28, last_txn_id=0>, <Ticket(id=5105, rt_number=54372, queue=Requests, subject=Improve OC mysql cluster monitoring, ticket_status=closed, client=OpenCorporates, priority=63, created=2025-04-07 09:10:45, last_txn_id=0>, <Ticket(id=5311, rt_number=54606, queue=Requests, subject=OpenAthens patching, ticket_status=closed, client=JISC, priority=1, created=2025-04-23 08:36:10, last_txn_id=0>, <Ticket(id=5318, rt_number=54613, queue=Requests, subject=Gitlab upgrade (17.11.1), ticket_status=closed, client=Internal, priority=40, created=2025-04-24 08:13:04, last_txn_id=0>, <Ticket(id=5306, rt_number=54601, queue=Requests, subject=Frontend Redis Dump, ticket_status=closed, client=OpenCorporates, priority=1, created=2025-04-22 12:29:50, last_txn_id=0>, <Ticket(id=5303, rt_number=54598, queue=Requests, subject=prod.gt1.grvytrn.co.uk disk full, ticket_status=closed, client=Gravytrain, priority=41, created=2025-04-22 09:45:21, last_txn_id=0>, <Ticket(id=5322, rt_number=54617, queue=Requests, subject=Geograph Gitlab upgrade (17.11.1), ticket_status=closed, client=Geograph, priority=40, created=2025-04-24 09:05:53, last_txn_id=0>, <Ticket(id=5320, rt_number=54615, queue=Requests, subject=Daily dashboard (RT-34259) empty again, ticket_status=closed, client=Kahootz, priority=60, created=2025-04-24 08:34:28, last_txn_id=0>, <Ticket(id=5319, rt_number=54614, queue=Requests, subject=OpenCorporates Gitlab upgrade 17.11.1, ticket_status=closed, client=OpenCorporates, priority=40, created=2025-04-24 08:14:40, last_txn_id=0>, <Ticket(id=5321, rt_number=54616, queue=Requests, subject= ETX Gitlab upgrade (17.11.1), ticket_status=closed, client=eTherapeutics, priority=41, created=2025-04-24 08:59:40, last_txn_id=0>, <Ticket(id=5327, rt_number=54622, queue=Requests, subject=IP Whitelisting, ticket_status=closed, client=BD Group, priority=41, created=2025-04-24 15:17:01, last_txn_id=0>, <Ticket(id=5006, rt_number=54277, queue=Requests, subject=PCCs for Gravytrain, ticket_status=closed, client=Gravytrain, priority=44, created=2025-03-27 16:03:57, last_txn_id=0>, <Ticket(id=5278, rt_number=54574, queue=Requests, subject=Better uptime, ticket_status=closed, client=OpenCorporates, priority=2, created=2025-04-16 08:32:12, last_txn_id=0>, <Ticket(id=5312, rt_number=54607, queue=Requests, subject='arpanpal' gid , ticket_status=closed, client=Tusk IC, priority=1, created=2025-04-23 09:33:10, last_txn_id=0>, <Ticket(id=5339, rt_number=54634, queue=Requests, subject=Puppet config, ticket_status=closed, client=Kahootz, priority=61, created=2025-04-25 12:15:48, last_txn_id=0>, <Ticket(id=4894, rt_number=54164, queue=Requests, subject=Sucden systems monitoring cleanup, ticket_status=closed, client=Sucden, priority=44, created=2025-03-18 08:31:37, last_txn_id=0>, <Ticket(id=5130, rt_number=54397, queue=Requests, subject=Fwd: PIM: Tiger Admin 365's Owner role expires in 14 day(s), ticket_status=closed, client=Ingeus, priority=43, created=2025-04-09 15:52:27, last_txn_id=0>, <Ticket(id=4932, rt_number=54202, queue=Requests, subject=RDS monitoring, ticket_status=closed, client=OpenCorporates, priority=64, created=2025-03-21 15:38:00, last_txn_id=2313469>, <Ticket(id=4928, rt_number=54198, queue=Requests, subject=Support for OC web and api, ticket_status=closed, client=OpenCorporates, priority=44, created=2025-03-21 11:20:44, last_txn_id=0>, <Ticket(id=5364, rt_number=54657, queue=Requests, subject=Weekly checks, ticket_status=closed, client=Internal, priority=41, created=2025-04-29 00:00:03, last_txn_id=0>, <Ticket(id=5365, rt_number=54658, queue=Requests, subject=Fw: Microsoft Defender for Cloud has detected suspicious activity in your environment, ticket_status=closed, client=Sysdoc, priority=40, created=2025-04-29 08:59:58, last_txn_id=0>, <Ticket(id=5361, rt_number=54654, queue=Requests, subject=cfsj01 node reboot, ticket_status=closed, client=Cambridge Flow Solutions, priority=41, created=2025-04-28 17:24:23, last_txn_id=0>, <Ticket(id=5000, rt_number=54270, queue=Requests, subject=Server support removals, ticket_status=closed, client=OpenCorporates, priority=2, created=2025-03-24 14:44:26, last_txn_id=2313892>, <Ticket(id=5366, rt_number=54659, queue=Requests, subject=OC system removals, ticket_status=closed, client=OpenCorporates, priority=40, created=2025-04-29 11:51:48, last_txn_id=0>, <Ticket(id=4970, rt_number=54240, queue=Requests, subject=OLM / Patching, ticket_status=closed, client=Sucden, priority=64, created=2025-03-25 12:26:33, last_txn_id=0>, <Ticket(id=5372, rt_number=54665, queue=Requests, subject=EC private key for a client TLS certificate, ticket_status=closed, client=Kahootz, priority=60, created=2025-04-30 11:58:15, last_txn_id=0>, <Ticket(id=5373, rt_number=54666, queue=Requests, subject=*.sucden.co.uk unmerged configuration files, ticket_status=closed, client=Sucden, priority=40, created=2025-04-30 13:37:48, last_txn_id=0>, <Ticket(id=5075, rt_number=54344, queue=Requests, subject=Edit organisational chart, ticket_status=closed, client=Internal, priority=44, created=2025-04-03 14:54:13, last_txn_id=0>, <Ticket(id=5298, rt_number=54593, queue=Requests, subject=Switch from Puppet Agent to OpenVox Agent, ticket_status=closed, client=Internal, priority=42, created=2025-04-17 16:27:22, last_txn_id=0>, <Ticket(id=5126, rt_number=54393, queue=Requests, subject=Test domain?, ticket_status=closed, client=TCV, priority=43, created=2025-04-09 14:17:33, last_txn_id=0>, <Ticket(id=5370, rt_number=54663, queue=Requests, subject=group change for Andrew Kirkwood, ticket_status=closed, client=AskBio, priority=61, created=2025-04-30 09:59:48, last_txn_id=0>, <Ticket(id=5379, rt_number=54672, queue=Requests, subject=Add pmohq.shepherdsafetyservices.com to named.conf.local on oscar., ticket_status=closed, client=Kahootz, priority=61, created=2025-05-01 09:15:50, last_txn_id=0>]

Ticket resolution report for Requests

31 Mar - 02 May

Versions

Installed Packages

Resource Usage

HTTP Headers

Request Vars

View information

COOKIES Variables

SESSION Variables

GET Variables

POST Variables

Templates

resolutions_report_drilldown.html

SQLAlchemy queries

Queries Unavailable

Configure Flask-SQLAlchemy:

Log Messages

Line Profiler Usage Docs

Usage Instructions