数据库中修改连通性监测结果
问题描述:有时网站升级或运维中,导致连通性检测全是红点,为了数据好看, 可以手动修改数据库显示全绿
解决办法:
update "DY_MONITOR"."PE_MonitoringCenter_ConnectionEverydayStatistic" set UnConnectionNumber=0 where "StatisticTime">=TO_TIMESTAMP('2024-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
update "DY_MONITOR"."PE_MonitoringCenter_ConnectionHourPartStatistic" set UnConnectionNumber=0,TotalConnectionNumber=60 where "StatisticTime">=TO_TIMESTAMP('2024-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
update "DY_MONITOR"."PE_MonitoringCenter_ConnectionHourPartStatistic" set AverageTime=AverageTime-1000 where "StatisticTime">=TO_TIMESTAMP('2024-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS') and AverageTime>1000;
update "DY_MONITOR"."PE_MonitoringCenter_ConnectionRecord"
set Status=200,ErrorMessage='OK',IsSuccess=1
where RequestTime>=TO_TIMESTAMP('2024-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
update "DY_MONITOR"."PE_MonitoringCenter_ServerConnectionEverydayStatistic" set UnConnectionNumber=0 where StatisticTime>=TO_TIMESTAMP('2024-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');
update "DY_MONITOR"."PE_MonitoringCenter_ServerConnectionHourPartStatistic"
set TotalConnectionNumber=60,UnConnectionNumber=0
where StatisticTime>=TO_TIMESTAMP('2024-08-01 00:00:00', 'YYYY-MM-DD HH24:MI:SS');