X-Git-Url: https://gerrit.o-ran-sc.org/r/gitweb?a=blobdiff_plain;f=mc-core%2Fmc%2Fqueries%2Fdc_conn_stats.gsql;h=eec71a2fc1be834c474b9fb7fc45f2468b74109c;hb=refs%2Fchanges%2F49%2F2549%2F2;hp=155186904109cfdb3d4b8eef6902a2ccb527914c;hpb=9b604aeefe0126a54dccf312cb24c2649f221a4a;p=ric-app%2Fmc.git

diff --git a/mc-core/mc/queries/dc_conn_stats.gsql b/mc-core/mc/queries/dc_conn_stats.gsql
index 1551869..eec71a2 100644
--- a/mc-core/mc/queries/dc_conn_stats.gsql
+++ b/mc-core/mc/queries/dc_conn_stats.gsql
@@ -7,7 +7,7 @@ select timestamp_ms as timestamp,
 	UINT(id_SgNB_UE_X2AP_ID) as gUE_ID,
 	1 as event_type
 from RECONCOMPLETE.reconfig_success
-where schemaId=101
+// where schemaId=101
 ;
 
 DEFINE{query_name 'dc_terminate';
@@ -19,7 +19,7 @@ select timestamp_ms as timestamp,
 	id_SgNB_UE_X2AP_ID as gUE_ID,
 	0 as event_type
 from CONRELEASE.dc_release
-where schemaId=201
+// where schemaId=201
 ;
 
 DEFINE{query_name 'dc_events';}
@@ -43,6 +43,7 @@ CLOSING_WHEN LAST(event_type) = 0
 
 DEFINE{ query_name 'mc_connected_cnt'; 
 	max_lfta_disorder '1'; max_hfta_disorder '1';
+	comment 'Number of dual connected users';
 }
 PARAM{ window uint; }
 SELECT ($window*(TB+1))/1000 as TS, 
@@ -67,6 +68,7 @@ CLOSING_WHEN LAST(event_type) = 0
 
 DEFINE{ query_name 'mc_connection_stats'; 
 	max_lfta_disorder '1'; max_hfta_disorder '1';
+	comment 'statistics about the length of dual connected sessions';
 }
 PARAM{ window uint; }
 SELECT ($window*(TB+1))/1000 as TS, 
@@ -86,6 +88,7 @@ GROUP BY (TB_1000 * 1000) / $window as TB
 
 DEFINE{ query_name 'mc_connects_cnt'; 
 	max_lfta_disorder '1'; max_hfta_disorder '1';
+	comment 'number of DC connection requests';
 }
 PARAM{ window uint; }
 SELECT ($window*(TB+1))/1000 as TS,
@@ -98,6 +101,7 @@ GROUP BY timestamp / $window as TB
 
 DEFINE{ query_name 'mc_disconnects_cnt'; 
 	max_lfta_disorder '1'; max_hfta_disorder '1';
+	comment 'number of DC connection releases';
 }
 PARAM{ window uint; }
 SELECT ($window*(TB+1))/1000 as TS, 
@@ -119,6 +123,7 @@ GROUP BY timestamp / $window as TB, gUE_ID as UE_ID
 
 DEFINE{ query_name 'mc_unique_ue_cnt'; 
 	max_lfta_disorder '1'; max_hfta_disorder '1';
+	comment 'Number of distinct UEs making a DC request or release';
 }
 PARAM{ window uint; } 
 SELECT ($window*(TB+1))/1000 as TS,