Name
global.OrchCoreTransactionQuery
Description
No description available
Script
var OrchCoreTransactionQuery = Class.create();
OrchCoreTransactionQuery.prototype = {
initialize: function() {
this.scopeQuery="activity.activity_definition.sys_scope.scopeNOT LIKEsn_hr_^activity.activity_definition.sys_scope.scopeNOT LIKEsn_sec_^activity.activity_definition.sys_scope.scopeNOT LIKEsn_si^activity.activity_definition.sys_scope.scopeNOT LIKEsn_ti^activity.activity_definition.sys_scope.scopeNOT LIKEsn_vul^EQ";
this.excludePlugins = ['com.snc.aws.activities', 'com.snc.aws.common', 'com.snc.aws.core',
'com.snc.discovery.aws', 'com.snc.ec2_v2', 'com.snc.orchestration.activities.ec2', 'com.snc.discovery.azure', 'com.snc.orchestration.activities.vmware', 'com.snc.runbook_automation.virtualization', 'com.snc.virtualization.core'];
},
getTransactionsCount:function(timePeriodQuery){
var count = 0;
var exeGr = new GlideAggregate("orch_execution");
exeGr.addAggregate("COUNT");
exeGr.addEncodedQuery(this.scopeQuery);
exeGr.addEncodedQuery(timePeriodQuery);
exeGr.addQuery('activity.activity_definition.sys_package.source', 'NOT IN', this.excludePlugins);
exeGr.query();
while(exeGr.next()) {
count = parseInt(exeGr.getAggregate("COUNT"));
}
return count;
},
getTransactionsCountMonthlyTrend:function(timePeriodQuery){
var trend =[];
var exeGr = new GlideAggregate("orch_execution");
exeGr.addAggregate("COUNT");
exeGr.addEncodedQuery(this.scopeQuery);
exeGr.addEncodedQuery(timePeriodQuery);
exeGr.addQuery('activity.activity_definition.sys_package.source', 'NOT IN', this.excludePlugins);
exeGr.addTrend ('sys_created_on','Month');
exeGr.query();
while(exeGr.next()) {
var timeref = exeGr.getValue('timeref');
var timerefArr = timeref.split('/');
var month = timerefArr[0];
var trendData = {month:month, count:parseInt(exeGr.getAggregate("COUNT"))};
trend.push(trendData);
}
return trend;
},
type: 'OrchCoreTransactionQuery'
};Sys ID
7e5523fab3833200176b051a16a8dccd