Find Umbraco Macro usage

query.sql

-- Find PUBLISHED content with macros in Umbraco 13
SELECT DISTINCT 
    n.text AS 'Content Name',
    n.id AS 'Node ID',
    pt.Alias AS 'Property Alias',
    SUBSTRING(pd.textValue, 1, 500) AS 'Preview'
FROM umbracoPropertyData pd
INNER JOIN umbracoContentVersion cv ON pd.versionId = cv.id
INNER JOIN umbracoDocumentVersion dv ON cv.id = dv.id AND dv.published = 1
INNER JOIN umbracoNode n ON cv.nodeId = n.id
INNER JOIN cmsPropertyType pt ON pd.propertyTypeId = pt.id
WHERE pd.textValue LIKE '%<?UMBRACO_MACRO%'
   OR pd.textValue LIKE '%umb://macro/%'
   OR pd.textValue LIKE '%"macroAlias"%'
ORDER BY n.text;