Skip to main content
InSource Solutions

TN Hist239 Query Public Groups in Historian

  1. Last updated
  2. Save as PDF

insource logo large.jpg

 

Description

Query Public Groups Folders in Historian to get a list of tags

 

  • Author: Mike Viteri
  • Published: 8/19/2015
  • Applies to: Historian 9.0 and Greater

 

 

Details

 

Use the query below to get the tags in the Historian Public Groups folders


Where name "= 'test' " replace with your public group name

 

 

Use Runtime

Select c.TagName
from runtime.dbo.PublicNameSpace as a inner join 
runtime.dbo.PublicGroupTag as b on a.NameKey = b.NameKey inner join
runtime.dbo.TagRef as e on e.wwDomainTagKey = b.wwDomainTagKey inner join
runtime.dbo.tag as c on e.wwTagKey = c.wwTagKey
Where name = 'test'