Centreon is a network, system and application monitoring tool. Centreon is the only AIOps Platform Providing Holistic Visibility to Complex IT Workflows from Cloud to Edge.
This issue occurs when resources parent_id and id are equal among all the resources stored in centreon_storage.resources. This implies that when we try to retrieve the host of a service in LEFT JOIN statement, the host is returned but the service itself too which creates the duplicates.
Fixes # (issue)
Type of change
[x] Patch fixing an issue (non-breaking change)
[ ] New functionality (non-breaking change)
[ ] Breaking change (patch or feature) that might cause side effects breaking part of the Software
Target serie
[ ] 21.04.x
[ ] 21.10.x
[x] 22.04.x
[x] 22.10.x (master)
How this pull request can be tested ?
See Jira ticket
Checklist
Community contributors & Centreon team
[ ] I have followed the coding style guidelines provided by Centreon
[ ] I have commented my code, especially new classes, functions or any legacy code modified. (docblock)
[ ] I have commented my code, especially hard-to-understand areas of the PR.
[ ] I have rebased my development branch on the base branch (master, maintenance).
sonarqube-decoration[bot]
commented
2 years ago 
Description
This issue occurs when resources parent_id and id are equal among all the resources stored in centreon_storage.resources. This implies that when we try to retrieve the host of a service in LEFT JOIN statement, the host is returned but the service itself too which creates the duplicates.
Fixes # (issue)
Type of change
Target serie
How this pull request can be tested ?
See Jira ticket
Checklist
Community contributors & Centreon team