Vista - Help looping a script

I've got a script that lists all the Owners of a SharePoint site. I need to
loop it so that it gathers this information for all the sites in an array.

This is what I have so far:

$mysites = Import-CliXml sites.xml

$sitepath="https://mysharepointsite.com"
[System.Reflection.Assembly]::LoadWithPartialName("Microsoft.SharePoint")
$site=new-object Microsoft.SharePoint.SPSite($sitepath)
$web=$site.Rootweb
$web.site.url
$groups = $web.groups | ? {$_.Name -match "^.*Owners" }
foreach($group in $groups)
{
Write-Output "+ $($group.Name)"
foreach($user in $group.users){Write-Output " - $user"}
}

the "$mysites = import-CliXml sites.xml" contains all the sites that I need
to run the remainder of the script against, formatted as so:

- <Props>
<S N="Url">https://mysharepointsite1.com</S>
<S N="Owner">Domain\UserID</S>
<S N="ContentDatabase">ContentDBName</S>
<S N="StorageUsedMB">1.9</S>
<S N="StorageWarningMB">1843</S>
<S N="StorageMaxMB">2048</S>
</Props>
</Obj>
- <Obj RefId="RefId-0">
<TNRef RefId="RefId-0" />

The Url has for each site has to excerpted in $sitepath and the remainder of
the script run against it, and then looped and run against the next Url in
the xml file.

Any suggestions would be greatly appreciated.

Roland

On Feb 20, 4:54*pm, "Roland Serman" <roland.ser...@xxxxxx>
wrote:Hi Roland,

You'd be better off using STSADM in conjunction with PowerShell - this
is quite easy since STSADM returns XML strings for a lot of its
operations:

PS> $xml = [xml](stsadm -o enumsites -url http://localhost)
PS> $xml.sites.site | select Url, Owner | ft -auto

Url Owner
--- -----
http://localhost Domain\user1
http://localhost/MySite NT AUTHORITY\network service

etc.. etc..

You can redirect this to a file by doing:

PS> $xml.sites.site | select Url, Owner | out-file owners.txt

Hope this helps,

- Oisin

The problem is I don't need the Site Collection Owners. I'm trying to get
the users listed in the "<Site Name> Owners" group, which as far as I can
tell is unattainable via stsadm, which is why I've gone the long route and
come up with what I have so far.

Ultimately what I need to do, is generate a list of all users listed as Site
Owners (not site collection owners) for all Site Collections, across
multiple Web Applications, and have it output into an xml file. So far from
what I can tell there is no method of pulling all of this data via stsadm.
I can pull all site collections from a specific Web App via stsadm, which is
how I generate the sites.xml so for now I have to manually update the script
every time I add a new Web Application, I haven't found a way to generate a
list of all Web Apps and their Site Collections.

Roland

"Oisin (x0n) Grehan [MVP]" <oising@xxxxxx> wrote in message
news:b8dc5b45-b719-4ed9-a36c-27a018cc883d@xxxxxx

On Feb 21, 10:08*am, "Roland Serman" <roland.ser...@xxxxxx>
wrote:Ah, I see. How about:

[reflection.assembly]::loadwithpartialname("microsoft.sharepoint")
[reflection.assembly]::loadwithpartialname("microsoft.sharepoint.portal")

[Microsoft.SharePoint.Administration.SPFarm]::local.services | `
% { $_.WebApplications } | % { $_.Sites } |
% { $_.RootWeb } | % { $_.Groups } |
? { $_.Name -like "*Owners" } |
select @{Name="Owners";Expression={$_.Users}}, `
@{Name="Url";Expression={$_.ParentWeb.Url}}

Hopefully the above script doesn't get too mangled with word wrapping.

- Oisin

Not bad at all. The only problem is that it lists "{user1, user2, user3...}"
it also lists them as lastname, firstname, lastname, firstname.

Other than that the script you've provided works beuatifully and does
exactly what I'm looking for. Just need to get to display all users the
users in the group, not just the first 3 or 4, and I need it to list thier
actual User ID's not thier display names. Unfortunatly I'm quite new to
PowerShell, and scripting in general, any idea on how to modify what you've
provided to display the AD user account as apposed to thier display names?

Any thoughts?

Thanks,
Roland

"Oisin (x0n) Grehan [MVP]" wrote: