Filter out unused apps in SharePoint app catalog site

We want to find out apps which are not in active in the app catalog site.

If active need to location of the sites in which they are installed