Create Report of Reports to see which reports are shared externally

What is the challenge?

I want to build a report of all our reports in order to archive old & out-of-date reports.

I especially want to build a report to see all reports that are shared externally as webpages so that I can ensure they're being shared in the right way. I understand that administrators can see that when they go to Settings -> Account -> External Sharing, but other users cannot.

Once I have this report, I will be able to monitor any new reports that are shared externally and flag if they shouldn't be shared externally.

What is the impact?

I do not have visibility of which reports are shared externally in order to moderate.

Describe your idea

Give users the ability to create reports on reports with a field that I can add to view whether or not the report is shared externally.