X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Fadmitted_erabs.gsql;h=21b971ea46cbcf5416183fb242e15c376d76f294;hb=0eb834e581b25c0ac0a657b1b7d8bb70fe4d2aa9;hp=1e1523220ff12aecaa5347372244736f1dcf7d97;hpb=7f09b7d24896c782a3e599ec35f76a42d2abd306;p=ric-app%2Fmc.git diff --git a/mc-core/mc/queries/admitted_erabs.gsql b/mc-core/mc/queries/admitted_erabs.gsql index 1e15232..21b971e 100644 --- a/mc-core/mc/queries/admitted_erabs.gsql +++ b/mc-core/mc/queries/admitted_erabs.gsql @@ -10,13 +10,14 @@ 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, RECONCOMPLETE.reconfig_success r -where r.schemaId = 101 and e.schemaId = 502 -and r.id_SgNB_UE_X2AP_ID = e.id_SgNB_UE_X2AP_ID +where // r.schemaId = 101 and e.schemaId = 502 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'; max_lfta_disorder '1'; max_hfta_disorder '1'; + comment 'number of admitted bearers and the distribution of their qCI'; } PARAM{ window uint; } Select (TB*$window)/1000 as TS,