Title		Author	Latest activity	Views
	oledb download	LIUDAWEI	December 10, 2019 11:13:25 AM by LIUDAWEI	109	Show 0 Likes0	Show 0 Bookmarks0	1 Replies1
	All. How do I make a connection with JMP and PI using PI OLEDB? I would want to know the steps.	Santachow	November 18, 2019 1:58:32 PM by Santachow	549	Show 1 Likes1	Show 0 Bookmarks0	6 Replies6
	I am trying in MS-SQL to write: SELECT [tag],[time],[value],[status] ,[timestep]  FROM [PI].[piarchive]..[piinterp2] Where tag = 'sinusoid' and [time] between '*-1h' and '*'and [timestep] = '30m' GO	BjaNyg	November 5, 2019 11:02:19 AM by BjaNyg	201	Show 2 Likes2	Show 0 Bookmarks0	5 Replies5
	query to contextualize EFs AND archived attribute values	narburgh	October 31, 2019 6:04:34 AM by narburgh	77	Show 1 Likes1	Show 0 Bookmarks0	5 Replies5
	Link to download PI JDBC Driver setup kit	MINHTRAM	October 31, 2019 4:46:18 AM by MINHTRAM	390	Show 0 Likes0	Show 0 Bookmarks0	1 Replies1
	We have installed RQTP Data Engine and I can query through SQL Client to get values from AF database.  How do I use PI SQL Client to query tags that are not in the AF but are solely in the Data Archive?	SharZ	October 17, 2019 2:05:04 PM by SharZ	123	Show 0 Likes0	Show 0 Bookmarks0	1 Replies1
	PI JDBC connection error	kuehcj	October 9, 2019 12:37:02 AM by kuehcj	317	Show 0 Likes0	Show 0 Bookmarks0	3 Replies3
	Execution timed out with piinterp table	sharon.meng	September 9, 2019 8:44:09 AM by sharon.meng	201	Show 1 Likes1	Show 0 Bookmarks0	5 Replies5
	PI SQL Commander Query	Bhavesh_22	September 9, 2019 4:26:46 AM by Bhavesh_22	915	Show 0 Likes0	Show 0 Bookmarks0	4 Replies4
	Extract data from PI System Management Tools(Archive Editor)	ziadelghoul	September 6, 2019 3:03:00 PM by ziadelghoul	271	Show 3 Likes3	Show 0 Bookmarks0	6 Replies6
	PI OLEDB Select question	DaveThompson	August 29, 2019 12:49:32 PM by DaveThompson	232	Show 0 Likes0	Show 0 Bookmarks0	3 Replies3
	Data INSERT not persisting after restart.	Etienne	August 23, 2019 5:38:13 AM by Etienne	40	Show 1 Likes1	Show 0 Bookmarks0	2 Replies2
	How to get previous value for AF attributes?	wilsona	August 22, 2019 2:33:40 PM by wilsona	2494	Show 3 Likes3	Show 0 Bookmarks0	4 Replies4
	PI Data link Calculated Max Value Ignore Dates	AndrewCamuso	July 19, 2019 1:39:30 AM by AndrewCamuso	41	Show 0 Likes0	Show 0 Bookmarks0	1 Replies1
	where can i download software and interfaces from? where is the download area of the customer portal? please make it easier to find	ctgarvey2	July 10, 2019 1:01:56 PM by ctgarvey2	113	Show 1 Likes1	Show 0 Bookmarks0	3 Replies3
	PI JDBC Driver Java compatibility	hodneeri	June 24, 2019 9:57:48 AM by hodneeri	545	Show 0 Likes0	Show 0 Bookmarks0	4 Replies4
	How to extract 1-minute average once per hour?	rfmii	June 19, 2019 10:06:20 PM by rfmii	150	Show 0 Likes0	Show 0 Bookmarks0	2 Replies2
	How to consume Event Frames from AF DB using PI SQL Commander?	ccastro	June 12, 2019 6:45:28 PM by ccastro	136	Show 3 Likes3	Show 0 Bookmarks0	2 Replies2
	NEED INSTALL KIT OF PI OLEDB ENTERPRISE 2017 R2	AKASH MISAL	June 12, 2019 9:06:33 AM by AKASH MISAL	496	Show 3 Likes3	Show 0 Bookmarks0	3 Replies3
	I need to copy all values from one tag to another backup tag. What is the best way ?	Dante_QP	June 3, 2019 1:38:50 AM by Dante_QP	183	Show 3 Likes3	Show 0 Bookmarks0	3 Replies3