Take the 2-minute tour ×
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It's 100% free, no registration required.

It is possible to generate reports from the SharePoint Database with informations like current users, teamsites, websites etc. ? I heard maybe it is possible with the WSS-Logging Database.

Are there any examples? Experience with generating reports like this? Other solutions?

share|improve this question
add comment

3 Answers

PowerShell is going to be your best bet. Interacting directly with the database is not encouraged.

share|improve this answer
add comment

there are commercial vendors (Avepoint, Idera, Quest, et al) that offer reporting utilities that read the SP databases.. you may want to consider using the Usage & Health Data services to obtain similar information (see - http://technet.microsoft.com/en-us/library/ee663480.aspx ).

share|improve this answer
1  
found a nice blog post regarding Web Analytics Reporting (as per John Chapman's post above) - blogs.msdn.com/b/ecm/archive/2010/03/21/… –  Supriyo SB Chatterjee Dec 1 '11 at 15:22
add comment

Under Site Actions > Site Settings there are some analytics at the site collection and site levels.

For Farm Level analytics, goto Central Admin and under Monitoring goto View Web Analytics.

For more farm-level reports (i.e. structure, sites, etc.) we use SPDocKit.

share|improve this answer
add comment

Your Answer

 
discard

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.