How can I query the database to see what content is using Macros?

AaronSadlerUK · February 4, 2026, 7:51pm

How can I use a SQL query to get all of the content which contains a Macro?

AaronSadlerUK · February 4, 2026, 7:51pm

I’ve already solved this, but for historical purposes I have logged it here:

gist.github.com

https://gist.github.com/AaronSadlerUK/f2bb83ccaf0b23840f6c06b45e536de1

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

This file has been truncated. show original