Report: Collections, URLs, and Portals

I'd like to get a report that contains the

• Collection slug
• Display title
• Portal (please parse out the portal values into separate columns: i.e., an amso column, a crdl column, a dlg column, and an other column)
• Holding Institution
• URL (metadata) edm_is_shown_at

for all collections.