how genrate a list of active services (no templates) without contactgroup define? sql, api, api rest, .conf file?

Hi everyone,

I’m looking for the most efficient way to generate a list of active services (excluding templates) that do not have any contactgroup defined—neither directly nor inherited from templates.

I’d like to explore different methods to achieve this, such as:

• SQL queries (directly querying the Centreon database)
• REST API (if applicable)
• Parsing configuration files (e.g., .conf files in /var/lib/centreon-engine/central/config/)

If you’ve already tackled this issue or have any insights, I’d appreciate your input! Which method do you recommend for accuracy and simplicity?

Thanks in advance for your help!