Logo 
Search:

Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Admin Tools: Sites Listing?

  Asked By: Julian    Date: Jan 29    Category: Sharepoint    Views: 7647

Can someone direct me to where I could obtain a listing of all of the sites within SharePoint? To take this further it would be great to be able to also pull up date created, owner information, size along with any activity information pertaining to that site.

Trying to clean up several months of testing and retesting of team sites.

Share: 

 

4 Answers Found

 
Answer #1    Answered By: Beau Pena     Answered On: Jan 29

I would like a solution for this also. We have a lot of different sites  on the farm and the users would really like to go and see a list of all sites they have access to. I have seen the web part from Jan (Tree-Viewer) but that only shows from a site  and down, not the entire farm. We can do an enumsites, but that doesn’t do any good for the user. We can try to manage them through a sites area, but that is not updated, so users can get dead links. Any thoughts or suggestions?

 
Answer #2    Answered By: Isaiah Santiago     Answered On: Jan 29

You’ll need to write code to get a list of all the sites  in a farm. There is no such tool in SPS OOB.

 
Answer #3    Answered By: Robert Wilson     Answered On: Jan 29

While it's true, as Bill stated, that there is no admin  tool that
would allow you to do this and code would have to be created, you
can access this information  directly from the database for each of
your portal instances. In your _Sites database, execute the
following SQL code:

SELECT dbo.Webs.Title, dbo.Webs.Description, dbo.Webs.FullUrl,
dbo.UserInfo.tp_Title AS Owner, dbo.Webs.TimeCreated, DATEADD(d,
dbo.Webs.DayLastAccessed + 65536, CONVERT
(datetime, '1/1/1899', 101)) AS [Day Last Accessed],
'http://your.PortalURL.com/' +
dbo.Webs.FullUrl + '/_layouts/1033/deleteweb.aspx' AS [Delete Link],
dbo.UserInfo.tp_Email, dbo.Webs.WebTemplate,
dbo.Webs.RequestAccessEmail
FROM dbo.Webs INNER JOIN
dbo.UserInfo ON dbo.Webs.Author =
dbo.UserInfo.tp_ID
WHERE (DATEADD(d, dbo.Webs.DayLastAccessed + 65536, CONVERT
(datetime, '1/1/1899', 101)) < CONVERT(DATETIME, '2078-01-01
00:00:00', 102))

I have an Access database template that I dump these query results
in (along with data from my Audit Docs and Audit Users query
results). Then, I turn the Access db over to our portal community
administrators. I've pre-populated that database with a number of
queries to help them manage their communities.

 
Answer #4    Answered By: Chase Wagner     Answered On: Jan 29

You could append /_layouts/1033/mngsubwebs.aspx to the tail of any site
for the list of immediate child sites. I find this a quick and efficient
way to delete child sites.

Or for a more global list of child sites  in an entire site  Collection
append /_layouts/1033/vsubwebs.aspx to the tail of any Site Collection.
From the Manage link you can Delete this site.

But, Bill is right, there isn't anything out of the box that gives you
visibility to all the sites in the farm. However, I don't think that
that page would not be difficult to write.

 
Didn't find what you were looking for? Find more on Admin Tools: Sites Listing? Or get search suggestion and latest updates.




Tagged: