Requester's manager into custom field

Hi,

I’ve been asked to produce RT reports/Dashboards/ticket digests for
department heads. I think the easiest way for this is to set the AdminCC
for a ticket to the requester’s manager. We have managers defined in AD so
this should be achievable via a scrip?

How would I progress this forward?

Thanks.