> At first, we just disassociated the node from it's schedule and changed > it's > contact field to indicate it's retired status. Very quickly we found that > there > was no quick/easy way to tell active clients from retired clients.
Would a command like select node_name from nodes where contact like '%retired%' provide an acceptable way of identifying the retired nodes?