Delete hosts without services msf_db

[Danny-Cap]

Hi guys, similar to this question:
#11114

I'm looking for a way to delete all the hosts from my workspace database that have no services.

Normally you would just filter on the "0" service_count column and delete them.

However, by trying this..
hosts -c address,service_count -S 0

The "0" also matches on the IP addresses and thus also show hosts WITH services..

How can i filter this so that only hosts without services show up and can simply add the "-d" parameter to delete them.

---

Note, hosts -c service_count -S 0 still matches the 0 on IP addresses, even though they dont show up