Skip to content

Instantly share code, notes, and snippets.

@AntMooreWebDev

AntMooreWebDev/find-umbraco-file.sql

Created February 11, 2021 14:54
Show Gist options
  • Save AntMooreWebDev/0e84a8b06710adb20d11152bc216b3fd to your computer and use it in GitHub Desktop.
Save AntMooreWebDev/0e84a8b06710adb20d11152bc216b3fd to your computer and use it in GitHub Desktop.
Download ZIP
Raw
find-umbraco-file.sql
/****** Script for SelectTopNRows command from SSMS ******/
SELECT TOP (1000) [id]
,[contentNodeId]
,[versionId]
,[propertytypeid]
,[dataInt]
,[dataDecimal]
,[dataDate]
,[dataNvarchar]
,[dataNtext]
FROM [dbo].[cmsPropertyData]
where propertytypeid in (Select id from cmsPropertyType where alias = 'umbracoFile')
AND (dataNtext LIKE '%[FILENAME]%' OR
dataNvarchar LIKE '%[FILENAME]%')
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment