原生解决方案
- 下载并安装 SharePoint Online Client Components SDK。
- 打开 PowerShell ISE。
- 运行以下脚本，并为 $Url 和 $Path 变量输入相应的值，以指定 SharePoint 站点地址和报告输出路径：
#SPO-specific cmdlets require sharepoint-online module
Install-Module -NameMicrosoft.Online.SharePoint.PowerShell
$ServiceURL ="https://enterprise-admin.sharepoint.com"
$URL = "https://enterprise.sharepoint.com"
$Path = "C:\Temp\GroupsReport.csv"
$Cred = Get-Credential
#Connect to SharePoint Online
Connect-SPOService -url$ServiceURL -Credential$Cred
#Generating Report
$GroupsData = @()
#get sharepoint online groups powershell
$SiteGroups =Get-SPOSiteGroup -Site$URL
ForEach($Group in $SiteGroups) {
$GroupsData +=New-Object PSObject-Property @{
'Group Name' =$Group.Title
'Permissions' =$Group.Roles -join ","
'Users' = $Group.Users -join ","
}
}
#Export the data to CSV
$GroupsData |Export-Csv $Path-NoTypeInformation
- 查看您的 CSV 报告：
Netwrix Auditor for SharePoint
- 运行 Netwrix Auditor。依次转到“Reports”-> 点击“Predefined”-> 展开“SharePoint Online”部分 -> 进入“SharePoint Online – State-in-Time” -> 选择“SharePoint Online Object Permissions” -> 点击“View”。
- 在“Object Path”字段中指定站点 URL，然后 -> 点击“View Report”。
- 查看易于理解的报告：
分享到