数据库中修改连通性监测结果

作者:动易软件 来源:本站原创 点击数: 发布时间:2024年08月13日

问题描述:有时网站升级或运维中,导致连通性检测全是红点,为了数据好看, 可以手动修改数据库显示全绿

解决办法:

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');