Skip to content

Instantly share code, notes, and snippets.

@csharpforevermore

csharpforevermore/GetMacroCacheDetails.sql

Created February 17, 2014 09:27
Show Gist options
  • Save csharpforevermore/9047468 to your computer and use it in GitHub Desktop.
Save csharpforevermore/9047468 to your computer and use it in GitHub Desktop.
Download ZIP
Umbraco 4.9.1 - show all macro cache settings.
Raw
GetMacroCacheDetails.sql
/****** Script for SelectTopNRows command from SSMS ******/
SELECT
macro AS 'ID',
macroName AS 'Name',
macroPropertyAlias AS 'Alias',
macroRefreshRate AS 'Timeout'
FROM [dbo].[cmsMacroProperty] AS table1
LEFT OUTER JOIN [dbo].[cmsMacro] AS table2
ON table1.macro = table2.id
WHERE macroRefreshRate > 0
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment