Windows Server

Rob Mayo · Guest

My boss wants me to write a front end for configuring/installing web parts.
Basically, a UI for stsadm.exe. I was considering scouring the
SPS01_Config_Db database on the sql server instance Sharepoint is configured
on to retrieve supporting data for this app (provided I know where a portal
server is configured).

I understand that other databases are created on that server for the various
virtual servers, etc. All of which can be queried from the VirtualServers
table

I was wondering if sharepoint uses any other database names, for example, if
another Sharepoint-configured server (not virtual server) uses the same
database server for its config, is there another database created, perhaps
with the name SPS02_Config_Db? I just want to know if SPS01_Config_Db will
be the only database I need to look for to find supporting data.

--

Any help is appreciated.
Thanks in advance.

Rob Mayo

Brad Covelle · Guest

There is already a UI for stsadm.exe available out there. Maybe one of the
MVPs can point you to it.

Why do you want to look at the Config DB though? I don't understand why you
would need to even mess with the databases to write a simple UI for stsadm.

--
Brad Covelle
NuSoft Solutions
bcovelle@nusoftsolutions.com
http://blogs.sagestone.net/bcovell

"Rob Mayo" <NOSPAM@NOSPAM.com> wrote in message
news:e$hUb3u5FHA.3544@TK2MSFTNGP09.phx.gbl...

Rob Mayo · Guest

My boss wants me to be able to enumerate all the Sharepoint virtual servers
configured on a server, then enumerate all the sites, personal sites, etc.
Then he wants the app to make decisions as to which of our custom web parts
to deploy to what sites based on that information. I didn't say it was a
SIMPLE UI ;)

"Brad Covelle" <bcovelle@nusoftsolutions.com> wrote in message
news:eKLMw8u5FHA.2956@TK2MSFTNGP12.phx.gbl...

Brad Covelle · Guest

Found it:
http://www.microsoft.com/sharepoint/downloads/components/detail.asp?a1=443

--
Brad Covelle
NuSoft Solutions
bcovelle@nusoftsolutions.com
http://blogs.sagestone.net/bcovell

"Rob Mayo" <NOSPAM@NOSPAM.com> wrote in message
news:e$hUb3u5FHA.3544@TK2MSFTNGP09.phx.gbl...

Brad Covelle · Guest

You can do this by using the SharePoint API. It allows you to iterate
through all the SPVirtualServers and then all the sites in the servers. This
is how i would do it, reference the SharePoint sdk for assistance.

--
Brad Covelle
NuSoft Solutions
bcovelle@nusoftsolutions.com
http://blogs.sagestone.net/bcovell

"Rob Mayo" <NOSPAM@NOSPAM.com> wrote in message
news:eHpx0Bv5FHA.3500@TK2MSFTNGP11.phx.gbl...

Rob Mayo · Guest

Thanks Brad, but my app needs to do a lot more than that. Could you tell me
more about the API's

"Brad Covelle" <bcovelle@nusoftsolutions.com> wrote in message
news:ORXD2Fv5FHA.252@TK2MSFTNGP15.phx.gbl...

Brad Covelle · Guest

Here's a sample from the sdk:

SPGlobalAdmin globAdmin = new SPGlobalAdmin();
SPGlobalConfig globConfig= globAdmin.Config;
SPVirtualServer vServer = globAdmin.VirtualServers[0];

Label1.Text += "Administrator Group: " + globConfig.AdminGroup +
"Host: " + vServer.HostName + "<BR>";

SPSiteCollection sites = vServer.Sites;

foreach (SPSite site in sites)
{
SPSite.UsageInfo uInfo = site.Usage;

Label1.Text += "URL: " + site.Url + " Bandwidth: " +
uInfo.Bandwidth.ToString() +
" Hits: " + uInfo.Hits.ToString() + " Visits: " +
uInfo.Visits.ToString() + "<BR>";
}

It basically gets a virtual server, goes through each site in the server and
gathers some information. You could easily do this:

foreach(SPVirtualServer vs in globAdmin.VirtualServers)
{
foreach(SPSite site in vs.Sites)
{
//collect all the information from lists, users, docs...
}
}

Download:
http://www.microsoft.com/downloads/details.aspx?FamilyId=AA3E7FE5-DAEE-4D10-980F-789B827967B0&displaylang=en

--
Brad Covelle
NuSoft Solutions
bcovelle@nusoftsolutions.com
http://blogs.sagestone.net/bcovell

"Rob Mayo" <NOSPAM@NOSPAM.com> wrote in message
news:%233tLjUv5FHA.1864@TK2MSFTNGP12.phx.gbl...

	Windows Server Forum Index -> Portal Server	All times are GMT
Page 1 of 1