Shantha Kumar

Shantha Kumar

SharePoint Database SQL Query Tips3

Now, we are going to retrive the file details from AllDocs Database. Which has the informations about the files stored in SharePoint List or Library. — Returns all document from all lists availabe in WebApplication SELECT AllDocs.Leafname AS FileName’,                   AllDOcs.Dirname AS ‘Folder…

SharePoint Database SQL Query Tips2

Today, we are going to see the query for returning Webs and Site Collections available in the Database (WebApplication). –Returns Total Number of Site Collections in WebApplication select  count(*) as ‘Total Site Collection’ from sites –Returns Root Site Title for each…

SharePoint Databases

I did some research on SharePoint Databases and how are they providing datas to SharePoint sites?. Here i am come up with some details of Databases used in SharePoint. Database Name Description Availablity SharePoint_AdminContent_ GUID This is the Central Admin…