1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 <2022> 2023 2024 | Index | 1994 1995 1996 1997 1998 1999 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 2012 2013 2014 2015 2016 2017 2018 2019 2020 2021 <2022> 2023 2024 |
<== Date ==> | <== Thread ==> |
---|
Subject: | Archiver Appliance: How to extract a PV current value using a SQL query |
From: | Oscar Ibañez via Tech-talk <tech-talk at aps.anl.gov> |
To: | "tech-talk at aps.anl.gov" <tech-talk at aps.anl.gov> |
Date: | 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