A critical vulnerability was discovered in React Server Components (Next.js). Our systems remain protected but we advise to update packages to newest version. Learn More. 

AI OnAI Off
Per Nergård (MVP)
Per Nergård (MVP)
Oct 17, 2016
  2122
(2 votes)

List editors and how many pages they have created.

Wouldn't it be fun to have a list wich presented all editors and how many pages they have created? Maybe not so fun but in one case this is what I wanted to present. So i whipped togheter a simple aspx page that does just that.

Image highscore.jpg

As usal code over at my Gist.

Oct 17, 2016

Comments

Henrik Fransas
Henrik Fransas Oct 18, 2016 08:28 AM

Nice, or you can play around with SQL and with this simple query get content per contenttype per user... ;-)

Select CreatorName, ct.[Name], COUNT(*) NrOfContent
From tblContent c inner Join tblContentType ct on c.fkContentTypeID = ct.pkID
Group by CreatorName, ct.[Name]
order by CreatorName, NrOfContent Desc, ct.[Name]

Per Nergård (MVP)
Per Nergård (MVP) Oct 18, 2016 08:47 AM

I don't like SQL :)

This was a quick hack. Have been thinking of doing more of a dashboard thing with some charts and stuff.

Henrik Fransas
Henrik Fransas Oct 18, 2016 08:56 AM

I love SQL it is so powerful!

Ok, sounds great, add it as a gadget also so you can have it on the dashboard.

Aria Zanganeh
Aria Zanganeh Oct 18, 2016 01:23 PM

Great job mate.. It could be good idea to have another column for "Site" so you know per site! And another dashboard of number of awaiting pages for approval per user :D Motivate lazy people :)

May 15, 2017 02:07 PM

Please login to comment.
Latest blogs
ScheduledJob for getting overview of site content usage

In one of my current project which we are going to upgrade from Optimizely 11 I needed to get an overview of the content and which content types we...

Per Nergård (MVP) | Jan 27, 2026

A day in the life of an Optimizely OMVP: Migrating an Optimizely CMS Extension from CMS 12 to CMS 13: A Developer's Guide

With Optimizely CMS 13 now available in preview, extension developers need to understand what changes are required to make their packages compatibl...

Graham Carr | Jan 26, 2026

An “empty” Optimizely CMS 13 (preview) site on .NET 10

Optimizely CMS 13 is currently available as a preview. If you want a clean sandbox on .NET 10, the fastest path today is to scaffold a CMS 12 “empt...

Pär Wissmark | Jan 26, 2026 |

Building AI-Powered Tools with Optimizely Opal - A Step-by-Step Guide

Learn how to build and integrate custom tools with Optimizely Opal using the Opal Tools SDK. This tutorial walks through creating tools, handling...

Michał Mitas | Jan 26, 2026 |

See all blogs