Scope report for Partners

We need a report that can search which Partners have a particular unit or qualification on their scope of delivery and ideally which of their trainers are approved to deliver it.