-
Re: Find last change of pipoint and return the changed time
Lal_Babu_ShaikJul 2, 2018 5:17 AM (in response to tomboersma)
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
tomboersma Jul 2, 2018 5:20 AM (in response to Lal_Babu_Shaik)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 LeeJul 2, 2018 5:49 AM (in response to tomboersma)
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
twipf Jul 2, 2018 5:08 PM (in response to tomboersma)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
tomboersma Jul 3, 2018 4:32 AM (in response to twipf)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
twipf Jul 9, 2018 5:21 PM (in response to tomboersma)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.
-
-
-
-