-
Re: Find last change of pipoint and return the changed time
Lal_Babu_Shaik
Jul 2, 2018 5:17 AM
Hi Tom,
You can use PI builder --> PI Point -->change date attribute to check when pipoint was last changed. You can also check using PI OLEDB to check the same. If you are looking for the data change, you can use PrevEvent PE.
-
Re: Find last change of pipoint and return the changed time
i need to read it automatically true excel vba is that also possible?
-
Re: Find last change of pipoint and return the changed time
Eugene Lee
Jul 2, 2018 5:49 AM
If you are not writing out of order data to the PI Point, you can just read the Snapshot property of the PIData object and obtain the timestamp of the snapshot.
Otherwise, another method of tracking changes to a PIPoint's value is through use of the EventPipe property of the PIData object.
-
Re: Find last change of pipoint and return the changed time
Would you have have the option to use AF Analysis to write the timestamp to an attribute for your use? Can use the PrevEvent call for that tag and write it to an attribute.
-
Re: Find last change of pipoint and return the changed time
yes that's possible, do you also know how to write the PrevEvent call in vba?
-
Re: Find last change of pipoint and return the changed time
what i meant was that in AF Analytics you could have an analysis for this calculation done, then write the output to an attribute. from there, just display that new attribute on the sheet instead of writing it in vba. I do not know the vba that would be required for it as we do ours in AF Analytics.
-
-
-
-