ÎÊÌâÒÑ¿ªÆô
(ÆÕͨÎÊÌâ)
ŵÎ÷É豸ÖУ¬ÔØƵµÄ״̬£¨È磺BL- RSL BL- USER WOµÈ£©ÔÚÄÄÕűíÖÐÌáÈ¡£¿C_TRXÖ»ÄÜÌá³ö²¿·ÖÔØƵÐÅÏ¢£¿
ŵÎ÷É豸ÖУ¬ÓÃSQLÌáÊý¾Ý£¬ÔØƵµÄ״̬£¨È磺BL- RSL BL- USER WOµÈ£©ÔÚÄÄÕűíÖÐÌáÈ¡£¿C_TRXÖ»ÄÜÌá³ö²¿·ÖÔØƵÐÅÏ¢£¿
ÎÒ¶¼ËµÁË£¬C_TrxÊÇÌá²»³öÀ´µÄ
ÌáÎÊÕß: daixiaofei ÌáÎÊʱ¼ä: 2012-03-19
• 2206»ú¹ñÉ豸:ÔØƵ£¬»ú¹ñ·çÉȶ¼»»ÁË¡£ÔØƵ²ÛλҲ¸ÄÁË¡£Ð¡Çø¹¦ÂÊÒ²Ð޸ĹýÁË¡£Ê¼ÖÕ»¹ÊÇÒª³öTRX2A25,TX1B27¡£ ³ýÁËÒÔÉϽâ¾ö·½°¸ÍâÇëÎÊ»¹ÓÐʲô·½·¨¿ÉÒÔ½â¾ö 2016-08-20
• 2206»ú¹ñÉ豸:ÔØƵ£¬»ú¹ñ·çÉȶ¼»»ÁË¡£ÔØƵ²ÛλҲ¸ÄÁË¡£Ð¡Çø¹¦ÂÊÒ²Ð޸ĹýÁË¡£Ê¼ÖÕ»¹ÊÇÒª³öTRX2A25,TX1B27¡£ ÇëÎÊ»¹ÓÐʲô·½·¨¿ÉÒÔ½â¾ö 2016-08-20
• RBS6601ËùÓÐÔØƵÓÐTRXTX 2A 2 ¸æ¾¯Çó½â´ð 2015-06-29
• °®Á¢ÐÅrbs2206É豸£¬ÔØƵ³öTRX2a23¸æ¾¯£¬¸ü»»ÔØƵºóÆäËûÔØƵÓÖ³öͬÑùµÄ¸ß¾¯£¬Ôõô»ØÊ 2014-12-18
• GSMСÇøΪʲôÔØƵ×î´ó²»ÄÜÅäµ½×î´ó16TRX£¿ 2014-06-25
• ¹ØÓÚEƵµã£¬ÔÚ´óÓÚµÈÓÚ8TRXµÄСÇøÖÐʹÓã¬Ã¿Ð¡ÇøEƵµã²»³¬¹ýСÇø×ÜÔØƵµÄ50% 2014-05-09
• °®Á¢ÐÅ6000É豸һ¸öÔØƵÖеÄ2¸öTRX±¾¶Ë 2013-12-01
• ʲôÇé¿öÔö¼ÓGTRXÔØƵÊý£¬Ê²Ã´Çé¿öÔö´óCDED±ÈÀý£¿ 2012-12-21
• 2206»ú¹ñÉ豸:ÔØƵ£¬»ú¹ñ·çÉȶ¼»»ÁË¡£ÔØƵ²ÛλҲ¸ÄÁË¡£Ð¡Çø¹¦ÂÊÒ²Ð޸ĹýÁË¡£Ê¼ÖÕ»¹ÊÇÒª³öTRX2A25,TX1B27¡£ ÇëÎÊ»¹ÓÐʲô·½·¨¿ÉÒÔ½â¾ö 2016-08-20
• RBS6601ËùÓÐÔØƵÓÐTRXTX 2A 2 ¸æ¾¯Çó½â´ð 2015-06-29
• °®Á¢ÐÅrbs2206É豸£¬ÔØƵ³öTRX2a23¸æ¾¯£¬¸ü»»ÔØƵºóÆäËûÔØƵÓÖ³öͬÑùµÄ¸ß¾¯£¬Ôõô»ØÊ 2014-12-18
• GSMСÇøΪʲôÔØƵ×î´ó²»ÄÜÅäµ½×î´ó16TRX£¿ 2014-06-25
• ¹ØÓÚEƵµã£¬ÔÚ´óÓÚµÈÓÚ8TRXµÄСÇøÖÐʹÓã¬Ã¿Ð¡ÇøEƵµã²»³¬¹ýСÇø×ÜÔØƵµÄ50% 2014-05-09
• °®Á¢ÐÅ6000É豸һ¸öÔØƵÖеÄ2¸öTRX±¾¶Ë 2013-12-01
• ʲôÇé¿öÔö¼ÓGTRXÔØƵÊý£¬Ê²Ã´Çé¿öÔö´óCDED±ÈÀý£¿ 2012-12-21
ÎÊÌâ´ð°¸
( 2 )
ÌáÒ»ÏÂ×îеIJÎÊý¿ÉÒÔô£¿ÀïÃæÓ¦¸Ã»áÓÐÔØƵµÄ״̬¡£
ZEEL:BL; |
»Ø´ðÕߣº
zf429028
»Ø´ðʱ¼ä£º2012-03-19 08:54
3 2
SELECT
to_char(A.LAST_MODIFIED,'yyyymmddhh24') "×îÖÕÐÞÕýʱ¼ä",
a.LAST_MODIFIER "×îÖÕÐÞÕýÈË",
C_BTS.CELL_ID ,
c.name BTSNAME,
d.name bscname,
b.OBJECT_INSTANCE TRX,
a.INITIAL_FREQUENCY FREQ,
a.CH_0_TYPE , /*0=TCHF;2=TCHD;3=SDCCH;4=BCCH;5=MBCCHC*/
a.CH_1_TYPE ,
a.CH_2_TYPE ,
a.CH_3_TYPE ,
a.CH_4_TYPE ,
a.CH_5_TYPE ,
a.CH_6_TYPE ,
a.CH_7_TYPE ,
A.CH_0_PCM PCM,
A.LAPD_LINK_NAME
FROM
C_TRX A,
objects b,
objects c,
objects d,
C_BTS
WHERE
A.INT_ID=B.int_id
AND B.object_class=24
and c.object_class=4
AND C.INT_ID=C_BTS.INT_ID
and d.object_class=27
--AND A.LAST_MODIFIED>=to_date(&Stime,'yyyymmddhh24')
and b.PARENT_INT_ID=c.int_id
and c.parent_int_id=d.int_id
and a.CONF_NAME='<ACTUAL>'
AND D.NAME LIKE 'LYBSC%'
to_char(A.LAST_MODIFIED,'yyyymmddhh24') "×îÖÕÐÞÕýʱ¼ä",
a.LAST_MODIFIER "×îÖÕÐÞÕýÈË",
C_BTS.CELL_ID ,
c.name BTSNAME,
d.name bscname,
b.OBJECT_INSTANCE TRX,
a.INITIAL_FREQUENCY FREQ,
a.CH_0_TYPE , /*0=TCHF;2=TCHD;3=SDCCH;4=BCCH;5=MBCCHC*/
a.CH_1_TYPE ,
a.CH_2_TYPE ,
a.CH_3_TYPE ,
a.CH_4_TYPE ,
a.CH_5_TYPE ,
a.CH_6_TYPE ,
a.CH_7_TYPE ,
A.CH_0_PCM PCM,
A.LAPD_LINK_NAME
FROM
C_TRX A,
objects b,
objects c,
objects d,
C_BTS
WHERE
A.INT_ID=B.int_id
AND B.object_class=24
and c.object_class=4
AND C.INT_ID=C_BTS.INT_ID
and d.object_class=27
--AND A.LAST_MODIFIED>=to_date(&Stime,'yyyymmddhh24')
and b.PARENT_INT_ID=c.int_id
and c.parent_int_id=d.int_id
and a.CONF_NAME='<ACTUAL>'
AND D.NAME LIKE 'LYBSC%'
»Ø´ðÕߣº
ÈÎÎÒ·ÉÏè2008
»Ø´ðʱ¼ä£º2012-03-20 20:48
11 11
ÈȵãÎÊÌâ
¸ü¶à¾«²Ê
ÁªÏµÎÒÃÇ - ÎÊͨÐÅר¼Ò | Powered by MSCBSC Òƶ¯Í¨ÐÅÍø © 2006 - |