Title		Author	Latest activity	Views
	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	314	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	87	Show 1 Likes1	Show 0 Bookmarks0	5 Replies5
	query to contextualize EFs AND archived attribute values	narburgh	October 31, 2019 6:04:34 AM by narburgh	58	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	28	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	47	Show 0 Likes0	Show 0 Bookmarks0	1 Replies1
	PI JDBC connection error	kuehcj	October 9, 2019 12:37:02 AM by kuehcj	212	Show 0 Likes0	Show 0 Bookmarks0	3 Replies3
	piavg vs pitotal - both return same value???	hodneeri	September 23, 2019 7:48:57 PM by hodneeri	489	Show 0 Likes0	Show 0 Bookmarks0	7 Replies7
	Execution timed out with piinterp table	sharon.meng	September 9, 2019 8:44:09 AM by sharon.meng	70	Show 1 Likes1	Show 0 Bookmarks0	5 Replies5
	PI SQL Commander Query	Bhavesh_22	September 9, 2019 4:26:46 AM by Bhavesh_22	621	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	142	Show 3 Likes3	Show 0 Bookmarks0	6 Replies6
	PI OLEDB Select question	DaveThompson	August 29, 2019 12:49:32 PM by DaveThompson	91	Show 0 Likes0	Show 0 Bookmarks0	3 Replies3
	Data INSERT not persisting after restart.	Etienne	August 23, 2019 5:38:13 AM by Etienne	37	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	1938	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	39	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	77	Show 1 Likes1	Show 0 Bookmarks0	3 Replies3
	PI JDBC Driver Java compatibility	hodneeri	June 24, 2019 9:57:48 AM by hodneeri	290	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	80	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	108	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	357	Show 3 Likes3	Show 0 Bookmarks0	3 Replies3
	How to avoid two values with same timestamp	Jörg-Detlef Kern	June 11, 2019 2:48:24 PM by Jörg-Detlef Kern	1350	Show 2 Likes2	Show 0 Bookmarks0	11 Replies11