Forum Discussion

Dorje-McKinnon's avatar
Dorje-McKinnon
Steel Contributor
Oct 07, 2020

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

     

     
     

     

     

     

abrarali's avatar
abrarali
Copper Contributor
Feb 23, 2021

Dorje-McKinnonThanks for your efforts to build the script and make our lives easier. However, when I rum the URL (After changing the values) I'm getting a blank excel file.

Can someone help me out here?

Jonathan_Ogden's avatar
Jonathan_Ogden
Copper Contributor
Feb 23, 2021

abrarali 

Here is the URL I use for Western US. different regions have different datacenters, so you need to update the first part of the URL, the uswe-1

 

https://uswe-1.api.microsoftstream.com/api/videos?NoSignUpCheck=1&$top=100&$orderby=publishedDate%20desc&$expand=creator,events&$filter=published%20and%20(state%20eq%20%27Completed%27%20or%20contentSource%20eq%20%27livestream%27)&adminmode=true&api-version=1.4-private&$skip=0

 

Sorry for the mess, I just wanted to remove any ID's and user info.

Here is the output from the browser.

I had to copy and paste this into a txt file, then change the .txt to .json

 

 

    • WhatTheFork's avatar
      WhatTheFork
      Copper Contributor
      Apr 06, 2021
      I tried running the script but is not providing me any list. It's just creating a blank cache csv file.
      • Dorje-McKinnon's avatar
        Dorje-McKinnon
        Steel Contributor
        Aug 05, 2021

        Hi WhatTheFork 

        My guess is that you didn't manually save the JSON files into the folder defined in the script.

        This new code will make it a bit easier (JSON files auto open in their own browser tabs), BUT you still have to save each one as a JSON file into the folder you define in the script. Then your CSV won't be blank.

Resources