AnsweredAssumed Answered

How to list PI tags in AF Database

Question asked by matthew.rivett on Jan 8, 2019
Latest reply on Jan 9, 2019 by Lal_Babu_Shaik

I need to periodically copy an AF database and change the data archive server the PI Point Data References refer to.

 

I usually export the AF database as XML, do a find and replace on the server name.  This won't however create PI tags with the correct configuration on the other data archive server.  I can pull the tag name using PI Builder but that process is quite manual.

 

Is there an easy way to extract all the PI tags in use by an AF model?  I'd be interested in querying the PIFD SQL database directly or using some other method to list out the PI tags.  I would then import their configuration from the original data archive server and create/update the other data archive server.

 

Or is there a better way to accomplish this?  The important part is that the second data archive server is manually updated.  It doesn't have the same automation to create/update tags as the first data archive server.

 

Thanks,

Matt

Outcomes