How can you identify all nodes that use a certain paragraph type or template?
As @runwithscissors stated in the comments, you can use views to to this.

I’m not super experienced with views in Drupal 7, but It should be as easy as:


Create a view that lists the nodes .
Add a relationship to the referenced paragraphs.
Add a filter on the paragraphs bundle.


That should be all. Once you have added the relationship, the bundle field will be made available as a filter.

I hope this is as easy in Drupal 7 as it is in Drupal 8.

You can read more about views here.