Sharepoint output list of users

Question

I would like to output the users of a group, for 40 groups, or for every group within the SharePoint Portal. I would like to do this programatically through powershell or a command line tool for the benefit of getting users in Textual Form for reporting purposes, or another means that provide textual output.

Can some one point me in the right direction?

Answer 1

Here you have fully functional PS script:

Add-PsSnapin Microsoft.SharePoint.PowerShell

$siteUrl = "http://mycoolsite"
$web = Get-SPWeb $siteUrl

@(foreach ($group in $web.SiteGroups) {
  foreach($user in $group.Users) {
    $usergroup = New-Object System.Object
    $usergroup | Add-Member -type NoteProperty -name GroupName -value $group.Name
    $usergroup | Add-Member -type NoteProperty -name UserName -value $user.Name

     Write-Output $usergroup 
    }
}) | Export-Csv userlist.csv -NoTypeInformation

Output will be userlist.csv file with 2 columns Group Name, User Name

Answer 2

You could create a console application for SharePoint. in VS2010 An example for all groups would be:

using (SPSite site = new SPSite("http://yoursiteurl"))
{
  using(SPWeb web = site.OpenWeb()) 
  {
    foreach(SPGroup grp in web.SiteGroups) 
    {
      foreach(SPUser usr in grp.Users) 
      {
        string sGroupName = grp.Name;
        string sLogin = usr.LoginName;
        string sName = usr.Name;
        string sEmail = usr.Email;
        int uId = usr.ID;
        //Output the user info here 
      }
    }
  }
}

If you need this for reporting services, you could create Linq to SQL classes or Entity Framework to write directly to some database that would serve as a source for reporting services.