Office 365 视频迁移准备工具Office 365 Video migration preparation tool

可通过 管理员自助服务迁移工具从 Office 365 视频门户本身运行 Office 365 视频 to Stream 迁移。The Office 365 Video to Stream migration can be run from the Office 365 Video portal itself via the admin self-service migration tool. 但是,在准备运行迁移时,你可能希望通知并与你的迁移即将到来的所有渠道所有者进行协作。However in preparation for running the migration you may want to notify and work with all your channel owners that the migration is coming. 以下工具可用于导出 CSV 电子表格,其中包含每个 Office 365 视频通道的相关信息,其中包括每个频道的所有者以及频道中的多少视图视频在最近几个月内。The following tool can be used to export a CSV spreadsheet with information about each of your Office 365 Video channels including who owns each channel and how many views videos in the channel have had in the last several months.

工具输出的信息在规划迁移时非常有用。The information output by the tool can be very helpful in planning your migration. 渠道所有者列表非常有用,可帮助您确定您的主要障碍负责人,以便与迁移进行讨论。The list of channel owners is very useful in helping you determine who are your key stake holders to discuss the migration with. 每个通道的视频视图数总和可用于帮助您确定 Office 365 视频中是否有一些频道不再使用,应在迁移运行之前将其视为被删除。The sum of the video view counts per channel can be used to help you determine if there are some channels in Office 365 Video that aren't being used anymore and should be considered to be deleted before the migration is run.

下载: PowerShell 脚本以输出 Office 365 视频通道信息Download: PowerShell script to output Office 365 Video channel info

脚本更新:Script updates:

  • 1/13/2020-在报告和日志文件中修复非英语字符的输出1/13/2020 - Fix output of non-english characters in report and log files
  • 1/10/2020-当网站未使用英语语言时,修复所有者/编辑者/查看者权限 & 添加3个新列以输出每个频道的非电子邮件权限1/10/2020 - Fix owner/editor/viewer permissions when site not using English language & add 3 new columns to output non email permissions for each channel
  • 11/20/2019-添加对多重身份验证登录 & 添加每通道视频视图的总和的支持11/20/2019 - Add support for multifactor auth login & add sum of video views per channel

