mysql> select * from sensor;
+-----+----------+------------+----------+-----------+-------------+------------+---------------------+--------+------+------------+
| sid | hostname | agent_type | net_name | interface | description | bpf_filter | updated             | active | ip   | public_key |
+-----+----------+------------+----------+-----------+-------------+------------+---------------------+--------+------+------------+
|   1 | ciscoE1  | sancp      | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 20:43:17 | Y      | NULL | NULL       | 
|   2 | ciscoE1  | pads       | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 21:02:47 | Y      | NULL | NULL       | 
|   3 | ciscoE1  | pcap       | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 21:02:48 | Y      | NULL | NULL       | 
|   4 | ciscoE1  | snort      | ciscoE1  | NULL      | NULL        | NULL       | 2008-02-27 21:02:48 | Y      | NULL | NULL       | 
+-----+----------+------------+----------+-----------+-------------+------------+---------------------+--------+------+------------+
4 rows in set (0.00 sec)

mysql>