MySQL and Deleting Hosts

[Chris Whiteley]

I was wondering if there would be a command in mysql that would delete hosts if they have no image assigned to them? I am trying to clean up old machines and that is the easiest way to do it. Thanks,

[Tom Elliott]

Maybe:

[code]delete from hosts where hostImage is null;[/code]

[Chris Whiteley]

So apparently there is a hostImage attached to them but it doesn’t exist anymore. Is there a way to find out what a particular host has as its hostImage?

[Tom Elliott]

Maybe try hostImage=‘0’ instead of hostImage is null

[Chris Whiteley]

thanks a bunch, I actually used what you did there hostimage=#; and just entered all numbers but the ones we were using and that cleaned it up. Thanks!