X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Frelease_req_time.gsql;h=e1d0dee44c0979d44e270ec44facfb315bb22ace;hb=refs%2Fchanges%2F49%2F2549%2F2;hp=9b4c64d3b3d726123f4ca681acdb6a4799f4aefe;hpb=7f09b7d24896c782a3e599ec35f76a42d2abd306;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/release_req_time.gsql b/mc-core/mc/queries/release_req_time.gsql index 9b4c64d..e1d0dee 100644 --- a/mc-core/mc/queries/release_req_time.gsql +++ b/mc-core/mc/queries/release_req_time.gsql @@ -10,11 +10,12 @@ select timestamp_ms as timestamp, gnb_id, 0 as event_type from RELREQ.release_req -where schemaId=801 +// where schemaId=801 ; DEFINE{query_name 'release_req_success'; max_lfta_disorder '1'; max_hfta_disorder '1'; + comment 'statistics on the time to delease a DC connection'; } PARAM{ window uint; } select timestamp_ms as timestamp, @@ -25,7 +26,7 @@ select timestamp_ms as timestamp, gnb_id, 1 as event_type from CONRELEASE.dc_release -where schemaId=201 +// where schemaId=201 ; DEFINE{query_name 'release_req_events'; @@ -50,6 +51,7 @@ having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time) DEFINE{query_name 'release_req_success_stats'; max_lfta_disorder '1'; max_hfta_disorder '1'; + comment 'statistics on the time to delease a DC connection'; } PARAM{ window uint; } select gnb_id as GNB_ID,