SharePoint User Group UK

Hi,

If you navigate to your 12 Hive (typically C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12) and then the bin directory, you can run the following command which uses the object model to enumerate the sites

stsadm.exe -o enumsites   -url <virtual server url>   -showlocks

---

Paul Leigh

Hi Paul,

Thanks for the reply. But I believe that you have sent the solution for WSS3.0/MOSS2007. And another thing is, the command you have mentioned here (stsadm.exe -o enumsites ....) can list only the top-level sites under a portal-site. My requirement is for WSS2.0/SPS2003 packs. I want to list all the portal-sites  with the port numbers. i.e. A machine can contain number of portal-sites with different port-number. that's right? like, http://winserver:6060, http://winserver:1324, http://winserver:5050 ... etc. I just want to get all these URLs anyway by writing a program.

Can I get those URLs by searching into any file or registry or SQL Database etc.? So it will be easy for me to then list all the top-level sites under them and continue further using "STSADM.exe". Is that right, I have used the word "Portal-sites" for referring '
http://winserver:6060, http://winserver:1324'... etc.? Hope you understand my need.. Thank you very much for your reply in advance.

Nesan Joseph R.

Hi,

You can query the database (there's one db per portal in wss2.0), so something along the lines of of a sql query such as:

SELECT [FullUrl] FROM Sites

Will give you what you want I think. In the registry, you may find the settings for the IIS meta tables but it wouldn't include such items as sub sites, it'll only contain the top level Website details as the WSS info is db centric.

---

Paul Leigh

Hi Paul,

Thanks for the details. I think that would help me a lot. Thanks again.

Nesan Joseph R.