How to generate manager list from specific company when manager is out of these company?

[pboulicaut]

We are trying to build a simple integration with Integration center

to list all managers with a direct report in Company A.

Output file with looks Like : 

MGR_ID,MGR_Display_Name,MGR_Company,MGR_TeamSize

12345678,John DOE,B,3

There is several employee in company A that reports to managers in Company B or C.

Unfortunately, Integration Center doesn't offer any filtering option on Manager.

are we forced to use SCPI to develop such integration or is there some workaround with MDF objects or Background info to support such integration ? 

[pboulicaut]

using User entity & calculated field (for each entity direct reports if company = A field value = 1 + Field value, i'm able to list all managers with reports in company A. i need to figure out with an MDF object how to cover to delete manager permission for managers who become managers without reports in company A. ( i need to figure out how to detect when the count of reports in company A is moving from a positive number (1 or higher) to zero