Hi, I'm trying to figure how to retreive PI point archived and timestamped based on the AF structure in an SQL query.
As minimum, where can I find the documentation that defines the relationship between the AF tables in a linked server in SQL Studio?
Thanks,
Simon Laliberté
This post helped me figure out how to do it:
https://pisquare.osisoft.com/message/69137#comment-69137
I could I knew that there was a timestamp column associated with DATA.ARCHIVE table from my AFLinkedServer?!?
SELECT [ElementAttributeID]
,[Value]
,[ValueInt]
,[ValueDbl]
,[ValueStr]
,[ValueGuid]
,[Status]
,[Annotated]
,[IsGood]
,[Questionable]
,[Substituted]
FROM [LINKED_AFSERVER].[DBName].[Data].[Archive]
GO