OneDrive Microsoft Teams recordings

Question

OneDrive Microsoft Teams recordings

MKHULEKO THABISO NHLAMBO 40

May you please assist me with a PowerShell script that i can use to generate a report on OneDrive to get Microsoft Teams recordings older than 1 year.
May you please assist me with a PowerShell script that i can use to generate a report on exchange mailbox to get emails older than 1 year.

JimmyYang-MSFT 57,591 Microsoft External Staff

Please note that Teams tag is mainly focused on the general issue of Microsoft Teams troubleshooting. Since your question 1 is related to Teams development, the following suggestion is just for your refrence. Thanks for your understanding and patience!

Below is the sample script. Adjust the file extension filter, date field, or any other property as required for your environment:

#Begin Script

#Define the threshold date (files older than one year)

$thresholdDate = (Get-Date).AddYears(-1)

Connect to the SharePoint Online admin center.

Replace <tenant> with your actual tenant name (e.g., contoso)

$adminUrl = "https://<tenant>-admin.sharepoint.com"

Write-Output "Connecting to SharePoint Online Admin center..."

Connect-SPOService -Url $adminUrl

#Get all OneDrive sites (user personal sites use the SPSPERS template)

Write-Output "Retrieving all OneDrive sites..."

$oneDriveSites = Get-SPOSite -Template "SPSPERS" -Limit All

#Array to store report data

$report = @()

#Iterate through each OneDrive site

foreach ($site in $oneDriveSites) {

Write-Output "Processing OneDrive site: $($site.Url)"



try {

    #Connect to this OneDrive site using PnP.PowerShell; interactive login is used here.

    Connect-PnPOnline -Url $site.Url -Interactive


    

    #Get files from the default "Documents" library.

    #Depending on your environment and where Teams recordings are stored,

    #you might need to adjust the library name or use a search query.



    #Here we grab all files (using a simple CAML query to limit to files modified before the threshold)

    #and then filter later for .mp4 file extension.

    $camlQuery = @"
<View>

<Query>

<Where>

    <Lt>

        <FieldRef Name='Modified' />

        <Value IncludeTimeValue='TRUE' Type='DateTime'>$(($thresholdDate).ToUniversalTime().ToString("yyyy-MM-ddTHH:mm:ssZ"))</Value>

    </Lt>

</Where>
```</Query>
```</View>

"@

$listItems = Get-PnPListItem -List "Documents" -Query $camlQuery -PageSize 500




#Process each item – filtering for files that appear to be Teams recordings

foreach ($item in $listItems) {

    #Get file details from the list item

    $fileName = $item["FileLeafRef"]

    $fileModified = $item["Modified"]

    $fileUrl = $item["FileRef"]

    #If Teams recordings are stored as .mp4 files, then filter by extension.

    #(If your organization uses a different file format or naming convention, modify this condition accordingly.)

    if ($fileName -and $fileName.ToLower().EndsWith(".mp4")) {

        #Double-check that the file modified date is older than our threshold

        if ([datetime]$fileModified -lt $thresholdDate) {

            #Create a custom object with the info you need

            $reportItem = [PSCustomObject]@{

                OneDriveURL = $site.Url

                FileName    = $fileName

                Modified    = $fileModified

                FileURL     = $fileUrl

            }

            $report += $reportItem

        }

    }

}
} catch {

yaml
Write-Warning "Error processing site $($site.Url): $_"
}
}

#Export the report to a CSV file

$csvPath = ".\TeamsRecordingsOlderThan1Year.csv"

Write-Output "Exporting report to $csvPath"

$report | Export-Csv -Path $csvPath -NoTypeInformation

Write-Output "Report generation complete."

#End Script

JimmyYang-MSFT 57,591 Reputation points Microsoft External Staff

2025-02-11T09:50:03.08+00:00

@MKHULEKO THABISO NHLAMBO

It has been a while, how is everything going?

If you have any update about this issue, please feel free to post back.

1 answer

Your answer

JimmyYang-MSFT 57,591 Reputation points Microsoft External Staff

2025-02-11T09:50:03.08+00:00

@MKHULEKO THABISO NHLAMBO

It has been a while, how is everything going?

If you have any update about this issue, please feel free to post back.

Answer 1

Bruce Jing-MSFT 10,310 Microsoft External Staff

Hi，@

For the second question you can refer to the following script:

# 1. Deadline for calculationv
$cutoffDate = (Get-Date).AddYears(-1).ToString("yyyy-MM-dd")
$searchQuery = "received<='$cutoffDate'"
$mailbox = "user@example.com"
# 2. Create a new compliance search task
New-ComplianceSearch -Name "OldEmailsSearch" -ExchangeLocation $mailbox -ContentMatchQuery $searchQuery
# 3. Start the search task
Start-ComplianceSearch -Identity “OldEmailsSearch”
# 4. Export results
New-ComplianceSearchAction -SearchName "OldEmailsSearch" -Export -Format FxStream

Share via

OneDrive Microsoft Teams recordings

1 answer

Your answer