|
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? |
|||
|
|
|
PowerShell is going to be your best bet. Interacting directly with the database is not encouraged. |
|||
|
|
|
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 ). |
|||||
|
|
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. |
|||
|
|
