Sharepoint Forum

Ask Question   UnAnswered
Home » Forum » Sharepoint       RSS Feeds

Get a list of all top level WSS sites in SPS?

  Asked By: Robin    Date: Nov 22    Category: Sharepoint    Views: 1146

Seems like this should be easy but I can't seem to find anyway to do it
other than a SQL statement, which I would rather not do since MS doesn't
support querying the DB.

I have tried using topology manager to get the spsitecollection but that
gets all teams sites, I only need the top level sites a user has
permissions too. Anyone have any ideas?



14 Answers Found

Answer #1    Answered By: Schuyler Le     Answered On: Nov 22

I would highly suggest checking out SharePoint Explorer it will do exactly what you are looking for. Only downside is that it needs to be installed on an SPS or WSS server. Best of all this tool is free!!

Check it out: www.ontolica.com/.../SharePointExplorerHome.html

Answer #2    Answered By: Kristina Cox     Answered On: Nov 22

Too bad I trying to build a drop down navigation control and need to
know how-to get the top  level wss  sites and display them in a navbar
control. Nice utility though.........I booked marked the site for
future reference. To bad they don't give out the source code so I
could see how they are doing it.

Answer #3    Answered By: Kalyan Pujari     Answered On: Nov 22

Use impersonation to build your drop down if you want users to be able to see everything (even though they may not have access to it).

Answer #4    Answered By: Willard Valenzuela     Answered On: Nov 22

You can use stsadm to get a list  of the Top Level sites  using this command line syntax.

stsadm.exe -o enumsites -url http://portalname > e:\temp\Siteslist.txt

Answer #5    Answered By: Allison Stewart     Answered On: Nov 22

What good does that do for you if someone creates a new site collection though?

Answer #6    Answered By: Emmett Hyde     Answered On: Nov 22

…and get a list  of subsites by doing this:

stsadm.exe -o enumsubwebs -url http://sitename > e:\temp\Subsites.txt

Answer #7    Answered By: Michelle White     Answered On: Nov 22

Is there a way to get allocated storage for each site collection added to this command?

Answer #8    Answered By: Gopal Jamakhandi     Answered On: Nov 22

I’m looking for a quick way to get a list  of all site collections with allocated storage for billing purposes … would only be done on a monthly basis so whatever it was as of the date the command was issued would be fine.

Answer #9    Answered By: Jaime Weaver     Answered On: Nov 22

Although I haven't used it yet, I imagine SQL Reporting Services for Sharepoint would provide this sort of information.

Answer #10    Answered By: Anibal Baird     Answered On: Nov 22

Excellent point. Can an alert be set up to notify me when a new site or sub-site is created, in order to add it to an spsbackup or smigrate routine?

Answer #11    Answered By: Karla Morrison     Answered On: Nov 22

Can you explain your thought a little more. I use SQL Reporting Services all the time & I would like to try this.

Answer #12    Answered By: Patricia Richardson     Answered On: Nov 22

The Report Pack for Sharepoint does include several sample reports
that provide allocated and actual database storage sizes. For our
billing purposes we customized some of the reports to also include a
factor for overhead - Indexes and external content sources can
greatly increase the true disc space used.

That said though, quick it is not. After using the RS approach for a
few months we are still looking at other utilities because the RS DEP
(data extraction) processes is very resource intensive, especially if
you have very large farm(s). If you only need to run it once a month
during off hours it might work fine for you.

Answer #13    Answered By: Alexandra Patterson     Answered On: Nov 22

Can you use SRS to report on numbers of records in a list  entered by
particular users or with specific values in particular fields? More
specifically can it do that on wss  lists?

I've used SRS to query CRM 1.2 data (and will be using it soon when we
upgrade to 3.0) but didn't realise it could work with Sharepoint.

Answer #14    Answered By: Christop Mcfadden     Answered On: Nov 22

You can get the source code for the SharePoint Database Explorer that
James Edelen wrote. His code can be download from

Didn't find what you were looking for? Find more on Get a list of all top level WSS sites in SPS? Or get search suggestion and latest updates.