I have thousands of Elements (all templatised) in an AF hierarchy, each of element has a number of attributes that I would like to periodically update the value of. Ideally I would not have to resort to AF SDK code. These attributes are not PI Point Data References in fact they have no data reference. I use these these attributes in analyses and I want to to avoid using Table Lookup for performance reasons.
For me the easiest way would be if I could write an SQL stored procedure which periodically updates the values using a linked server (using the PI OLEDBD Enterprise provider).
Is this possible?