Script to find all packages that depend on a specific package

script.ps1

$package = 'Newtonsoft.Json'

$connection = "TODO..."

$done = @()
$todo = @($package.ToLowerInvariant())

while ($todo.Count -gt 0) {
    $next = $todo | Select-Object -First 50
    $nextIn = [string]::Join(',', @($next | % { "'$($_)'" }))

    $query = "SELECT DISTINCT(r.[Id])
        FROM [dbo].[PackageDependencies] d
        INNER JOIN [Packages] p ON p.[Key] = d.[PackageKey]
        INNER JOIN [PackageRegistrations] r ON r.[Key] = p.[PackageRegistrationKey]
        WHERE d.[Id] IN ($($nextIn))"

    $results = Invoke-Sqlcmd -Query $query -ConnectionString $connection

    $results | % {
        $id = $_.Id.ToLowerInvariant()
        if ($todo -notcontains $id -and $done -notcontains $id) {
            Write-Host "Found new dependent package: $($id)"

            $todo += @($id)
        }
    }

    $todo  = @($todo | ? { $next -notcontains $_ })
    $done += @($next)
}