+# find obsolete pools
+cursor.execute("""
+ SELECT name
+ FROM pool
+ WHERE
+ name != 'Scratch' AND
+ numvols = 0 AND
+ poolid NOT IN (SELECT recyclepoolid FROM media)
+""", {})
+
+for r in cursor.fetchall():
+ c = "delete pool=%s"%(r['name'],)
+ cmd.append(c)
+ cmd.append("yes")
+