I have hit a wall and am turning to the community. I am looking for a way to query all realtime providers names, or historical providers under the /drv designation. I have a export function that works with the providers hard coded in, but I would like to replicate it with a dynamic style lookup. Below you can see the table configuration as it exists currently.
I just had a "duh" moment, and saw my sqlth_drv table. Apologies.
pturmel
September 12, 2024, 6:05pm
3
Perhaps looking at my code in my Tag Report Utility's history script will help:
New resource just uploaded to the Exchange (pending review).
Also available here:
https://www.automation-pros.com/TagReportUtility/
I intend to publish at this link as well as in the Exchange going forward.
Announcements will be in this topic. (:
Highlights:
Provides a Perspective Popup View that provides a user interface to system.tag.query() that entirely replicates the functionality of the Designer's Tag Report Tool.
Provides a Perspective Embedded View that provides Time Span selectio…
A normal qualified path for history takes this form:
histprov:HistoryProviderName:/drv:sourceGWName:sourceTagProvider:/tag:path/to/tag
You might look at this topic, too, and the providers script in that exchange resource:
I'm working on a couple tasks related to historians and history queries, and have encountered some behaviors of remote tag providers (RTPs) that have me stymied:
There's no public way to retrieve the gateway name that a RTP is pointing at, nor any public way to retrieve the far end's real tag provider name.
(Reflection has exposed com.inductiveautomation.ignition.gateway.tags.distributed.client.RemoteTagProvider and com.inductiveautomation.metro.api.ServerId to me, and a number of private fie…
1 Like
