• Archive for March 23rd, 2009

    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 →