$search = utf8_decode($search);
$search = escape_sql($search, $conn);
$filters['where'] = 'host.hostname LIKE "%' . $search . '%"';
}
}
try {
list($assets, $total) = Asset_host::get_list($conn, $tables, $filters, TRUE);
} catch (Exception $e) {
$assets = array();
$total = 0;
}
$results = array();
foreach ($assets as $_id => $asset_data) {
$_res = array();
// Get OS
$os = implode(' ', Asset_host_properties::get_property_from_db($conn, $_id, 3));
$_os = '';
$_dev = '';
if (preg_match("/windows/i", $os)) {
$_os = 'Windows';
} elseif (preg_match("/linux/i", $os)) {
$_os = 'Linux';
}
// Get device types
$_devices = new Asset_host_devices($conn, $_id);
$_devices->load_from_db($conn);
$devices = $_devices->get_devices();
if ($_os == 'Windows') {
$_dev = 'windows_';
} elseif (is_array($devices[1]) && !empty($devices[1])) {
if ($_os == 'Linux') {
$_SESSION['_csv_file_hosts'] = $file;
session_write_close();
$csv = array();
//Export a filtered list
$filters = array();
$session = session_id();
$tables = ', user_component_filter hc';
$filters = array('where' => "hc.asset_id=host.id AND hc.asset_type='asset' AND hc.session_id = '{$session}'", 'order_by' => 'host.hostname ASC');
$_host_list = Asset_host::get_list($conn, $tables, $filters);
foreach ($_host_list[0] as $host) {
$id = $host['id'];
//Description
$descr = $host['descr'];
$descr = mb_convert_encoding($descr, 'UTF-8', 'HTML-ENTITIES');
//Operating System
$os = Asset_host_properties::get_property_from_db($conn, $host['id'], 3);
$os = array_pop($os);
//Latitude/Longitude
$latitude = empty($host['location']['lat']) ? '' : $host['location']['lat'];
$longitude = empty($host['location']['lon']) ? '' : $host['location']['lon'];
//Devices
$str_devices = '';
$devices = Asset_host_devices::get_devices_to_string($conn, $id);
if (!empty($devices)) {
$str_devices = str_replace('<br/>', ',', $devices);
}
$h_data = array();
$h_data['ips'] = $host['ips'];
$h_data['name'] = $host['name'];
$h_data['fqdns'] = $host['fqdns'];
$h_data['descr'] = $descr;
$search = utf8_decode($search);
$search = escape_sql($search, $conn);
$filters['where'] = 'host.hostname LIKE "%' . $search . '%"';
}
}
try {
list($assets, $total) = Asset_host::get_list($conn, $tables, $filters, TRUE);
} catch (Exception $e) {
$assets = array();
$total = 0;
}
$results = array();
foreach ($assets as $_id => $asset_data) {
$_res = array();
// Get OS
$os = Asset_host_properties::get_property_from_db($conn, $_id, 3);
$_os = '';
$_dev = '';
$windows_os = preg_grep("/^windows|microsoft/i", $os);
$linux_os = preg_grep("/linux|alienvault/i", $os);
if (count($windows_os) > 0) {
$_os = 'Windows';
} elseif (count($linux_os) > 0) {
$_os = 'Linux';
}
// Get device types
$_devices = new Asset_host_devices($conn, $_id);
$_devices->load_from_db($conn);
$devices = $_devices->get_devices();
if ($_os == 'Windows') {
$_dev = 'windows_';
