mysql> select * from mshost;
+----+-----------------+---------------+-------------------------------+-------+---------+---------------+--------------+---------------------+---------+-------------+
| id | msid            | runid         | name                          | state | version | service_ip    | service_port | last_update         | removed | alert_count |
+----+-----------------+---------------+-------------------------------+-------+---------+---------------+--------------+---------------------+---------+-------------+
|  1 |    161342909744 | 1389139596755 | virthost1.example.com | Up    | 4.2.0   | 192.168.100.6 |         9090 | 2014-01-08 01:31:58 | NULL    |           1 |
|  2 |   7518816907863 | 1389208467262 | virthost1.example.com | Up    | 4.2.0   | 192.168.100.6 |         9090 | 2014-01-09 18:03:53 | NULL    |           1 |
|  3 | 279278805451075 | 1389921848754 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-17 01:57:03 | NULL    |           1 |
|  4 | 143523686817445 | 1389924404651 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-17 02:28:38 | NULL    |           1 |
|  5 | 279278805450759 | 1389926888578 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-17 02:58:19 | NULL    |           1 |
|  6 |  28804849811276 | 1390244355894 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-20 20:38:47 | NULL    |           1 |
|  7 | 209913176628964 | 1390252980240 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-24 19:27:29 | NULL    |           1 |
|  8 | 279278805451104 | 1391203154260 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-31 21:21:07 | NULL    |           1 |
|  9 | 279278805451706 | 1391205498052 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-01-31 22:04:01 | NULL    |           0 |
| 10 | 179089646757000 | 1391206490597 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-02-04 04:04:08 | NULL    |           0 |
| 11 | 249579842194123 | 1391487009432 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-02-20 00:40:23 | NULL    |           0 |
| 12 | 279278805451070 | 1392926928320 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-02-21 01:29:40 | NULL    |           0 |
| 13 | 279278805451191 | 1392948223568 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-02-21 02:04:28 | NULL    |           0 |
| 14 | 208938256032007 | 1392948836994 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-02-21 02:19:09 | NULL    |           0 |
| 15 | 279278805451159 | 1392949236108 | virthost1.example.com | Up    | 4.2.1   | 192.168.100.6 |         9090 | 2014-02-21 18:00:03 | NULL    |           0 |
+----+-----------------+---------------+-------------------------------+-------+---------+---------------+--------------+---------------------+---------+-------------+
15 rows in set (0.00 sec)