I need to know the sites and subsites hosted
Hello , Could please help me get to the sites and subsites on my MOSS 2007 server. I want to know which database and tables i need to check .....
January 31st, 2011 8:32pm
can i get to know which is the database created while installing MOSS 2007
and which all table will have data that is required...
Free Windows Admin Tool Kit Click here and download it now
February 1st, 2011 2:17pm
Hi Prince:
Following tables hold the data:
Sites: This Table holds information about all the site collections for this content database.
Webs: This Table holds information about all the specific sites (webs) in each site collection.
Queries to fetch data:
Query to get all the top level site collections ---SELECT SiteId AS Siteid, Id AS Webid, FullUrl AS FURL, Title, Author, TimeCreated FROM dbo.Webs WHERE (ParentWebId IS NULL)
Query to get all the child sites in a site collection ---SELECT SiteId AS Siteid, Id AS Webid, FullUrl AS FURl, Title, Author, TimeCreated FROM dbo.Webs WHERE (NOT (ParentWebId IS NULL))
Hope this helps.
Thanks,Sharepoint Consultant from NY, USA
February 2nd, 2011 11:01am
hi,
In which Database I would find these tables...
Thanks in Advance
Free Windows Admin Tool Kit Click here and download it now
February 6th, 2011 10:14am
Hi, I suggest to follow a different way. You can obtain the same results using stsadm or PowerShell. You can obtain the full lists of web application, site collection, web, database, etc without having to know anything about database table, schema and so
on.
Cheers
Riccardofino a qu tutto bene
February 7th, 2011 3:09pm
How can you explain in detail... As i need to make an SSRS Report for the same...
Thanks in Advance
Free Windows Admin Tool Kit Click here and download it now
February 7th, 2011 10:40pm
This is the 2010 forum, and you're asking about 2007. I will move the thread now, but please use the correct forum in the future.
Also, NEVER post a thread and say that it's urgent. This is a free forum where people provide help in their free time. If you have an urgent need, then you hire a consultant or call Microsoft Paid support. I have removed
that text from your post.SharePoint Architect || Microsoft MVP ||
My Blog
Planet Technologies ||
SharePoint Task Force
February 7th, 2011 11:24pm
Hi Prince, you can use stsadm enumallwebs command to get the list of sites and webs in your content databases
http://technet.microsoft.com/en-us/library/dd793606(office.12).aspx. You get an xml report, I don't know how much it is really useful for you SSRS report.
You can also use powershell, but in SharePoint 2007 we have not specific cmdlets. You have to create a custom script that loop in your web applications and create your custom report. Here you can find a good post to start
http://sharepoint.microsoft.com/blogs/zach/Lists/Posts/Post.aspx?ID=7
Cheers
Riccardofino a qu tutto bene
Free Windows Admin Tool Kit Click here and download it now
February 8th, 2011 2:29am