1 Reply Latest reply on Dec 6, 2018 4:19 PM by SimonLaliberte

Timestamp data through AF structure in SQL query

SimonLaliberte Dec 6, 2018 3:25 PM

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é

Re: Timestamp data through AF structure in SQL query

SimonLaliberte Dec 6, 2018 4:19 PM (in response to SimonLaliberte)

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
Like Show 0 Likes(0)

Actions