X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Fmod_req_failure.gsql;h=887f1cb94bfeaa30be0d9fbae528cb86ac1ef78a;hb=0eb834e581b25c0ac0a657b1b7d8bb70fe4d2aa9;hp=96a274eae0ab6ebdc330bc5f0723c30c48bbb3c8;hpb=7f09b7d24896c782a3e599ec35f76a42d2abd306;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/mod_req_failure.gsql b/mc-core/mc/queries/mod_req_failure.gsql index 96a274e..887f1cb 100644 --- a/mc-core/mc/queries/mod_req_failure.gsql +++ b/mc-core/mc/queries/mod_req_failure.gsql @@ -1,5 +1,6 @@ DEFINE{ query_name 'mod_req_failure_distribution'; max_lfta_disorder '1'; max_hfta_disorder '1'; + commetn 'distribution of causes of a modification requet failure'; } PARAM{ window uint;} @@ -14,6 +15,6 @@ select ($window*(tb+1))/1000 as TS, sum(EQ(UINT(failureType),5)) as count_scg_reconfigFailure, sum(EQ(UINT(failureType),6)) as count_srb3_IntegrityFailure From SGNBMODREQ.sgnb_mod_req -where schemaId=1201 +// where schemaId=1201 group by timestamp_ms/$window as tb