Skip to content

Instantly share code, notes, and snippets.

@csharpforevermore

csharpforevermore/ListAllCachedUmbracoMacros.sql

Created February 17, 2014 09:19
Show Gist options
  • Save csharpforevermore/9047372 to your computer and use it in GitHub Desktop.
Save csharpforevermore/9047372 to your computer and use it in GitHub Desktop.
Download ZIP
In Umbraco, sometimes you want to know how many macros have caches. This query will tell you how long has been set on each macro.
Raw
ListAllCachedUmbracoMacros.sql
/****** Script for SelectTopNRows command from SSMS ******/
SELECT *
FROM [dbo].[cmsMacro]
WHERE macroRefreshRate > 0
@csharpforevermore
Copy link
Author

Works with Umbraco 4.9.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment