Skip to main content
InSource Solutions

TN Hist239 Query Public Groups in Historian

insource logo large.jpg



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





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'