Forum Discussion

Dorje-McKinnon's avatar
Dorje-McKinnon
Iron Contributor
Oct 07, 2020
Solved

Powershell Script to list ALL videos in your 365 Stream environment

I hope this is useful to everyone.  My goal was to get a list of all videos in my stream so that I could contact each video creator about the changes that are coming to stream. Also so I could figur...
audit
csv
Office 365 APIs
powershell
Stream
Videos
  • Marc Mroz's avatar
    Marc Mroz
    Oct 22, 2022

    Anyone looking at this script should also look at the PowerShell script that was released by Microsoft as part of the Stream (Classic) migration tools. The PowerShell script released by Microsoft can be downloaded directly from Stream (Classic) admin page and also has a PowerBI Desktop template that can be used to analyze the output CSVs.

     

    See this part of the migration help articles for more info: 

    https://learn.microsoft.com/stream/streamnew/migration-details#stream-classic-video-report

     

     
     

     

     

     

scottcampany's avatar
scottcampany
Copper Contributor
Aug 04, 2021
Thank you very much Dorje for sharing this script with the community!! What a wonderful tool.

Has anyone had success with pulling the lastViewDate? All of my videos show "null" in the raw JSON data. This value would be very valuable for helping to determine when a video was last viewed.

Scott
Dorje-McKinnon's avatar
Dorje-McKinnon
Iron Contributor
Aug 05, 2021

Hi scottcampany 

Stream doesn't seem to hold this data. The json that comes back contains some information userData.lastViewDate  BUT this is for the currently viewing user . In the case of this code it would be the last time this user viewed this video.

 

As far as I know this information isn't held anywhere other than perhaps in your network log files on a router somewhere.

 

But once the videos have moved to SharePoint / OneDrive then the GraphAPI does have information about Viewers and Views for each file.

Resources