Is there a way to extract a list of all manual tags in your PI system?
Maybe. If you have a list of distinct point sources for the tags which can be retrieved using PI SQL Commander, review the list and determine which point sources are probable 'manual' tags; that is, remove any that you can identify that are part of a known interface or other 'automated' system such as AF.
The point sources might be 'L', or 'Lab', or whatever someone decided to use.
Then, select that tags that have a point source from your reduced list.
Since the PI system doesn't force a tag to be part of an interface, it may be possible to have a tag that has a point source of 'OPC-HappyJack' (a wind site I previously worked with) and an interface ID of 2, but the Happy Jack interface has a point source of 1 - the tag will not be part of the interface and CAN be written to manually. Hopefully, that is not the case, but, I though it was prudent to give an example.
Retrieving data ...