Altium: Find schematics which use a footprint from the library
Go to Schematic view (option only available in Schematic view).

Tools --> Footprint Manager.

On the left, sort by column "Current Footprint."  It will show to the left of that all part designators using that footprint.