AnsweredAssumed Answered

analysisService.QueryRuntimeInformation with parameters evaluations

Question asked by PedroCampos on Jul 17, 2019
Latest reply on Jul 18, 2019 by sraposo

I would like to retrieve all analyses stopped for a period Higher than theyr average Trigger. How can I perform this query? I only found examples with AFTime like '*-3d' but this is not what I want.

 

List<AnalysisDAO> analysisDAOs = new List<AnalysisDAO>();
var analysisService = _PISystem.AnalysisService;
string dateToQuery = DateTime.UtcNow.ToString("yyyy-MM-ddTHH:mm:ssZ");
// Retrieve query results as ordered fields
var results = analysisService.QueryRuntimeInformation(
queryString: @"path:'*"+_AFDatabase.Name+ "*' lastTriggerTime:<'"+ dateToQuery + "-averageTrigger' sortBy:'lastTriggerTime' sortOrder:'Desc'",
fields: "id name elementName status lastTriggerTime averageTrigger");

Outcomes