SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I'm looking for a simple way to identify the top contributors (content created by or modified by) across my entire site collection. This is strictly for my own use as an adoption tool (think "user of the month") so I don't need an elegant presentation, just the data. Suggestions?

share|improve this question

You can enable usage processing in Central administration then turn on auditing in the site collection. The data can be a bit of a bear to work with, but the reports you can create are flexible enough that you could retrieve some of that data. There are other third party tools that will give you a better grasp on usage and content better if you're looking for a long term solution.

share|improve this answer
Correct about the data being a bear to work with... it might be an architecture issue but I can't seem to pull audit data through the UI (site collection audit reports) that spans any reasonable (like monthly) period without bringing down the site collection. Was hoping for a little magic but will be acquiring a reporting tool from Axceler or AvePoint soon and may have to wait for implementation. – SharePointEric Aug 16 '11 at 14:13
What we've done is to create a separate database then use a timed SQL job to push the auditdata and UserInfo tables to it. The data push has a filter on it so we're only pushing the data we want. Then I can open that database in SSMS and create any reports I want. – Eric Alexander Aug 16 '11 at 14:17
What kind of content do you want to monitor? auditing is not available for publishing pages (broken) and not implemented (per design PSS say) for items – Anders Rask Aug 16 '11 at 18:45

It would be pretty "expensive", but you could use a Data View Web Part (DVWP) with DataSourceMode="CrossList" to count items per user. Since if sounds like you'd run it infrequently, the "expense" might not matter.

The good thing about this approach is that you'd have a lot of control over what you got.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.