To be able to easily delete all tags that are not being used as an attribute reference in AF.
I have a total of 150000 tags on my dev server. I only use AF, so if a tag is not in AF I have no use for it. As I am testing things on my dev server, there are lots of things that I try that do not end up being used. I would like a way to easily delete all tags taht I am not using.
Kenneth Barber commented
I encountered a similar situation, except that I was trying to see which tags I still had to add to PI AF (I started with a bunch of tags and a completely empty PI AF). My solution was to use PI OLEDB Provider in Excel to get a list of all tags on the PI Data Archive. I used PI OLEDB Enterprise in Excel to get all attributes in PI AF and their associated tag, if any. With these 2 tables in Excel, you can use lookup functions to check if each value in one table is in the other.