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 .....

can i get to know which is the database created while installing MOSS 2007 and which all table will have data that is required...

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

hi, In which Database I would find these tables... Thanks in Advance

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

How can you explain in detail... As i need to make an SSRS Report for the same... Thanks in Advance

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

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