# Determining Realtime/Historical Provider /drv names

**URL:** <https://forum.inductiveautomation.com/t/determining-realtime-historical-provider-drv-names/95910>\
**Category:** General Discussion\
**Tags:** perspective, ignition81, database, scripting\
**Created:** [September 12, 2024, 5:26pm UTC](https://forum.inductiveautomation.com/t/determining-realtime-historical-provider-drv-names/95910 "2024-09-12T17:26:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Neil\_Lewallen1](https://avatars.discourse-cdn.com/v4/letter/n/e19b73/32.png) [@Neil\_Lewallen1](https://forum.inductiveautomation.com/u/Neil_Lewallen1)\
**Post date:** [September 12, 2024, 5:26pm UTC](https://forum.inductiveautomation.com/t/determining-realtime-historical-provider-drv-names/95910/1 "2024-09-12T17:26:43Z")

</div>

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.

 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/5/b/5bd0ebece68f2039be23135f68e009a7d6711cde.png)

---

<div class="post-metadata">

**Author:** ![Neil\_Lewallen1](https://avatars.discourse-cdn.com/v4/letter/n/e19b73/32.png) [@Neil\_Lewallen1](https://forum.inductiveautomation.com/u/Neil_Lewallen1)\
**Post date:** [September 12, 2024, 6:01pm UTC](https://forum.inductiveautomation.com/t/determining-realtime-historical-provider-drv-names/95910/2 "2024-09-12T18:01:13Z")

</div>

I just had a "duh" moment, and saw my sqlth\_drv table. Apologies.

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [September 12, 2024, 6:05pm UTC](https://forum.inductiveautomation.com/t/determining-realtime-historical-provider-drv-names/95910/3 "2024-09-12T18:05:43Z")

</div>

Perhaps looking at my code in my Tag Report Utility's `history` script will help:

> [@Tag Report Utility](https://forum.inductiveautomation.com/t/tag-report-utility/95299):
>
> New resource just uploaded to the Exchange (pending review). Also available here: [https://www.automation-pros.com/TagReportUtility/](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:

```python
histprov:HistoryProviderName:/drv:sourceGWName:sourceTagProvider:/tag:path/to/tag

```

You might look at this topic, too, and the `providers` script in that exchange resource:

> [@Remote Tag Provider History Queries](https://forum.inductiveautomation.com/t/remote-tag-provider-history-queries/93632):
>
> 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…