Sitecore powershell - Get the count of media folders and media items for each of the medial folders inside media library

Question

I need to get the count of all the media items and folders inside any media folder in media library. Then export the data to csv I am planning to write a script using SPE. Please help me on the same

For Example

• A(Media Folder)
  • A1 (Media Item)
  • A2 (Media Item)
  • A3 (Media folder)
    • A31 (Media Item)
    • A32 (Media Item)
• B(Media Folder)
  • B1 (Media Item)
  • B2 (Media folder)
    • B21 (Media Item)
    • B22 (Media Item)
  • B3 (Media folder)
    • B31 (Media Item)
    • B32 (Media Item)

I need to get final result as

Please help me on the same

Answer 1

I prepared the powershell script for you. Try it:

$mediaLibriary = Get-Item "/sitecore/media library"
$mediafoldersTemplates = "Media folder", "Node"

$root = $mediaLibriary.Children
$table = @()

foreach($rItem in $root){
    if($mediafoldersTemplates -contains $rItem.TemplateName){
        $table += ProcessChildren -item $rItem
    }
}

$table  | Format-Table -AutoSize

function ProcessChildren($item)
{
    $contOfFolders = 0
    $contOfImages = 0

    $children = $item.Children

    $result = @()
    $tempTable = @()
    foreach($chItem in $children){
        if($mediafoldersTemplates -contains $chItem.TemplateName)
        {
            $contOfFolders++
            $tempTable += ProcessChildren -item $chItem
        }else{
            $contOfImages++
        }
    }


    $objAverage = New-Object System.Object
    $objAverage | Add-Member -type NoteProperty -Name Name -Value $item.Name
    $objAverage | Add-Member -type NoteProperty -Name FolderCount -Value $contOfFolders
    $objAverage | Add-Member -type NoteProperty -Name ItemCount -Value $contOfImages

    $result += $objAverage
    $result += $tempTable

    return $result
}

You can upgrade the mediafoldersTemplates variable in the script with a template names that you consider are folder's templates.