SELECT `ev_event`.`event_id` , `ev_event`.`severity` , `ev_event`.`origin_is_policy` , `ev_event`.`task_id` , `ev_event`.`task_display_name` , `ev_event`.`hostname` , `ev_event`.`product_name` , `ev_event`.`product_version` , `ev_event`.`event_type` , `ev_event`.`event_type_display_name` , `ev_event`.`descr` , `ev_event`.`rise_time` , `ev_event`.`deadline` , `ev_event`.`body` , `v_hosts_and_slaves`.`strDisplayName` AS `hostdn` , `v_hosts_and_slaves`.`nIpAddress` AS `host_ip` , `v_hosts_and_slaves`.`nIpCon` AS `host_conn_ip` , `NtDomains`.`strName` AS `domain_name` , `ev_event`.`product_name` AS `product_name` , CASE WHEN `hst_product_dn`.`wstrName` IS NULL THEN `ev_event`.`product_name` ELSE `hst_product_dn`.`wstrName` END AS `product_dn` , IFNULL( `hst_prdstates_client`.`wstrProductDisplVersion` , `hst_prdstates_client`.`wstrProductDisplVersion` ) AS `product_dver` , `v_hosts_and_slaves`.`strWinHostName` AS `win_host_name` , `v_hosts_and_slaves`.`strDisplayName` AS `host_display_name` FROM `ev_event` LEFT OUTER JOIN `v_hosts_and_slaves` ON `v_hosts_and_slaves`.`strName` = `ev_event`.`hostname` LEFT OUTER JOIN `NtDomains` ON `NtDomains`.`nId` = `v_hosts_and_slaves`.`nNtDomain` LEFT OUTER JOIN `hst_products` ON `ev_event`.`product_name` = `hst_products`.`wstrProductName` AND `ev_event`.`product_version` = `hst_products`.`wstrProductVersion` LEFT OUTER JOIN `hst_prdstates` AS hst_prdstates_client ON `hst_products`.`nId` = `hst_prdstates_client`.`nProduct` AND `hst_prdstates_client`.`nHostId` = `v_hosts_and_slaves`.`nId` LEFT OUTER JOIN `hst_prdstates` AS hst_prdstates_server ON `hst_products`.`nId` = `hst_prdstates_server`.`nProduct` AND `hst_prdstates_server`.`nHostId` = 1 LEFT OUTER JOIN `hst_product_dn` ON `hst_product_dn`.`nId` = IFNULL( `hst_prdstates_client`.`nProdDN` , `hst_prdstates_server`.`nProdDN` ) WHERE (`ev_event`.`is_need_send` <> 0 )ORDER BY `ev_event`.`event_id` LIMIT 10;<>/pre</p>
Кросспост из http://www.lab108.ru/2008/10/31/tipovojj-zapros-kasper/