Upgrading to Umbraco Version 14: Finding Macros

Does anyone have a DB query or another method to identify nodes that are using macros in version 13? I’m in the process of moving all macro content to Blocks, but finding every instance of every macro partial file requires opening and checking each node and we have a couple thousand nodes in our site.


This is a companion discussion topic for the original entry at https://our.umbraco.com/forum/114456-upgrading-to-umbraco-version-14-finding-macros