// Merge in reconfig_reject causes and aggregate with this.
DEFINE{query_name 'reconfig_status_reject_cause';
max_lfta_disorder '1'; max_hfta_disorder '1';
// Merge in reconfig_reject causes and aggregate with this.
DEFINE{query_name 'reconfig_status_reject_cause';
max_lfta_disorder '1'; max_hfta_disorder '1';
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from ADDREQREJECT.sgnb_add_req_reject
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from ADDREQREJECT.sgnb_add_req_reject
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from RECONCOMPLETE.reconfig_reject
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from RECONCOMPLETE.reconfig_reject
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from SGNBMODREFUSE.sgnb_mod_refuse
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from SGNBMODREFUSE.sgnb_mod_refuse
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from SGNBRELEASERQD.SgNB_release_rqd
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from SGNBRELEASERQD.SgNB_release_rqd
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from RELREQ.release_req
sum(GEQ(UINT(cause_protocol),0)) as count_protocol,
sum(GEQ(UINT(cause_misc),0)) as count_misc
from RELREQ.release_req