[API][Framework] Problems with GET /overview/agents in big environments

[davidjiglesias]

Hello team,

As part of the investigation for #6744 we have discovered a possible timeout and performance issue related with GET /overview agents request.

The SDK function in charge of this call is currently executing excessive processing and too many calls to wazuh-db. We should work on a refactor for the function to increase its efficiency and also ensure the function that is expanding groups for RBAC is properly context cached during a single API execution.

Regards,

David J. Iglesias

Checks

wazuh/wazuh

• Unit tests without failures. Updated and/or expanded if there are new functions/methods/outputs:
  • Cluster (framework/wazuh/core/cluster/tests/ & framework/wazuh/core/cluster/dapi/tests/)
  • Core (framework/wazuh/core/tests/)
  • SDK (framework/wazuh/tests/)
  • RBAC (framework/wazuh/rbac/tests/)
  • API (api/api/tests/)
• API tavern integration tests without failures. Updated and/or expanded if needed (api/test/integration/):
  • Affected tests
  • Affected RBAC (black and white) tests
• Review of spec.yaml examples and schemas (api/api/spec/spec.yaml)
• Changelog (CHANGELOG.md)

wazuh/wazuh-documentation

• Migration from 3.X for changed endpoints (source/user-manual/api/equivalence.rst)
• Update RBAC reference with new/modified actions/resources/relationships (source/user-manual/api/rbac/reference.rst)