SharePoint Database SQL Query Tips2
by Shantha Kumar • 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 →