TN AppSvr297 How to query real-time Application Server data via all attributes that are currently set to TRUE

Description

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

Details

Running the query below in SQL will show all attributes that are currently being referenced in the Galaxy.

Select t1.Tagname
from
(select tagname from live where value = 1) t1

LEFT JOIN

(select tagname from Tag where IOServerKey = 4) t2
on t1.Tagname = t2.Tagname