I inherited an old Ignition server recently, and have been learning how to administer it. I’ve successfully upgraded it to v8.1.7 from 7.9 And I’ve cleaned up (deleted) a lot of obsolete devices and old tags.
Currently I only have 10 connected devices, and when I look at each one with the Status, Devices, Details screens and add up the Monitored Item Count I see a total of 4,741 items (tags?).
But the Status, Tags screen on the Gateway says I have a Tag Count of 29,053. I need to find out what these 29,053 tags are connected to, and to delete most of them.
I have access to the default DB (Oracle in this case), and I could probably query for this with PL SQL if I knew the tables to look in. When I connect to the DB I see a LOT of different Schemas and at hundreds (a few thousand?) tables.
How should I find and delete the 25,000-ish orphan tags?