Find a way to replace PLSQL for CTA usage statistics
Problem to solve
In order to get CTA usage statistics, there is an Oracle Database job that runs everyday that gather informations about the usage of CTA from the CTA Catalogue. We would like to get rid of this job and find a way to do the same work.
Here what are the CTA usage statistics populated :
- number of files stored
- number of bytes stored
- tape statistics (number of files, number of bytes, max archiveFileId,)
Intended users
CTA monitoring
Proposal
I have to do an analysis on how we could do this, but here are some first thougts :
- Daily run a script that will interrogate the CTA catalogue
- Interrogating CTA catalogue via cta-admin --json tape ls
- Interrogating CTA catalogue via cta-admin --json archivefile ls
- Query the results via jq in order and gather informations
- Populate an InfluxDB database with the gathered informations
- Create a fluent plot interrogating this InfluxDB database
Edited by Cedric Caffy