62,614
社区成员
发帖
与我相关
我的任务
分享
select monitor.MonitorType,ServerAddress,monitor.MonitorValue from monitor,equipment where monitor.EquipmentId=equipment.RecId and monitor.MonitorType = 'SnmpUpTime' and monitor.MonitorStatus = 'good' order by convert(substring_index(substring_index(MonitorValue , ',' ,1), '=' , -1), DECIMAL(9, 2)) desc limit 10
select monitor.MonitorType,ServerAddress,monitor.MonitorValue from monitor,equipment where monitor.EquipmentId=equipment.RecId and monitor.MonitorType = 'SnmpUpTime' and monitor.MonitorStatus = 'good' order by convert(substring_index(substring_index(MonitorValue , ',' ,1), '=' , -1), DECIMAL(9, 2)) desc limit 10