先决条件Prerequisites

  1. 了解你的租户的 SharePoint online URL (示例: https://contoso.sharepoint.com)Know your SharePoint online URL for your tenant (example: https://contoso.sharepoint.com)
  2. 能够在你的计算机上运行 PowerShell 脚本Be able to run PowerShell scripts on your machine
  3. 能够在你的计算机上从 internet 安装新的 PowerShell 模块Be able to install new PowerShell modules from the internet on your machine
  4. 是 Office 365 全局管理员或 SharePoint 管理员Be an Office 365 Global admin or a SharePoint admin
  5. 下载 脚本 的 zip 文件并将其解压缩到计算机上的文件夹Download the zip file of the script and unzip it to a folder on your machine

运行脚本Running the script

  1. 在你的计算机上查找 PowerShellFind PowerShell on your machine

  2. 右键单击 PowerShell 应用程序并 以管理员身份运行Right click the PowerShell application and Run as administrator

  3. 在 Powershell 中安装 SharePoint Online 模块Install the SharePoint Online module in Powershell:

    安装模块 Microsoft Online。Install-Module Microsoft.Online.SharePoint.PowerShell

    (或者如果已安装 SharePoint Online 模块,则可以对其进行更新: 更新模块 Microsoft Online) (Or if the SharePoint Online module is already installed you can update it: Update-Module Microsoft.Online.SharePoint.PowerShell)

  4. 在 Powershell 中安装 SharePoint PnP 模块Install the SharePoint PnP module in Powershell:

    Install-Module SharePointPnPPowerShellOnlineInstall-Module SharePointPnPPowerShellOnline

    (或者,如果已安装 SharePoint PnP 模块,则可以对其进行更新: update-Module SharePointPnPPowerShellOnline) (Or if the SharePoint PnP module is already installed you can update it: Update-Module SharePointPnPPowerShellOnline)

  5. 在 PowerShell 中对脚本解压缩的目录进行更改 (例如: cd c:\temp) In PowerShell change to the directory where you unzipped the script (example: cd c:\temp)

  6. 在此 PowerShell 会话上更改执行策略以允许运行此临时脚本:Change the execution policy on this session of PowerShell to allow running this ad-hoc script:

    ExecutionPolicy-ExecutionPolicy 旁路作用域进程Set-ExecutionPolicy -ExecutionPolicy Bypass -Scope Process

  7. 运行脚本:Run the script:

    .\video-channels-info.ps1.\video-channels-info.ps1

  8. 按照脚本提示输入您的 SharePoint Online 租户 URL (示例: https://contoso.sharepoint.com)Enter your SharePoint Online tenant URL as prompted by the script (Example: https://contoso.sharepoint.com)

  9. 选择是否要报告每个频道的视频视图。Choose if you want to report on video views per channel. 这将循环访问频道中的每个视频,并在最近24个月中汇总每个视频上的视图。This will loop over each video in the channel and sum up the views on each video in the last 24 months.

    • y-是,输出每个通道的视图数据 (这将导致报告运行时间更长) y - Yes, output the view data per channel (this will make the report take much longer to run)
    • n-否,不输出视图数据n - No, don't output the view data

    备注

    此脚本部分会调用 SharePoint 搜索分析 Api,因此这些号码可能对所有视频都不可用。This part of the script calls SharePoint search analytics APIs, so these numbers might not be available for all videos. 对您的 judgement 使用这些视图计数。Use these view counts with your judgement. 报表可能不会完全准确,也不能在运行时获取所有视频的所有视图。The report might not be fully accurate or able to get all the views of all videos at the time you run it.

  10. 将打开一个窗口,提示您登录到 Office 365 租户。A window will open up prompting you to login to your Office 365 tenant. 请确保使用 Office 365 全局管理员用户或 SharePoint Online 管理员登录。Make sure you sign in with a Office 365 global admin user or a SharePoint Online admin.

  11. 等待脚本完成运行。Wait for the script to finish running. 这可能需要一些时间,具体取决于 Office 365 视频中有多少通道和视频。This may take some time depending on how many channels and videos you have in Office 365 Video.

备注

脚本将继续运行,即使它在正在调用的一些 REST Api 的各个问题中运行。The script will keep running even if it runs into individual problems on some of the REST APIs it is calling. 如果在 PowerShell 控制台中看到错误,则报告最终将包含能够获取的数据量。If you see errors in the PowerShell console, the report will end up with as much data as it was able to get.

了解脚本输出Understanding the script output

脚本会自动将几个文本文件和 CSV 报告输出到运行该脚本的同一目录中的 "\output" 文件夹。The script will automatically output a few text file and CSV reports to "\output" folder within the same directory in which you ran the script.

Channels-Info.csv CSV 电子表格,其中列出了 Office 365 视频中的每个频道以及每个频道的详细信息,包括:Channels-Info.csv - CSV spreadsheet listing every channel in Office 365 Video and more information about each channel including:

  • 频道名称Channel name
  • 通道 URLChannel URL
  • 通道 GUIDChannel GUID
  • 包含电子邮件地址的渠道所有者/编辑者/查看者Channel owners/editors/viewers with email addresses
    • 用户的电子邮件地址和每个频道权限的已启用邮件的安全组Email addresses of users and mail enabled security groups for each channel permission
  • 没有电子邮件地址的频道所有者/编辑者/查看者Channel owners/editors/viewers without email addresses
    • 没有关联的电子邮件地址的每个频道权限的其他实体的名称The names of other entities for each channel permission that don't have associated email addresses
    • 这可能是特殊权限,如 "除外部用户之外的所有人",或者可能是未启用邮件的安全组This could be special permissions like "Everyone except external users" or it could be security groups that aren't mail enabled
  • 通道中的视频计数Count of videos in channel
  • (可选) 在不同时间段中最近24个月内的所有视频的视图总数(Optional) Sum of views on all videos within the channel for the last 24 months in different time range buckets
    • 过去3个月Last 3 months
    • 过去6个月Last 6 months
    • 最近12个月Last 12 months
    • 过去24个月Last 24 months

如果选择输出视频视图计数信息,脚本将需要更长时间才能运行。If you choose to output the video view counts information the script will take much longer to run. 脚本中的此选项将从每个视频的 SharePoint 搜索分析中获取视图计数分析,并按频道对其进行求和。This option in the script is getting the view count analytics from the SharePoint search analytics for each video and summing them up by channel.

Videos-File-List.txt 文本文件,其中列出了每个频道的 SharePoint Online url 和这些频道中的每个视频的 url。Videos-File-List.txt - Text file listing out the SharePoint Online URLs to each channel and the URLs to each video within those channels.

Log-Trace.txt 用于调试脚本的文本文件。Log-Trace.txt - Text file used to debug the script.

另请参阅See also

流迁移概述Stream migration overview

流迁移体验和有关迁移的详细信息Stream migration experience and details on migrating

Office 365 视频和 Microsoft Stream 功能比较Office 365 Video and Microsoft Stream feature comparison