This article from InSource shows how to query real-time Application Server data via all attributes that are currently set to TRUE in SQL.
- Author: Ernest Lee
- Published: 11/21/2017
- Applies to: Application Server and Historian 2012 and higher
Running the query below in SQL will show all attributes that are currently being referenced in the Galaxy.
(select tagname from live where value = 1) t1
(select tagname from Tag where IOServerKey = 4) t2
on t1.Tagname = t2.Tagname