How can we query the time stamp of an AF Attribute (refers to a PI tag) using PI SQL?
We are using the Transpose function to query all attributes of a template. We will also need to get the time stamps of the attributes. Can this be done?
Are you looking to get the timestamp of the snapshot event? You can use Transpose Snapshot on elements of an template such as the example here:
PI OLEDB Enterprise Transpose Snapshot
Barry, thanks for getting back!
This only gives the Snapshot value. I need the timestamp of when the snapshot was received.
The information you are looking for is usually not exposed. I am not sure if Auditing the PI Server User Manual may be useful for you. The time of when a PI Points snapshot received it's last update is however not available via SQL Data Access.
Can you elaborate on your use case?
Retrieving data ...