FOG Sql

[Nika]

hi!

How can i properly remove a host and all others files( Adress Mac, Serial number, …) in fog with sql request ?

[Wayne Workman]

@Nika

there are two ways.

mysql
use fog
truncate table hosts;
truncate table hostMAC;

mysql
use fog
delete from table hosts where 1;
delete from table hostMAC where 1;

[Nika]

thaks.

[jc35]

Hello,
Why when I delete a hots on fog 1.2.0 in GUI, all the table with a hosts are not delete ?
For example in table inventory when a host is delete, this is not delete in the inventory table and another table why ?
I think when a host is deleted, the host must be deleted in the following table :
hosts, hostmac, greenfog, groupmembers, hostautologout, hostscreensetting, inventory, modulestatusbyhosts, nfsfailures, pendingmacs, printerassoc, sheduledTasks,snapinassoc, snapinjob, usertracking, imaginlog.

We delete a host with a script python with with url : “http://localhost/fog/management/index.php?node=host&sub=delete&id=%s”
Where “%s” is a hostid.

Sorry for my bad english.

[Wayne Workman]

@jc35 We should ask the @Developers to see if this is done in the current Trunk versions or not, let’s see what they say.

[Tom Elliott]

@Wayne-Workman YUP.