Some content on this site is available only to logged-in subscribers. Contact Us for information on becoming a subscriber.

InSource.Solutions | InSource Training | InSource Client Portal
InSource Solutions Logo
Log In Sign Up
InSource.Solutions InSource Training InSource Client Portal Log In Sign Up
  • Home
  • AVEVA Historian
  • AVEVA Historian Documentation

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

Last updated: March 9th, 2025

Description

  • Author: Ernest Lee
  • Published: March 9th, 2025

Details:

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

 

real-time attributes
Give feedback about this article

How can we improve this article?

Share additional info and suggestions

Recommended articles

TN 1398 Determining Active Communications Server

Read More
Support Icon

CONTACT SUPPORT

How to reach us

10800 Midlothian Turnpike Tpke, Suite 209, Richmond, VA 23235

1.877.INSOURCE

Technical Support - 1.888.691.3858

Contact Us

  • InSource Solutions
  • InSource Training
  • InSource Client Portal
  • Log In
InSource Solutions Logo

© 2025 InSource Solutions. All Rights Reserved.

Knowledge Base Software powered by Helpjuice

Expand

Definition by