Years ago I used the API to find which LTI tools were used in a course, then switched to CD1 and now I'm using CD2. 

I built a Tableau report with several filters, including:

• Type of course: sis, non-sis or all
• State of the course: published, unpublished or all

Learn about some of the new features that I built and released in v3.0.0 of the Canvas LMS Mods (Basic) Chrome extension to provide course level reports primarily about course content.  The code for the extension is open-source if you would like to view and/or adapt the source code. Canvas LMS Mods (Basic) GitHub Repository

Learn more about the available features in the GitHub repository or on my past blog post: Creating a Chrome Extension to Use with Canvas LMS