matt.inglis

Retrieve Stale Points in ODBC getPointsSQL

Discussion created by matt.inglis on Jan 24, 2013
Latest reply on Jan 28, 2013 by scheung

Im also trying to retrieve a list of "stale" points from my piserver by stale im classing those which haven't had data in n* days (which will be user configured)

 

My trial failed however..

 

MyPIServer.GetPointsSQL("PIcomp.Tag = '*' AND PIcomp.Time >= DATE(\"*-30d\");

 

My queries however keep failing on syntax, is there a way to pull out specifically the Snapshot timestamp for each tag checking if it is older than 30days old and returning the tagname if it is?

Outcomes