SharePoint




Get data and stats about files in document libraries in SharePoint site from SQL Server

SharePoint 2016 Logo

Information about files in document libraries is strored in the table "AllDocs" of Site's content database. Of course, Microsoft doesn't allow to make queries to SharePoint databases directly. But I can't but agree with inserts and updates are not allowed, but select query in the worst case will make just some locks in database. So I guess that in some cases it's much better to execute select query than powershell script.

(read more...)

Migrate managed metadata to new SharePoint farm. Fix cannot bulk load error

Managed metadata is very good and powerful tool in SharePoint. But it has some not very comfortable specialties during migration data from one farm to another, for example, from test environment to productive. You can export your managed metadata from one site and import it into another one. But here's the problem that each termset and term has its own GUID. After you import managed data into the new farm, new GUID’s will be assigned to managed data items.

(read more...)


MarkiMarta.com. Notes of web-specialist
Since 2009
18+