Rule Items => Eligible Hosts Add
Item Sequence Operation Field Operator Pattern
Item#1 1 host.description is not unknown
Rule Items => Create Graph Add
Item Sequence Operation Field Operator Pattern
Item#1 1 ifOperStatus contains Up
Item#2 2 AND ifIP is not empty
Item#3 3 AND ifType contains 22
log
01/26/2011 12:51:22 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[394], graph: 35
01/26/2011 12:51:22 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[394], sql: SELECT graph_templates.id, graph_templates.name FROM (graph_templates,host_graph) WHERE graph_templates.id=host_graph.graph_template_id AND host_graph.host_id=394 AND graph_templates.id NOT IN (SELECT graph_local.graph_template_id FROM graph_local WHERE host_id=394)
01/26/2011 12:51:22 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute Host[394]
01/26/2011 12:51:22 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute, items: a:1:{i:0;s:3:\"394\";}
01/26/2011 12:51:22 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute called, action: plugin_autom8_device
01/26/2011 12:51:22 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_execute called
01/26/2011 12:51:03 AM - AUTOM8 TRACE: Poller[0] autom8_device_action_prepare called
01/26/2011 12:50:38 AM - AUTOM8 TRACE: Poller[0] get_field_names called: 1
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: a.ifOperStatus LIKE '%Up%' AND a.ifIP NOT LIKE '' AND a.ifType LIKE '%22%'
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:3:{i:0;a:7:{s:2:"id";s:1:"7";s:7:"rule_id";s:1:"4";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:12:"ifOperStatus";s:8:"operator";s:1:"1";s:7:"pattern";s:2:"Up";}i:1;a:7:{s:2:"id";s:1:"8";s:7:"rule_id";s:1:"4";s:8:"sequence";s:1:"2";s:9:"operation";s:1:"1";s:5:"field";s:4:"ifIP";s:8:"operator";s:2:"16";s:7:"pattern";s:0:"";}i:2;a:7:{s:2:"id";s:2:"10";s:7:"rule_id";s:1:"4";s:8:"sequence";s:1:"3";s:9:"operation";s:1:"1";s:5:"field";s:6:"ifType";s:8:"operator";s:1:"1";s:7:"pattern";s:2:"22";}}, prefix: a.
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_data_query_sql returns: SELECT host.hostname AS autom8_host, host_id, host.disabled, host.status, snmp_query_id, snmp_index , MAX(CASE WHEN field_name='ifAlias' THEN field_value ELSE NULL END) AS 'ifAlias', MAX(CASE WHEN field_name='ifDescr' THEN field_value ELSE NULL END) AS 'ifDescr', MAX(CASE WHEN field_name='ifHwAddr' THEN field_value ELSE NULL END) AS 'ifHwAddr', MAX(CASE WHEN field_name='ifIndex' THEN field_value ELSE NULL END) AS 'ifIndex', MAX(CASE WHEN field_name='ifIP' THEN field_value ELSE NULL END) AS 'ifIP', MAX(CASE WHEN field_name='ifName' THEN field_value ELSE NULL END) AS 'ifName', MAX(CASE WHEN field_name='ifOperStatus' THEN field_value ELSE NULL END) AS 'ifOperStatus', MAX(CASE WHEN field_name='ifSpeed' THEN field_value ELSE NULL END) AS 'ifSpeed', MAX(CASE WHEN field_name='ifType' THEN field_value ELSE NULL END) AS 'ifType' FROM host_snmp_cache LEFT JOIN host ON (host_snmp_cache.host_id=host.id) LEFT JOIN host_template ON (host.host_template_id=host_template.id) WHERE snmp_query_id=1 AND ( host.description IS NOT NULL ) GROUP BY host_id, snmp_query_id, snmp_index
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host.description IS NOT NULL
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host.description IS NOT NULL
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:1:"8";s:7:"rule_id";s:1:"4";s:9:"rule_type";s:1:"1";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:16:"host.description";s:8:"operator";s:2:"14";s:7:"pattern";s:0:"";}}, prefix:
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 4
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] get_field_names called: 1
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_data_query_sql called: a:5:{s:2:"id";s:1:"4";s:4:"name";s:9:"serail up";s:13:"snmp_query_id";s:1:"1";s:13:"graph_type_id";s:2:"13";s:7:"enabled";s:2:"on";}
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_sort_order returns: ORDER BY autom8_host, CAST(snmp_index AS unsigned)
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_sort_order called: numeric/autom8_host
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter returns: host.description IS NOT NULL
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter returns: host.description IS NOT NULL
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_rule_item_filter called: a:1:{i:0;a:8:{s:2:"id";s:1:"8";s:7:"rule_id";s:1:"4";s:9:"rule_type";s:1:"1";s:8:"sequence";s:1:"1";s:9:"operation";s:1:"0";s:5:"field";s:16:"host.description";s:8:"operator";s:2:"14";s:7:"pattern";s:0:"";}}, prefix:
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] build_matching_objects_filter called rule id: 4
01/26/2011 12:50:25 AM - AUTOM8 TRACE: Poller[0] get_created_graphs called: a:5:{s:2:"id";s:1:"4";s:4:"name";s:9:"serail up";s:13:"snmp_query_id";s:1:"1";s:13:"graph_type_id";s:2:"13";s:7:"enabled";s:2:"on";}
