A critical vulnerability was discovered in React Server Components (Next.js). Our Systems Remain Fully Protected. Learn More.

AI OnAI Off

Home / Blogs / 2016 / 10 /

Per Nergård (MVP)

Oct 17, 2016

2076

(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 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) 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 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 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.

Jhoose Security Modules v2.6.0 — Added support for Permissions Policy and .NET 10

Version 2.6.0 adds Permissions Policy header support, updates to .NET 10, improved policy management, configurable security settings, and enhanced...

Andrew Markham | Dec 6, 2025 |

Building a 360° Customer Profile With AI: How Opal + Optimizely Unlock Predictive Personalization

Creating truly relevant customer experiences requires more than collecting data—it requires understanding it. Most organizations already have rich...

Sujit Senapati | Dec 4, 2025

Building a Lightweight Optimizely SaaS CMS Solution with 11ty

Modern web development often requires striking a difficult balance between site performance and the flexibility needed by content editors. To addre...

Minesh Shah (Netcel) | Dec 3, 2025

Creating Opal Tools Using The C# SDK

Over the last few months, my colleagues at Netcel and I have partaken in two different challenge events organised by Optimizely and centered around...

Mark Stott | Dec 3, 2025

See all blogs