C# SDK - How to find the number of times a tag is under a certain value

Maybe try nvsSum["total"].value[1].value

That will give you back the value (might want make it a double).  Just nvsSum["total"].value[1] will return a PIValue.

Regards,

Dan

You can also use the PIData.RecordedValues method to find the number of time a tag is under a certain value (during a time period).

e.g.

PIValues sum = myPIdata.RecordedValues("*-30d", "*", BoundaryTypeConstants.btInside, expression, FilteredViewConstants.fvRemoveFiltered);
int p = sum.Count;

I have moved this post to the PI Developers Club > General Programming Languages subspace because community members there can best address your programming questions!

  Do you want to find the number of times the values is under 40 or the amount of time?

Dan

Hi jscotti, if you want the number of times, you shouldn't use the asTotal. Instead, you should use asCount. I have tested the code below on my machine and it works well. I have also removed the declaration of MyServer since you didn't use it anywhere else.

            PISDK.PISDK _pisdk = new PISDK.PISDK();
            PISDK.Server piServer = _pisdk.Servers.DefaultServer;
            PISDK.PIPoints myPoints;
            PISDK.PIPoint myPoint;
            PISDK.PIData myPIdata;
            PISDK.IPIData2 ipidata2;
            PISDKCommon.NamedValues nvsSum;
            PISDK.PIValues pvs;
            myPoints = piServer.PIPoints;
            myPoint = myPoints["cdt158"];
            myPIdata = myPoint.Data;
            ipidata2 = myPIdata as PISDK.IPIData2;
            string expression = "'cdt158' < 400";
            nvsSum = ipidata2.FilteredSummaries("*-30m", "*", null, expression, PISDK.ArchiveSummariesTypeConstants.asCount, PISDK.CalculationBasisConstants.cbEventWeighted, PISDK.FilterSampleTypeConstants.fstExpRecordedValues);
            pvs = nvsSum["Count"].Value;
            double n = pvs[1].Value;

This returns me a result of 1801 because all of my cdt158 events are under 400.

Hello Mr. Scotti,

Is there a reason why your are not using the AF SDK?  PI AF SDK is our latest technology, can connect to both PI Data Archive and AF.  It is regularly updated, benefits from newest technologies and is the recommended SDK to use for new projects.

Having this said, in case you would like to achieve the same thing using the AF SDK, I am providing you an example.  The example gives the number of occurrences (Count) where cdt158 exceeded 170.

Add a reference to OSIsoft.AFSDK

using OSIsoft.AF;
using OSIsoft.AF.PI;
using OSIsoft.AF.Data;
using OSIsoft.AF.Time;

public static void FilteredSummariesExample()
        {
            var piserver = PIServer.FindPIServer("Optimus");
            piserver.Connect();

            var point = PIPoint.FindPIPoint(piserver,"cdt158");
           
            var timeRange = new AFTimeRange("*-2h", "*");
            var res = point.FilteredSummaries(timeRange,
                                    new AFTimeSpan(timeRange.Span),          // calculation window, since we want a single result, we make it equal to our time range
                                    "'cdt158'>170",                          // true/false expression evaluated for one minute window
                                    AFSummaryTypes.Count,                    // summary to return
                                    AFCalculationBasis.EventWeighted,        // base
                                    AFSampleType.ExpressionRecordedValues,   // sampling, interpolated or recorded values
                                    AFTimeSpan.Zero,                         // Sampling interval, N/A in this case
                                    AFTimestampCalculation.Auto              //
                                    );


            Console.WriteLine(string.Format("Number of results:{0}", res[AFSummaryTypes.Count].Count));
            Console.WriteLine(string.Format("Number of times 'cdt158'>170 :{0}", res[AFSummaryTypes.Count].First().Value));


        }