Experimental Physics and
Industrial Control System

Oscar Ibañez via Tech-talk <tech-talk at aps.anl.gov> · Mon, 5 Dec 2022 11:24:24 +0100

Hi everybody,

First of all, sorry if this question is very silly. My experience with

this technology is very limited and, often, I feel lost.

My question is about the archiver appliance. I have been capable of

running it using MySQL, as well as archiving one PV. I have also been

capable of investigating inside the database I created, so I could find

the the tables entitled "ArchivePVRequests", "PVTypeInfo" and so on.

However, I can't find where is the table used to save the PVs. I

understand that there are three different types of storage (short,

medium and long term) using specific folders but, is there any table

where the PVs values are also saved?

The reason behind this question is because I need to extract the current

value of a PV using SQL. The idea is to have a different piece of

software querying the MySQL database and selecting the current values

that I am interested in. My objective is to use that information inside

that external software for other purposes.

Best,
Óscar