What is tables in PI pipoint..pipoint, piarchive..pisnapshot, piarchive..picomp2?
How to check data in it?
If you looking for snapshot data then request you to query pisnapshot. PIcomp will provide archive records and PIComp2 is indexed version of picomp.
Request you to check below reference to understand the tables.
Who is putting value in it?
Or Can we see that?
Sinusoid is a random tag for reference. Use PI SQL commander and connect to PI server to check the data.
Additional reference :https://pisquare.osisoft.com/videos/2660-write-queries-using-pi-oledb-provider-schema
Below query gives snapshot value inserted.
Below query gives archive values
Want to know which table is used for storing the Point Source?
As far as I know, the table you can see from PI-SMT plug-in on Point Source is not directly exposed over the PI OLEDB Provider.
But we have the following sample queries that might help you. If you could explain what you are trying to do, we can help you further.
-- Point Database Statements----------------------------------------- Sample queries-- Returns tags of point source "R" from the "classic" point class.SELECT tag, descriptor FROM pipoint..classic WHERE pointsource = 'R'-- Returns number of tags with the same point source attribute.SELECT pointsource, COUNT(*) FROM pipoint..classic GROUP BY pointsource-- Creates a "float32" tag in the "classic" point class.INSERT pipoint..classic (tag, pointtypex) VALUES ('TestTag', 'float32')-- Renames the "TestTag".UPDATE pipoint..classic SET tag = 'TestTag2' WHERE tag = 'TestTag'-- Deletes the "TestTag2".DELETE pipoint..classic WHERE tag = 'TestTag2'
You could use the pipoint2 table instead of classic if you wanted ALL tags.
SELECT pointsource, COUNT(*) FROM pipoint..pipoint2 GROUP BY pointsource
If you trying to find the source for a PI Tag I would recommend looking at the PointSource and Location 1 of the PI Tag in System Management Tools (SMT) under Points > Point Builder. Once you have that information you can cross-reference with the interface list for your Server in SMT > Interfaces > Interface List. This list will provide you with the interfaces and their associated point source/Interface ID (Location 1 on your PI Point) as well as the location/machine of where that interface is installed.
If the tag is not coming from an Interface, but rather a custom application, this process gets little trickier to identify the source of a tag's data. I might recommend reaching out to Tech Support as there are a lot of different, relatively, involved, ways of finding the source.
Also to round out Lal's Answer:
Retrieving data ...