X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Fadmitted_erabs.gsql;h=1e1523220ff12aecaa5347372244736f1dcf7d97;hb=9b604aeefe0126a54dccf312cb24c2649f221a4a;hp=4ce30f2e95a92692e699ecc573809f541be59ce2;hpb=31d238a2cba18b87e05a7d9b4820db2c5186c658;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/admitted_erabs.gsql b/mc-core/mc/queries/admitted_erabs.gsql index 4ce30f2..1e15232 100644 --- a/mc-core/mc/queries/admitted_erabs.gsql +++ b/mc-core/mc/queries/admitted_erabs.gsql @@ -3,7 +3,9 @@ // Compromise between ensuring that most add_req_ack-recon_complete pairs // are caught while avoiding duplicates due to short sessions // NB: $window should be a multiple of 10. -DEFINE{query_name 'erab_stats_join';} +DEFINE{query_name 'erab_stats_join'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } select e.timestamp_ms/10000 as TB10, e.id_SgNB_UE_X2AP_ID, e.e_RAB_ID, e.qCI INNER_JOIN from SGNB_ADDITION_REQ_ACK.eRABs_acked_for_admit_for_ue e, @@ -13,7 +15,9 @@ and r.id_SgNB_UE_X2AP_ID = e.id_SgNB_UE_X2AP_ID and r.timestamp_ms/10000 = e.timestamp_ms/10000 ; -DEFINE{query_name 'erab_stats';} +DEFINE{query_name 'erab_stats'; + max_lfta_disorder '1'; max_hfta_disorder '1'; +} PARAM{ window uint; } Select (TB*$window)/1000 as TS, $window/1000.0 as measurementInterval,