1 DEFINE{query_name 'reconfig_status_start';}
3 select timestamp_ms as timestamp,
4 non_temporal(timestamp_ms) as start_time,
6 id_MeNB_UE_X2AP_ID as eUE_ID,
9 from SGNB_ADDITION_REQ.sgnb_addreq_for_ue
13 DEFINE{query_name 'reconfig_status_success';}
15 select timestamp_ms as timestamp,
17 non_temporal(timestamp_ms) as end_time,
18 id_MeNB_UE_X2AP_ID as eUE_ID,
21 from RECONCOMPLETE.reconfig_success
25 DEFINE{query_name 'reconfig_status_events';}
27 merge p1.timestamp : p2.timestamp
28 from reconfig_status_start p1, reconfig_status_success p2
32 DEFINE{query_name 'reconfig_status_merge';
33 max_lfta_disorder '1'; max_hfta_disorder '1';
36 select eUE_ID, gnb_id, TB,
37 max(start_time) as max_start_time,
38 max(end_time) as max_end_time
39 from reconfig_status_events
40 group by eUE_ID, gnb_id, timestamp / $window as TB
43 DEFINE{query_name 'reconfig_status_success_rate';
44 max_lfta_disorder '1'; max_hfta_disorder '1';
47 select gnb_id as GNB_ID,
48 ($window*(TB+1))/1000 as TS,
49 $window/1000.0 as measurementInterval,
50 count(*) as total_reconfiguration_requests,
51 sum(GEQ(max_end_time,ULLONG(1))) as successful_reconfiguration_requests,
52 FLOAT(sum(GEQ(max_end_time,ULLONG(1))))/count(*) as success_rate
53 from reconfig_status_merge
57 // ----------------------------------------------
58 // Merge in reconfig_reject causes and aggregate with this.
59 DEFINE{query_name 'reconfig_status_reject_cause';
60 max_lfta_disorder '1'; max_hfta_disorder '1';
64 count(*) as total_reconfig_reject,
65 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
66 sum(GEQ(UINT(cause_transport),0)) as count_transport,
67 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
68 sum(GEQ(UINT(cause_misc),0)) as count_misc
69 from ADDREQREJECT.sgnb_add_req_reject
71 group by gnb_id, timestamp_ms / $window as TB
74 DEFINE{query_name 'reconfig_complete_reject_cause';
75 max_lfta_disorder '1'; max_hfta_disorder '1';
79 count(*) as total_reconfig_reject,
80 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
81 sum(GEQ(UINT(cause_transport),0)) as count_transport,
82 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
83 sum(GEQ(UINT(cause_misc),0)) as count_misc
84 from RECONCOMPLETE.reconfig_reject
86 group by gnb_id, timestamp_ms / $window as TB
89 DEFINE{query_name 'reconfig_reject_merge';}
92 from reconfig_status_reject_cause p1, reconfig_complete_reject_cause p2
95 DEFINE{query_name 'reconfig_reject_cause';
96 max_lfta_disorder '1'; max_hfta_disorder '1';
99 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
100 $window/1000.0 as measurementInterval,
101 sum(total_reconfig_refuse) as total_reconfig_refuse,
102 sum(count_radio_network) as count_radio_network,
103 sum(count_transport) as count_transport,
104 sum(count_protocol) as count_protocol,
105 sum(count_misc) as count_misc
106 from reconfig_cause_merge
110 // ----------------------------------------------
112 DEFINE{query_name 'mod_status_refuse_cause';
113 max_lfta_disorder '1'; max_hfta_disorder '1';
115 PARAM{ window uint; }
116 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
117 $window/1000.0 as measurementInterval,
118 count(*) as total_reconfig_refuse,
119 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
120 sum(GEQ(UINT(cause_transport),0)) as count_transport,
121 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
122 sum(GEQ(UINT(cause_misc),0)) as count_misc
123 from SGNBMODREFUSE.sgnb_mod_refuse
125 group by gnb_id, timestamp_ms / $window as TB
128 // ----------------------------------------------
129 DEFINE{query_name 'release_rqd_cause';
130 max_lfta_disorder '1'; max_hfta_disorder '1';
132 PARAM{ window uint; }
134 count(*) as total_reconfig_refuse,
135 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
136 sum(GEQ(UINT(cause_transport),0)) as count_transport,
137 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
138 sum(GEQ(UINT(cause_misc),0)) as count_misc
139 from SGNBRELEASERQD.SgNB_release_rqd
141 group by gnb_id, timestamp_ms / $window as TB
144 DEFINE{query_name 'release_request_cause';
145 max_lfta_disorder '1'; max_hfta_disorder '1';
147 PARAM{ window uint; }
149 count(*) as total_reconfig_refuse,
150 sum(GEQ(UINT(cause_radio_network),0)) as count_radio_network,
151 sum(GEQ(UINT(cause_transport),0)) as count_transport,
152 sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
153 sum(GEQ(UINT(cause_misc),0)) as count_misc
154 from RELREQ.release_req
156 group by gnb_id, timestamp_ms / $window as TB
159 DEFINE{query_name 'reconfig_cause_merge';}
160 PARAM{ window uint; }
162 from release_rqd_cause p1, release_request_cause p2
165 DEFINE{query_name 'release_cause';
166 max_lfta_disorder '1'; max_hfta_disorder '1';
168 PARAM{ window uint; }
169 Select gnb_id as GNB_ID, ($window*(TB+1))/1000 as TS,
170 $window/1000.0 as measurementInterval,
171 sum(total_reconfig_refuse) as total_reconfig_refuse,
172 sum(count_radio_network) as count_radio_network,
173 sum(count_transport) as count_transport,
174 sum(count_protocol) as count_protocol,
175 sum(count_misc) as count_misc
176 from reconfig_cause_merge