select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.CpuUseRatio as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=1 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.CpuTemp as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=2 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.MemUseRatio as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=3 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.Flow as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=4 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.DiskUseRatio as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=5 union select NeConfig.NeName,SystemPerformance.ID,SystemPerformance.Time,PerfThreshold.PerfID,SystemPerformance.ProcessNum as Performance,PerfThreshold.HighWatermark from NeConfig,SystemPerformance,PerfThreshold where PerfThreshold.PerfID=6;
posted on 2007-03-27 16:49
鱼有所思 阅读(798)
评论(3) 编辑 收藏 引用 网摘 所属分类:
PHP