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?

2 Answers 2


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.

  • 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. Aug 16, 2011 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. Aug 16, 2011 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 Aug 16, 2011 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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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