/**
* Get all devices of definition type 'Computer' defined in task_definitiontype_wakeonlan
*
* @return dropdown list of computers
*
**/
static function task_actionselection_PluginFusioninventoryCredentialIp_InventoryComputerESX()
{
global $DB;
$options = array();
$options['name'] = 'definitionactiontoadd';
$module = new PluginFusioninventoryAgentmodule();
$module_infos = $module->getActivationExceptions('InventoryComputerESX');
$exceptions = json_decode($module_infos['exceptions'], TRUE);
$in = "";
if (!empty($exceptions)) {
$in = " AND `a`.`id` NOT IN (" . implode($exceptions, ', ') . ")";
}
$query = "SELECT `a`.`id`, `a`.`name`\n FROM `glpi_plugin_fusioninventory_credentialips` as `a`\n LEFT JOIN `glpi_plugin_fusioninventory_credentials` as `c`\n ON `c`.`id` = `a`.`plugin_fusioninventory_credentials_id`\n WHERE `c`.`itemtype`='PluginFusioninventoryInventoryComputerESX'";
$query .= getEntitiesRestrictRequest(' AND', 'glpi_plugin_fusioninventory_credentialips');
$results = $DB->query($query);
$credentialips = array();
while ($data = $DB->fetch_array($results)) {
$credentialips[$data['id']] = $data['name'];
}
return Dropdown::showFromArray('actionselectiontoadd', $credentialips);
}
