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.

(more...)

Escape curly brackets in ID in jQuery

I have a table in SharePoint list view which ID contains curly brackets '{9C48B48F-AA4E-4B34-8CE6-37E4C0EBAD8B}-{9B1EEE61-5E3C-4CA1-96CD-DB15199EDC83}'. I tried to select the table using jQuery but on the brackets I've got a Javascript error about a sequence of characters.

(more...)


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