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

Last updated
Save as PDF
Share
1. Share

InSource_Logo_Transparent (1).png

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