Per Nergård
Oct 17, 2016
(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


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]

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
Vulnerability in EPiServer.GoogleAnalytics v3 and v4

Introduction A potential security vulnerability was detected for Optimizely Google Analytics addon (including EPiServer.GoogleAnalytics and...

Bien Nguyen | Sep 20, 2023

Overriding Optimizely’s Content Recommendations Block to Implement Custom Recommendations

Introduction The Content Recommendations add-on for Optimizely CMS dynamically recommends content from your site tailored to the interests of each...

abritt | Sep 13, 2023 | Syndicated blog

Developer contest! Install the AI Assistant and Win Bose QC45 Headphones!

We are thrilled to announce a developer contest where you have the chance to win a pair of Bose Headphones. The goal is to be the first developer t...

Luc Gosso (MVP) | Sep 7, 2023 | Syndicated blog

Send Optimizely notifications with SendGrid API, not SMTP

If your Optimizely site already sends transaction emails through an email platform API, why not do the same with Optimizely notification emails?

Stefan Holm Olsen | Sep 6, 2023 | Syndicated blog