[Administration Logs] Now do not show Host

[centreon]

---

Author Name: Denis Garandel (Denis Garandel) Original Redmine Issue: 4565, https://forge.centreon.com/issues/4565 Original Date: 2013-06-20

---

Hello,

Since some Centreon version (I'm on 2.4.3) we lost hostname on object field in Administration Logs

Before centreon v2.4.x: -> Type=service Object= Hostname / Service_description

After: -> Type=service Object= - / Service_description

So now it's impossible to search all modification for a host

Regards.

[centreon]

---

Original Redmine Comment Author Name: Quentin Garnier (Quentin Garnier) Original Date: 2013-06-20T16:28:41Z

---

It's not really a bug :). Before update in centreon 2.4.x, audit logs doesn't work. We can't display hostname/service. Why ? Because a service is an object itself (it can be associated to different hosts in his lifetime). We should add a search field for the 'service_id'.

[centreon]

---

Original Redmine Comment Author Name: Denis Garandel (Denis Garandel) Original Date: 2013-06-20T21:29:56Z

---

Understand, but it's just one again a regression. On each upgrade that working does not work anymore. So now ok I can see all changes on services but I can't assiociate it to a host.

I can see change for "ping" service but I don't know on witch host. Or you have a other solution. Show all change for a host

I'm not angry. I like Centreon ;-) But now Centreon is a part of production tools, so please add regression test on your upgrade

[centreon]

---

Original Redmine Comment Author Name: Quentin Garnier (Quentin Garnier) Original Date: 2013-06-22T17:33:21Z

---

Now, we have someone in full time for QA. We're working on it. For you problem, i think to another solution: a link (by an icon) in listing to see changes directly ? What do you think about that ?

[centreon]

---

Original Redmine Comment Author Name: Denis Garandel (Denis Garandel) Original Date: 2013-06-22T19:07:46Z

---

Thanks for your return. I return to you that it's a low low problem. No impact in production. But we need to follow all change and by witch. On my production we have cron job to follow and notify all change for duty team. And we need also to keep history. Specialy when we remove a host or service. So I thnink a link is not useful.

IE: I want to known who has deleted a service and for witch host.

Regards.

[centreon]

---

Original Redmine Comment Author Name: Quentin Garnier (Quentin Garnier) Original Date: 2013-06-24T09:25:46Z

---

I see. We have to think about it for 2.5.x.

[centreon]

---

Original Redmine Comment Author Name: Pascal Legrand (Pascal Legrand) Original Date: 2013-07-18T07:02:52Z

---

Bonjour, Avec les clauses where qui vont bien :) ceci devrait aider :)

SELECT host.host_name FROM centreon2.host as host

LEFT JOIN host_service_relation as HSR on HSR.host_host_id=host.host_id LEFT JOIN service as srv on HSR.service_service_id=srv.service_id LEFT JOIN centreon2_storage.log_action as Log_Act on Log_Act.object_id=srv.service_id LEFT JOIN centreon2.contact as contact on contact.contact_id=Log_Act.log_contact_id LEFT JOIN centreon2_storage.log_action_modification as lam on lam.action_log_id=Log_Act.action_log_id

[centreon]

---

Original Redmine Comment Author Name: Julien Mathis (Julien Mathis) Original Date: 2013-10-15T16:02:39Z

---

Applied in changeset commit:758534f96918e8e89e3e1597d2aff20b85295282.