Get-ContentIDToAppName.ps1

function Get-ContentIDToAppName {
    param (
        $ContentID,
        $ContentRevision = 1,
        $SiteServer,
        $Namespace
    )
    $AllInfo = Get-WmiObject -ComputerName $SiteServer -Namespace $Namespace -Query "SELECT SMS_Application.LocalizedDisplayName,SMS_CIToContent.ModelName FROM SMS_CIToContent INNER JOIN SMS_Application ON SMS_CIToContent.SecuredModelName = SMS_Application.ModelName WHERE SMS_CIToContent.ContentUniqueID = '$ContentID' AND SMS_CIToContent.ContentVersion = '$ContentRevision'"
    New-Object -TypeName PSObject @{
        ApplicationName = $AllInfo.SMS_Application.LocalizedDisplayName
        DeploymentTypeID = $AllInfo.SMS_CIToContent.ModelName
    }
}