• Posts Tagged ‘Tips Series’

    SharePoint Database SQL Query Tips3

    by  • March 23, 2009 • General • 3 Comments

    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 Path’,                   AllLists.tp_Title AS ‘List Title’,                  Webs.Title AS ‘Web Title’ FROM AllDocs JOIN AllLists ON AllLists.tp_Id=AllDocs.ListId JOIN Webs ON [...]

    Read more →

    SharePoint Database SQL Query Tips2

    by  • March 19, 2009 • MOSS, SharePoint • 3 Comments

    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 Site Collection available in WebApplication  select Title as ‘Root Web Title’, Sites.RootWebId, Sites.Id as ‘Site Collection [...]

    Read more →