 |
善于提问，勤于回答，你也是专家
|
 |
问题已开启
(普通问题)
SQL脚本NSN
请问谁有提取PCU负荷的脚本，最好是能分细点的(256,1024分开的）
提取小区SD拥塞明细的脚本
按天提降功率的
小区切换相关的，最好能提取单个BSC的所有小区切换KPI
提取小区SD拥塞明细的脚本
按天提降功率的
小区切换相关的，最好能提取单个BSC的所有小区切换KPI
请发我邮箱13628685427@163.com 谢谢
提问者:
• NSNGSMSQL脚本关联 2016-06-16
• NSNGSMSQL脚本问题 2016-06-16
• NSNPlanEditor脚本制作有没有删除命令，比方说删除某条邻区怎么删除？ 2016-05-26
• 关于NSN跑脚本出错后自动重复执行的方法 2013-01-07
• NSN 查看载频状态的脚本 2012-08-30
• 求NSN脚本 2012-08-11
• 怎样学习好NSN中SQL脚本的编写 2012-07-10
• NSNGSMSQL脚本问题 2016-06-16
• NSNPlanEditor脚本制作有没有删除命令，比方说删除某条邻区怎么删除？ 2016-05-26
• 关于NSN跑脚本出错后自动重复执行的方法 2013-01-07
• NSN 查看载频状态的脚本 2012-08-30
• 求NSN脚本 2012-08-11
• 怎样学习好NSN中SQL脚本的编写 2012-07-10
问题答案
( 2 )
select to_char(period_stop_time,'yyyymmdd') datetime
,o_bsc.name bsc_name ,bearer_id ,max(nsvc_nsei) nsei ,MAX(c_nsvc.nsvc_committed_info_rate)*16 access_rate
,frbc_pcm_circuit_id||'-'||frbc_first_tsl||'-'||frbc_unit_index pcm
,decode(sum(c_nsvc.nsvc_committed_info_rate)*16,0,' --- ',to_char(100*max(8*(DLCI_1_BYTES_SENT+DLCI_2_BYTES_SENT+DLCI_3_BYTES_SENT+DLCI_4_BYTES_SENT+DLCI_5_BYTES_SENT)/(period_duration*60))/(MAX(c_nsvc.nsvc_committed_info_rate)*16),'990.00')) frl_7
,decode(sum(c_nsvc.nsvc_committed_info_rate)*16,0,' --- ',to_char(100*max(8*(DLCI_1_BYTES_REC+DLCI_2_BYTES_REC+DLCI_3_BYTES_REC+DLCI_4_BYTES_REC+DLCI_5_BYTES_REC)/(period_duration*60))/(MAX(c_nsvc.nsvc_committed_info_rate)*16),'990.00')) frl_8
from p_nbsc_frame_relay a ,objects o_bsc ,objects o_frbc ,objects o_nsvc ,c_bsc_frbc c_frbc,object_modestates s_nsvc ,c_bsc_nsvc c_nsvc
where to_char(period_stop_time,'yyyymmdd') = TO_CHAR(SYSDATE-1,'YYYYMMDD')
and o_bsc.int_id = a.int_id
and o_frbc.object_instance = a.bearer_id
and a.int_id in (select int_id from objects where object_class=3 and name like 'BSC4%')
and o_frbc.parent_int_id=o_bsc.int_id
and o_frbc.object_class = 464
and c_frbc.int_id = o_frbc.int_id
and c_frbc.conf_name = '<ACTUAL>'
and o_nsvc.parent_int_id=o_frbc.int_id
and o_bsc.object_class = 3
and o_nsvc.object_class = 465
and s_nsvc.int_id = o_nsvc.int_id
and s_nsvc.stateinmode1 = 1
and c_nsvc.int_id = o_nsvc.int_id
and c_nsvc.conf_name = '<ACTUAL>'
group by o_bsc.name ,bearer_id ,dlci_1_id ,dlci_2_id ,dlci_3_id ,dlci_4_id ,c_frbc.frbc_pcm_circuit_id ,c_frbc.frbc_first_tsl ,c_frbc.frbc_unit_index,to_char(period_stop_time,'yyyymmdd')
,o_bsc.name bsc_name ,bearer_id ,max(nsvc_nsei) nsei ,MAX(c_nsvc.nsvc_committed_info_rate)*16 access_rate
,frbc_pcm_circuit_id||'-'||frbc_first_tsl||'-'||frbc_unit_index pcm
,decode(sum(c_nsvc.nsvc_committed_info_rate)*16,0,' --- ',to_char(100*max(8*(DLCI_1_BYTES_SENT+DLCI_2_BYTES_SENT+DLCI_3_BYTES_SENT+DLCI_4_BYTES_SENT+DLCI_5_BYTES_SENT)/(period_duration*60))/(MAX(c_nsvc.nsvc_committed_info_rate)*16),'990.00')) frl_7
,decode(sum(c_nsvc.nsvc_committed_info_rate)*16,0,' --- ',to_char(100*max(8*(DLCI_1_BYTES_REC+DLCI_2_BYTES_REC+DLCI_3_BYTES_REC+DLCI_4_BYTES_REC+DLCI_5_BYTES_REC)/(period_duration*60))/(MAX(c_nsvc.nsvc_committed_info_rate)*16),'990.00')) frl_8
from p_nbsc_frame_relay a ,objects o_bsc ,objects o_frbc ,objects o_nsvc ,c_bsc_frbc c_frbc,object_modestates s_nsvc ,c_bsc_nsvc c_nsvc
where to_char(period_stop_time,'yyyymmdd') = TO_CHAR(SYSDATE-1,'YYYYMMDD')
and o_bsc.int_id = a.int_id
and o_frbc.object_instance = a.bearer_id
and a.int_id in (select int_id from objects where object_class=3 and name like 'BSC4%')
and o_frbc.parent_int_id=o_bsc.int_id
and o_frbc.object_class = 464
and c_frbc.int_id = o_frbc.int_id
and c_frbc.conf_name = '<ACTUAL>'
and o_nsvc.parent_int_id=o_frbc.int_id
and o_bsc.object_class = 3
and o_nsvc.object_class = 465
and s_nsvc.int_id = o_nsvc.int_id
and s_nsvc.stateinmode1 = 1
and c_nsvc.int_id = o_nsvc.int_id
and c_nsvc.conf_name = '<ACTUAL>'
group by o_bsc.name ,bearer_id ,dlci_1_id ,dlci_2_id ,dlci_3_id ,dlci_4_id ,c_frbc.frbc_pcm_circuit_id ,c_frbc.frbc_first_tsl ,c_frbc.frbc_unit_index,to_char(period_stop_time,'yyyymmdd')
回答者：
lyys
回答时间：2012-07-23 16:08
9
16
没有邮箱 怎么给你啊
回答者：
wangligang
回答时间：2012-07-23 17:31
3
0
| 联系我们 - 问通信专家 | Powered by MSCBSC 移动通信网 © 2006 - |