I've got a customer, that wants to have their alarm setpoints (H, HH, L, LL, etc.) from System Platform and Enterprise SCADA (they run both) stored in PI, or some other external database. They also want to keep a history of these setpoints. I'm assuming I can expose these via OPC DA and pull them in with a PI interface, but that would be an insane amount of tags for data that rarely changes. The only alternative I can think of is periodically querying the SQL backend and saving anything that's different. I don't know if there's a way to say "give me all setpoints changed since x time". Has anyone done this before? Any ideas how I can accomplish it? Thanks!
