# New Feature - Tag Report Tool

**URL:** <https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594>\
**Category:** Ignition Early Access\
**Tags:** ignition81\
**Created:** [July 6, 2022, 9:44pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594 "2022-07-06T21:44:25Z")\
**Posts on this page:** 20\
**Page:** 2

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [August 22, 2022, 2:44pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/21 "2022-08-22T14:44:18Z")

</div>

~~Ah you’re right notepadd++ won’t be able to do it.~~

~~Using an diff in linux provides the almost expected results though (looks slightly weird and perhaps I messed up my text file but its obvious which side the tags belong to)~~

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

~~So I do think some dedicated diff software should be able to do this. Notepad++ I think uses a naive one pass type algo~~

Nevermind. I had an issue in my text file. Doing it with your data is like  
 ![image](https://us1.discourse-cdn.com/inductiveautomation/original/3X/f/3/f352cfc608329cb82b61c88c3643fa96e36ad6f8.png)

But I think @pturmel 's point is that the file shouldn’t be saved in such a way that diff-ing is impossible like it is.

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [August 23, 2022, 1:20am UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/22 "2022-08-23T01:20:11Z")

</div>

> [@bkarabinchak.psi](#):
>
> But I think @pturmel 's point is that the file shouldn’t be saved in such a way that diff-ing is impossible like it is.

but... again, diff-ing with a generic JSON compare tool is impossible unless there are the same tags present in both JSON files and they're in the same indexes in the arrays. _There's no way around this_, regardless of how the JSON is arranged. I wrote a script a while back to do this comparison and it's a pita, but definitely possible, and definitely needs specific code for Ignition tag JSON

---

<div class="post-metadata">

**Author:** ![bkarabinchak.psi](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/bkarabinchak.psi/32/83567_2.png) [@bkarabinchak.psi](https://forum.inductiveautomation.com/u/bkarabinchak.psi)\
**Post date:** [August 23, 2022, 2:11pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/23 "2022-08-23T14:11:58Z")

</div>

Yea not in a notepad++/generic json tool right. But if the unique tag id that’s stored in the database was included as part of the json data, it seems vey doable with a script and perhaps should be part of a module or something they provide as a built in feature.

---

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [August 23, 2022, 3:53pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/24 "2022-08-23T15:53:43Z")

</div>

Just to follow up on this, I have created a feature request to add something like this to Ignition.

At this point (and as far as future plan go), tag definitions are stored in a SQLite DB in individual rows and loaded into memory so everything that you are likely using for making this comparison currently is based on what is pulled from Ignition’s memory. While there are things that Phil mentioned that could be done to order the output, there is also a performance cost associated with doing so. While we can look at making the output ordered in a consistent manner, forcing what could be 500k+ tags to return in an ordered manner is likely going to use a good amount more memory. A dedicated tool is probably something we should be investing in.  
Garth

---

<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:** [August 23, 2022, 4:20pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/25 "2022-08-23T16:20:45Z")

</div>

> [@ggross](#):
>
> While there are things that Phil mentioned that could be done to order the output, there is also a performance cost associated with doing so.

A SQLite index on path and name would probably suffice, and might not be as ugly performance-wise as you think.

Hopefully for v8.2 or so, the source of truth will be JSON on disk instead of in SQLite. If so, please consider using a hierarchy where tag folders are actual folders on disk, UDT definitions and instances are one file each with contents ordered by name, and all other leaf tags in a folder are in a single JSON file, ordered by name.

Make all json diff-friendly with tidyjson/jsonlint/whatever.

Use "version sort" or `AlphaNumComparator` so numbers in tag names are ordered the way humans like.

This above will be very git-friendly and, since each file will be sorted only when edited, should not present a performance problem at other times.

---

<div class="post-metadata">

**Author:** ![paul-griffith](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/paul-griffith/32/37249_2.png) [@paul-griffith](https://forum.inductiveautomation.com/u/paul-griffith)\
**Post date:** [August 23, 2022, 4:26pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/26 "2022-08-23T16:26:23Z")

</div>

> [@pturmel](#):
>
> If so, please consider using a hierarchy where tag folders are actual folders on disk

Filesystem traversal is expensive too... 😬

I don't know the exact details, but I do know that making things (especially gateway config things) VCS-friendlier is a major consideration for 8.2.

---

<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:** [August 23, 2022, 4:36pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/27 "2022-08-23T16:36:56Z")

</div>

> [@paul-griffith](#):
>
> Filesystem traversal is expensive too…

Meh. Applicable in bulk only on startup. Parallelizable where SQLite is not. With the suggested hierarchy, edits are confined to a limited target space. Putting leaf tags in one file per folder also helps.

---

<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:** [August 23, 2022, 4:41pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/28 "2022-08-23T16:41:56Z")

</div>

Oh, and memory tag persistent values/timestamps should _ **not** _ be in the same hierarchy. Might even be best to keep those in a DB, with just a primary key saved in the JSON.

---

<div class="post-metadata">

**Author:** ![chandler](https://avatars.discourse-cdn.com/v4/letter/c/e9a140/32.png) [@chandler](https://forum.inductiveautomation.com/u/chandler)\
**Post date:** [August 24, 2022, 2:10pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/29 "2022-08-24T14:10:00Z")

</div>

This is obviously not a big deal, but something that I noticed is that the number of tags has a formatting problem.

 ![tag_report_formatting](https://us1.discourse-cdn.com/inductiveautomation/original/3X/4/4/44a9e3bbfbdf42a98881a145549016f3accb7e8e.png)

---

<div class="post-metadata">

**Author:** ![hpark](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/hpark/32/21222_2.png) [@hpark](https://forum.inductiveautomation.com/u/hpark)\
**Post date:** [August 24, 2022, 6:40pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/30 "2022-08-24T18:40:55Z")

</div>

Hi there! Our design team at Inductive Automation is interested to hear about your experiences with this Tag Report Tool so far, now that the feature has been available for a while. We would appreciate it if you could spend a few minutes (approx. 5 mins) completing our survey. Thank you very much and have a wonderful day!

Survey Link: [Take Survey](https://forms.gle/g1Yk4YGBYAMD8KBN7)

---

<div class="post-metadata">

**Author:** ![wdougmiller](https://avatars.discourse-cdn.com/v4/letter/w/a9a28c/32.png) [@wdougmiller](https://forum.inductiveautomation.com/u/wdougmiller)\
**Post date:** [August 29, 2022, 6:54pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/31 "2022-08-29T18:54:00Z")

</div>

Value \> 0 (for example) isnt working for me since my Value looks like the example below. Is there a certain query language for drilling into Value?

```auto
[0.7815788, Good, Mon Aug 29 13:49:19 CDT 2022 (1661798959677)]

```

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [August 29, 2022, 7:30pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/32 "2022-08-29T19:30:00Z")

</div>

That is a Qualified Value, which is a Tag value that has three attributes; Value, Quality, and TimeStamp. You will need to reference value with `.value`.

What exactly does your question have to do with the tag report tool by the way?

---

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [August 29, 2022, 7:34pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/33 "2022-08-29T19:34:20Z")

</div>

@wdougmiller,

`Value` in the Tag Report Tool is currently returning a qualified value as noted above by @jlandwerlen. We are working on a polish ticket where we are addressing this so that the individual aspects of the qualified value can be searched for.

Garth

---

<div class="post-metadata">

**Author:** ![wdougmiller](https://avatars.discourse-cdn.com/v4/letter/w/a9a28c/32.png) [@wdougmiller](https://forum.inductiveautomation.com/u/wdougmiller)\
**Post date:** [August 29, 2022, 10:46pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/34 "2022-08-29T22:46:51Z")

</div>

@jlandwerlen I copied that value straight from the Tag Report Tool, trying to build a report to show just tags where the value \>= x. but it failed everytime bc the value is a Qualified Value, as you pointed out.

thanks @ggross, looking forward to that update.

---

<div class="post-metadata">

**Author:** ![jlandwerlen](https://avatars.discourse-cdn.com/v4/letter/j/bc8723/32.png) [@jlandwerlen](https://forum.inductiveautomation.com/u/jlandwerlen)\
**Post date:** [August 29, 2022, 10:55pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/35 "2022-08-29T22:55:20Z")

</div>

So when you run the tool, you are presented with an option to copy as script. I haven’t tried, but you could get the raw results then check the value then and use that data in your report.

---

<div class="post-metadata">

**Author:** ![wdougmiller](https://avatars.discourse-cdn.com/v4/letter/w/a9a28c/32.png) [@wdougmiller](https://forum.inductiveautomation.com/u/wdougmiller)\
**Post date:** [August 29, 2022, 11:44pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/36 "2022-08-29T23:44:57Z")

</div>

@jlandwerlen thanks for the tip. we were really just playing around with the new tool and hit that road block. not in a rush to implement anything with it. looks like there is a lot of potential tho.

---

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [September 9, 2022, 9:17pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/37 "2022-09-09T21:17:51Z")

</div>

Just an update on all the feedback that has been presented. We have just merged the polish ticket that will be available in nightlies starting tomorrow (9/10) and will be part of the 8.1.21 release. Some of the items (a few mentioned in this post) that are fixed/added:

1. Values and Timestamps of tags can be explicitly searched for
2. Alarm definitions are being consistently returned in the results
3. A column can be added to display a list of overridden properties
4. If you are deleting tags, the number of tags being deleted is accurate
5. Ability to include/non-include UDT members in the search results
6. Ability to include UDT definitions in the search results
7. Folders and UDT instances are no longer returning when Uncertain quality is looked for
8. If the Tag Report tool is closed, the settings you had are persisted when it is reopened
9. A `NOT LIKE` search has been added
10. Various UI fixes regarding column sizing and field display issues

I am hoping this improves on what we have already built.

Thanks,  
Garth

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [September 13, 2022, 12:40am UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/38 "2022-09-13T00:40:18Z")

</div>

Sounds great! Looking forward to using this in the future 🙂  
Will there (or are there already) be context menu actions available on certain things that let you pre-fill and search based on the thing selected?  
e.g.  
right click on tag, select “find usage”  
right click on UDT instance, select “find Definition usage”  
right click on UDT Definition, select “find usage”  
etc.

The same thing would be extremely useful for Views as well,  
right click on View, select “find usage” (e.g. for views that are embedded)

The inverse for both would also be good, to find dependencies, although a little harder to implement.  
Dependencies would include anything from script libraries used, embedded views used (and nested views inside of these), styles, etc. within the View you selected. For tags, this would include script libraries (for event handlers), alarm pipelines, history providers/db, UDT definitions, etc.  
Vote here: [Report tool to show dependencies of views/windows/templates/tags | Voters | Inductive Automation](https://ideas.inductiveautomation.com/ignition-features-and-ideas/p/report-tool-to-show-dependencies-of-viewswindowstemplatestags)

In addition to this would also be great to be able to then export objects and include their dependencies. At the moment, it’s a real pain to package some Views up if they have multiple dependencies, especially if you don’t know what they are off the top of your head! It usually takes a few exports to get it right sometimes.  
Vote here: [Export component \*with dependencies\* | Voters | Inductive Automation](https://ideas.inductiveautomation.com/ignition-features-and-ideas/p/export-component-with-dependencies)

This reply has gotten a bit off-topic… so I’ve created separate topics for these as well as ideas

---

<div class="post-metadata">

**Author:** ![ggross](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/ggross/32/12668_2.png) [@ggross](https://forum.inductiveautomation.com/u/ggross)\
**Post date:** [September 13, 2022, 3:31pm UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/39 "2022-09-13T15:31:01Z")

</div>

> [@nminchin](#):
>
> Will there (or are there already) be context menu actions available on certain things that let you pre-fill and search based on the thing selected?

This is coming, it is something we are testing as this point but was contingent on these changes getting merged. Might not be exactly as you are describing, but will achieve the same results.

Dependancies is something we are working towards, but it is going to be a little while before it is ready for production.

Garth

---

<div class="post-metadata">

**Author:** ![nminchin](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/nminchin/32/6911_2.png) [@nminchin](https://forum.inductiveautomation.com/u/nminchin)\
**Post date:** [November 17, 2022, 6:33am UTC](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594/40 "2022-11-17T06:33:25Z")

</div>

I've finally had the chance to put this tool to use, and it's super cool! I love all the fields that you can add into the table, and all of the filtering customisations are _very_ useful and appreciated! 😍

Thanks guys and gals for all your hard work.

Edit:  
One extra column option that would be good would be to have Type Id to which the tag belongs to. To be extra annoying, if the tag is part of a UDT that is nested in another UDT, it would be great to show this AND be able to edit the underlying UDT definitions directly.

E.g. Column "Type Id' displayed value:  
`_types_/Devices/Pump 1 -> _types_/Devices/Pump Common` -\> `_types_/Devices/Some other UDT`

Right clicking on the Type Id value would show a context menu with options:

- Edit `_types_/Devices/Pump 1` Definition
- Edit `_types_/Devices/Pump Common` Definition
- Edit `_types_/Devices/Some other UDT` Definition

And obviously the option to edit the instance as well, which is the default edit option now

[Previous page](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594.md?page=1)

[Next page](https://forum.inductiveautomation.com/t/new-feature-tag-report-tool/61594.md?page=3)
