we upgraded from <div>1.4b7 to 1.4b9</div><div>nagios version was upgraded from 2.x to 3.2.3</div><div><br></div><div>There is no way to correlate contact notified to notifications anymore since the first that used to track it is now inserted with '0' all the time (confirmed via debug mode)</div>
<div><br></div><div>the specific field is CONTACT_OBJECT_ID in NAGIOS_NAGIOSNOTIFICATIONS table.</div><div>there doesn't seem to be any other way to join the data in order to find out who was contacted.</div><div><br>
</div><div>before upgrade (supporting query below)</div><div><div>| cs-pnslij             | HTTP-alt                              | Primary          |               439 |</div><div>| cs-pnslij             | jboss_ConnectionCount                 | cwhite_email     |               463 |</div>
<div>| cs-pnslij             | jboss_ConnectionCount                 | cs_cwhite_pager  |               459 |</div><div>| cs-pnslij             | jboss_ConnectionCount                 | cs_clee_pager    |               458 |</div>
<div>| cs-pnslij             | jboss_ConnectionCount                 | cs_clee_email    |               457 |</div><div>| cs-pnslij             | jboss_ConnectionCount                 | ashburn_ops      |               447 |</div>
<div>+-----------------------+---------------------------------------+------------------+-------------------+</div></div><div><br></div><div><br></div><div>after upgrade:</div><div><div>| mt-ora2        | nrpe-system_load           | NULL         |                 0 |</div>
<div>| mt-ora2        | nrpe-system_load           | NULL         |                 0 |</div></div><div><br></div><div><br></div><div><br></div><div>query:</div><div><div>SELECT  </div><div>obj1.name1 AS host_name </div><div>
,obj1.name2 AS service_description </div><div>,obj2.name1 AS contact_name </div><div>,nagios_contactnotifications.contact_object_id</div><div>FROM `nagios_contactnotifications` </div><div>JOIN nagios_notifications ON  </div>
<div>nagios_contactnotifications.notification_id=nagios_notifications.notification_id </div><div>LEFT JOIN nagios_objects as obj1 ON  </div><div>nagios_notifications.object_id=obj1.object_id </div><div>LEFT JOIN nagios_objects as obj2 ON  </div>
<div>nagios_contactnotifications.contact_object_id=obj2.object_id </div><div>LEFT JOIN nagios_instances ON  </div><div>nagios_notifications.instance_id=nagios_instances.instance_id </div><div>WHERE </div><div>nagios_notifications. start_time >= DATE_SUB(CURDATE(), interval 48 hour) </div>
<div>ORDER BY nagios_notifications.start_time DESC</div></div><div><br></div><div><br></div><div><br></div><div><br></div><div><br></div>