Apr 03 2020 01:26 PM
Dear All,
We have a requirement that need to pull all planner details including created and owners information. We able get the same information by using below Powershell (MS graph PowerShell module) script but the big drawback of the script is , user/account who executing the script should be part of the every group in order to pull all group planner information but we cannot add any user/account in all groups (more than 1000 groups) in our prod tenant to do the same.
Could you please suggest how can we pull planner information using farm/global account or any work around for the same
Appreciate any reply in advance.
$groupid = $gids.'GroupID'
Write-Host $groupid -ForegroundColor Green
#Start-Sleep -Seconds 5
$Gplannner = Get-GroupPlannerPlan -GroupId $groupid
foreach( $gp in $Gplannner )
{
Write-Host $gp.Id
$gprow = [pscustomobject]@{
Id = $gp.Id
Title = $gp.Title
Owner = $gp.Owner
CreatedDateTime = $gp.CreatedDateTime
#MembersSMTP = $MembersSMTP -join "`n"
#OwnersSMTP = $OwnersSMTP -join "`n"
#MembersSMTP = $objMem
Members = ""
}
$GroupsCSV+=$gprow
}
Apr 03 2020 11:55 PM
@Chandu_Bheemuni It is not possible to pull the planner reports without adding the service account as a member of all Office365 groups. We have tried different ways and nothing helped.