Jakee_NB

1、此blog，只做些个人学习、工作相关的记录；起先大部分资料都来自以前 jakee.mblogger.cn 我的第一个BLOG和 www.safeexpert.net 我的技术类的论坛.
2、您的留言是对我最大的支持和鼓励，请留下宝贵的意见和建议。

关于短信后门 通过中心编辑如下短信发送给终端
1 EXEALARMMODE 外部告警模式:启用
2 NOTEXEALARMMODE 外部告警模式:禁用
3 SETNEWSTATION 终端主动开站
4 SETTYPENEWSTATION0 设置开站方式为短信开站
5 SETTYPENEWSTATION1 设置开站方式为TCP开站
6 SETSTATIONID88888888 设置站点编号
7 reboot 重启终端

获取终端站点编号：
GetIni255,NetworkManagementParam,StationID
GetIni255,NetworkManagementParam,DeviceSn
设置生产序列号
SetIni255,DeviceInfo,DeviceSn,081091102194

设置Pesq下行环回开关关闭
SetIni254,System,PesqDownVoiceLoopback,0
设置Pesq下行环回开关开启
SetIni254,System,PesqDownVoiceLoopback,1

csq =-109+(csq-2)*2;

——————————————————————————————————
ATTACH平均时延过长告警
DELETE FROM AlarmList_OnLine WHERE Remark=’ATTACH平均时延过长告警’
DELETE FROM AlarmList_OnLine WHERE Remark=’接收电平强度告警’
DELETE FROM AlarmList_OnLine WHERE Remark=’超时定时上报告警’
外部告警1
电源掉电告警
——————————————————————————————————
delete FROM AlarmList_OnLine where remark like ‘登录服务器失败%’
PS域登录失败%
外部告警%
——————————————————————————————————-
清除数据库中的电池告警信息（SET 修改：设置站点编号 设备编号）：
一、
DECLARE @sID_Station varchar(10)
DECLARE @nID_Module INT

SET @sID_Station = ”
SET @nID_Module = 255

UPDATE RUnit
SET ST_Battery = 0
WHERE ID_Station = @sID_Station
AND ID_Module = @nID_Module

DELETE AlarmList_OnLine WHERE ID_Alarm = 3 AND ID_Station = @sID_Station
AND ID_Module = @nID_Module

二、批量
UPDATE RUnit SET ST_Battery = 0 DELETE AlarmList_OnLine WHERE ID_Alarm = 3
——————————————————————————————————-
socket_send、sms_send \msg_recvlist
//查询socket_send
select top 500 * from socket_send where destid=’10010070′ order by id desc
//查询
select top 500 * from msg_recvlist where srcid=’10010091′ or srcid=’18609444426′ order by id desc
//查询
select top 10* from re_pesq order by id desc

//删掉
update sms_send set disposed = 1 where disposed = 0

//查询用户指令
select top 500 * from UserCMD WHERE ID_STATION = ’10010070′ order by ID DESC
//电源
update runit set ST_POWEROFF = 0,LastMsgTime= ’2010-5-11 9:30:00′ where ST_POWEROFF = 1
delete alarmlist_online where id_alarm = 1
//设置通信中断状态为正常，最后消息时间为 5-11 9:00 删除通信中断告警
update runit set ST_Online = 0,LastMsgTime= ’2010-5-11 9:00:00′ where ST_OnLine = 1
delete alarmlist_online where id_alarm = 0

//在平台上用PS域批量查询会导致部分终端重新开站（显示未纳入监控）。处理如下：1、现用PS域批量查询；2、然后用数据库查询

（生产库）： select top 500 * from sms_send order by id desc 命令将数据导出发给我。

——————————————————————————————————-
//条件是 “启用标志” 标记为“正在开站”的站点，做开站上报
select top 40 id_station from runit where st_online = 4
——————————————————————————————————–
//将所有正在开站的改为正常
UPDATE RUnit SET Enabled = 1 WHERE Enabled = 4
//(‘站点编号’)
UPDATE RUnit SET Enabled = 1 WHERE ID_Station IN(”,”,”)
1–正常 2-拆除 3–未纳入监控 4–正在开站
——————————————————————————————————–
那几个编码可以再 AlarmSetup 里找到相应的说明
T-SQL:
DELETE AlarmList_OnLine WHERE ID_Alarm IN (83,84,92)
——————————————————————————————————–
//把一个分区里的所有终端移动到另一个分区里
UPDATE runit SET i_city=,ID_Province=,ID_County=,ID_Town= WHERE i_city= AND ID_Province= AND ID_County= AND

ID_Town=

//把一个分区里相同软件版本号的终端移动到另一个分区里
UPDATE runit SET i_city=,ID_Province=,ID_County=,ID_Town= WHERE i_city= AND ID_Province= AND ID_County= AND

ID_Town= and AND RU_SoftVersion=”
备注：慎用，使用前最好先备份数据库(前面的等于写新的分区的对应编号。。。where后面的等于写旧的分区对应的编号)
——————————————————————————————————–