AnsweredAssumed Answered

Export big amount of data from PI data archive to csv file

Question asked by Saken on Jun 27, 2018
Latest reply on Jun 27, 2018 by tramachandran

Hi,

looking for the way to export big amount of data from PI data archive to csv file in format: tag,time,value

 

I found following link https://pisquare.osisoft.com/message/106803-re-pi-sql-query-results-to-file#comment-106803 where piconfig used.

 

piconfig -node PiServerName -port 5450 -username UserNameHere -password PasswordHere < c:\test\PiExtract.txt

 

How can I put list of tags and start time and end time to the line above, I need data for 5000 tags for about two year?

 

thanks,

S

Outcomes