Code Review
/
ric-app
/
mc.git
/ blobdiff
commit
grep
author
committer
pickaxe
?
search:
re
summary
|
shortlog
|
log
|
commit
|
commitdiff
|
review
|
tree
raw
|
inline
| side by side
CI: Add silent cmake SonarCloud scan
[ric-app/mc.git]
/
mc-core
/
mc
/
queries
/
addn_req_time.gsql
diff --git
a/mc-core/mc/queries/addn_req_time.gsql
b/mc-core/mc/queries/addn_req_time.gsql
index
a36420d
..
3451c99
100644
(file)
--- a/
mc-core/mc/queries/addn_req_time.gsql
+++ b/
mc-core/mc/queries/addn_req_time.gsql
@@
-7,7
+7,6
@@
select timestamp_ms as timestamp,
gnb_id,
0 as event_type
from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
gnb_id,
0 as event_type
from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
-where schemaId=401
;
DEFINE{query_name 'add_req_success';}
;
DEFINE{query_name 'add_req_success';}
@@
-19,7
+18,6
@@
select timestamp_ms as timestamp,
gnb_id,
1 as event_type
from RECONCOMPLETE.reconfig_success
gnb_id,
1 as event_type
from RECONCOMPLETE.reconfig_success
-where schemaId=101
;
DEFINE{query_name 'addreq_events';}
;
DEFINE{query_name 'addreq_events';}
@@
-29,7
+27,9
@@
from add_req_start p1, add_req_success p2
;
;
-DEFINE{query_name 'addreq_success_time';}
+DEFINE{query_name 'addreq_success_time';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+}
PARAM{ window uint; }
select eUE_ID, gnb_id, TB,
UINT(max(end_time)-max(start_time)) as success_time
PARAM{ window uint; }
select eUE_ID, gnb_id, TB,
UINT(max(end_time)-max(start_time)) as success_time
@@
-38,7
+38,10
@@
group by eUE_ID, gnb_id, timestamp / $window as TB
having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
;
having max(end_time)>0 and max(start_time)>0 and max(end_time)>max(start_time)
;
-DEFINE{query_name 'addreq_success_stats';}
+DEFINE{query_name 'addreq_success_stats';
+ max_lfta_disorder '1'; max_hfta_disorder '1';
+ comment 'statistics on the time to successfully make a DC connection';
+}
PARAM{ window uint; }
select gnb_id as GNB_ID,
($window*(TB+1))/1000 as TS,
PARAM{ window uint; }
select gnb_id as GNB_ID,
($window*(TB+1))/1000 as TS,