- 论坛徽章:
- 1
|
情况是这样, 领导要求整个excel,把每台服务器每天的监督指标(负荷,内存,网卡流量)的最大值每天邮件出来。
我的思路是直接SQL去查数据库的history, history_uint, items表的相关信息,现在的问题来了,找网卡相关信息时,从items查出的结果是:
mysql> select itemid,name from items where hostid=10120 and name like '%network%';
+--------+--------------------------------+
| itemid | name |
+--------+--------------------------------+
| 24327 | Network interface discovery |
| 24368 | Incoming network traffic on $1 |
| 24369 | Incoming network traffic on $1 |
| 24370 | Incoming network traffic on $1 |
| 24371 | Incoming network traffic on $1 |
| 24372 | Incoming network traffic on $1 |
| 24329 | Incoming network traffic on $1 |
| 24373 | Outgoing network traffic on $1 |
| 24374 | Outgoing network traffic on $1 |
| 24375 | Outgoing network traffic on $1 |
| 24376 | Outgoing network traffic on $1 |
| 24377 | Outgoing network traffic on $1 |
| 24330 | Outgoing network traffic on $1 |
+--------+--------------------------------+
13 rows in set (0.00 sec)
这里就根据无法与具体的网卡信息对应起来。从哪里可以找到对应关系,谢谢!
|
|