mysql> SELECT * FROM `observium`.`ports` WHERE `ifOperStatus` = 'down' AND `ifAdminStatus` = 'up' AND `ifDescr` LIKE 'port:%'; +---------+-----------+------------+------------+-----------------+------------------+--------------------+------------------+------------------+--------------------------+--------+----------+---------+---------+--------------------+-------------------+-------------+--------------+---------------+----------+-------+-----------------+---------+---------------+------------+---------------------+--------+---------+-------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+ | port_id | device_id | port_64bit | port_label | port_descr_type | port_descr_descr | port_descr_circuit | port_descr_speed | port_descr_notes | ifDescr | ifName | portName | ifIndex | ifSpeed | ifConnectorPresent | ifPromiscuousMode | ifHighSpeed | ifOperStatus | ifAdminStatus | ifDuplex | ifMtu | ifType | ifAlias | ifPhysAddress | ifHardType | ifLastChange | ifVlan | ifTrunk | ifVrf | ignore | disabled | detailed | deleted | pagpOperationMode | pagpPortState | pagpPartnerDeviceId | pagpPartnerLearnMethod | pagpPartnerIfIndex | pagpPartnerGroupIfIndex | pagpPartnerDeviceName | pagpEthcOperationMode | pagpDeviceId | pagpGroupIfIndex | +---------+-----------+------------+------------+-----------------+------------------+--------------------+------------------+------------------+--------------------------+--------+----------+---------+---------+--------------------+-------------------+-------------+--------------+---------------+----------+-------+-----------------+---------+---------------+------------+---------------------+--------+---------+-------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+ | 2330 | 45 | 0 | | NULL | NULL | NULL | NULL | NULL | Port: 10 Gigabit - Level | | NULL | 10 | 0 | NULL | NULL | NULL | down | up | NULL | 1518 | gigabitEthernet | | 9c8e99b8fce2 | NULL | 2013-11-12 16:42:41 | NULL | NULL | NULL | 1 | 1 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 2331 | 45 | 0 | | NULL | NULL | NULL | NULL | NULL | Port: 11 Gigabit - Level | | NULL | 11 | 0 | NULL | NULL | NULL | down | up | NULL | 1518 | gigabitEthernet | | 9c8e99b8fce2 | NULL | 2013-11-12 16:42:41 | NULL | NULL | NULL | 1 | 1 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 2332 | 45 | 0 | | NULL | NULL | NULL | NULL | NULL | Port: 12 Gigabit - Level | | NULL | 12 | 0 | NULL | NULL | NULL | down | up | NULL | 1518 | gigabitEthernet | | 9c8e99b8fce2 | NULL | 2013-11-12 16:42:41 | NULL | NULL | NULL | 1 | 1 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 2344 | 45 | 0 | | NULL | NULL | NULL | NULL | NULL | Port: 24 Gigabit - Level | | NULL | 24 | 0 | NULL | NULL | NULL | down | up | NULL | 1518 | gigabitEthernet | | 9c8e99b8fce2 | NULL | 2013-10-07 13:31:18 | NULL | NULL | NULL | 1 | 1 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 2324 | 45 | 0 | | NULL | NULL | NULL | NULL | NULL | Port: 4 Gigabit - Level | | NULL | 4 | 0 | NULL | NULL | NULL | down | up | NULL | 1518 | gigabitEthernet | | 9c8e99b8fce2 | NULL | 2013-11-12 16:42:40 | NULL | NULL | NULL | 1 | 1 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | | 2329 | 45 | 0 | | NULL | NULL | NULL | NULL | NULL | Port: 9 Gigabit - Level | | NULL | 9 | 0 | NULL | NULL | NULL | down | up | NULL | 1518 | gigabitEthernet | | 9c8e99b8fce2 | NULL | 2013-11-12 16:42:40 | NULL | NULL | NULL | 1 | 1 | 0 | 0 | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | NULL | +---------+-----------+------------+------------+-----------------+------------------+--------------------+------------------+------------------+--------------------------+--------+----------+---------+---------+--------------------+-------------------+-------------+--------------+---------------+----------+-------+-----------------+---------+---------------+------------+---------------------+--------+---------+-------+--------+----------+----------+---------+-------------------+---------------+---------------------+------------------------+--------------------+-------------------------+-----------------------+-----------------------+--------------+------------------+ 6 rows in set (0.01 sec) mysql>