Historian T-Sql update on vValue.

Question

My client uses the vValue to store the user-selected reason description for the alarm. Would I be able to update the vValue in Historian with a new reason string?

Elliott Middleton · Answer

To perform SQL UNSERTs/UPDATEs on the extension tables requires the login to be an "aaAdministrator". 
 Also, not sure if this changed from older releases, but using Historian 2023 R2, the "INSERT History (DateTime, v Value..." doesn't work for me, but you can replace this with "INSERT String History (DateTime, Value ..."

Historian T-Sql update on vValue.

Top Replies