X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Frelease_req_time.gsql;h=38c3ffd294051963693eca74205c6d34e448b587;hb=c82aceb49b50fc5a94582360ed0e7ebbe10fa809;hp=9b4c64d3b3d726123f4ca681acdb6a4799f4aefe;hpb=9b604aeefe0126a54dccf312cb24c2649f221a4a;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..38c3ffd 100644 --- a/mc-core/mc/queries/release_req_time.gsql +++ b/mc-core/mc/queries/release_req_time.gsql @@ -10,11 +10,11 @@ select timestamp_ms as timestamp, gnb_id, 0 as event_type from RELREQ.release_req -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 +25,6 @@ select timestamp_ms as timestamp, gnb_id, 1 as event_type from CONRELEASE.dc_release -where schemaId=201 ; DEFINE{query_name 'release_req_events'; @@ -50,6 +49,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,