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

     

     
     

     

     

     

Twan van Beers's avatar
Twan van Beers
Copper Contributor
Feb 02, 2022

Dorje-McKinnon Thanks for this script.  My colleague Conrad has been using it a number of times.  He asked me to improve this idea to avoid the copy/paste pieces.  So I spent half a day and came up with https://neroblanco.co.uk/2022/02/get-list-of-videos-from-microsoft-stream/   It basically does the same thing as what you're doing but uses a scraping technique to get the date center and access token, so then it can loop through the videos without interaction!

 

Thanks again!

ScoutmanPt's avatar
ScoutmanPt
Copper Contributor
Feb 02, 2022
Hi Twan, thanks for mentioning @Dorje and me on your blog entry . Just a quick correction: "MS must have removed the JSON object from their pages" that's not actually true or else the script would never work. The problem is that the page cycle order changed in the old stream portal, there's no validation on the session info which was why the script failed in some of the tenants. Im updating https://bit.ly/PnPScriptSamplesMSStream sample on the pnp repo, but I was wondering if you would like to do it, instead of me 😛 ? PnP Script Samples (https://pnp.github.io/script-samples/) is a community drive open source project and we are always keen to have more contributions.
  • Twan van Beers's avatar
    Twan van Beers
    Copper Contributor
    Feb 02, 2022
    Hi ScoutmanPt

    The error in the console was object JSON is undefined, and when I try to execute console commands in the debugger that object JSON definitely doesn't exist at all.

    I'm ok to update it, just didn't want to replace someone else's work 🙂
    • ScoutmanPt's avatar
      ScoutmanPt
      Copper Contributor
      Feb 02, 2022
      Twan van Beers, "sharing is caring" is the key , right now the world owns the code ! 😛 . Rang me if you need any help on don't it ... Have a couple of other scripts coming in and if you wanna test drive them before they come public , that could be awesome. Thanks again for reaching out.
      • Twan van Beers's avatar
        Twan van Beers
        Copper Contributor
        Feb 02, 2022
        Ok I've requested an update to that page now. Yes we're happy to help look at scripts, etc. We do like to blog and share the knowledge although we fell off the wagon early last year when we got ultra busy with clients and have struggled to get back to it! 🙂

Resources