Forum Discussion

Copper Contributor

Jun 26, 2017

Solved

how to i add export command to the below script

how to i add export command to the below script $siteURL = "https://litwareinc.sharepoint.com/sites/finance" $x = Get-SPOSiteGroup -Site $siteURL foreach ($y in $x) { Write-Host $y.Ti...

powershell

sharepoint

Pieter Veenstra

Jun 26, 2017

How about:

($siteURL = "https://litwareinc.sharepoint.com/sites/finance"
$x = Get-SPOSiteGroup -Site $siteURL
foreach ($y in $x)
    {
        Get-SPOSiteGroup -Site $siteURL -Group $y.Title | Select-Object -ExpandProperty Users
    })| Export-Csv -Path c:\temp\test.csv

Manidurai Mohanamariappan

Iron Contributor

Jun 27, 2017

Try this script

$siteURL = "https://litwareinc.sharepoint.com/sites/finance"
$x = Get-SPOSiteGroup -Site $siteURL
$GroupList = @()


foreach ($y in $x)
    {
       
        
        $users= Get-SPOSiteGroup -Site $siteURL -Group $y.Title | Select-Object -ExpandProperty Users
                   $Group = "" | Select "Groupname","Userslist"
                   $UsersList = ''
                      foreach($user in $users)
                      {
                         If($UsersList) 
                           {
                             $UsersList=$UsersList + ";" + $user.ToString()
                           } 
                         Else 
                         {
                          $UsersList=$user.ToString()
                         }
                      }
                      $Group.Groupname = $y.Title
                     $Group.Userslist = $UsersList
                     $GroupList+= $Group

        
    }
$GroupList |Export-csv C:\csv\groupwithusers.csv -NoTypeInformation

pardeep soba
Copper Contributor
Jul 04, 2017
Get-MsolUser -All | Where-Object {$_.Domain -eq "centricaplc.onmicrosoft.com"} | Export-CSV c:\support\cloud.csv

please help am stuck