grep pavlov ../logs/daemon/uncategorized.log SELECT DISTINCT ipInterface.ipAddr FROM ipInterface, category_node, categories WHERE (categories.categoryName = 'pavlov') AND category_node.nodeID = ipInterface.nodeID AND categories.categoryID = category_node.categoryID AND category_node.nodeID = ipInterface.nodeID SELECT DISTINCT ipInterface.ipAddr FROM ipInterface, category_node, categories WHERE (categories.categoryName = 'pavlov') AND category_node.nodeID = ipInterface.nodeID AND categories.categoryID = category_node.categoryID AND category_node.nodeID = ipInterface.nodeID [root@ts4 etc]#