Find Task Sequences that reference a application

Find-References.ps1

<#
  Find all task sequences where a application is referrenced. 
  $App name should match the admin console name
#>

$App = Get-CMApplication -Name 'AppName'
$TaskSeqIDs = (Invoke-CMWmiQuery -Query "select * from SMS_TaskSequenceAppReferencesInfo where RefAppModelName like '$($App.Modelname)'").PackageID
foreach ($TS in $TaskSeqIDs) {
    $TaskName = (Get-CMTaskSequence -Fast -TaskSequencePackageId $TS).Name
    Write-host ('App: {0} found in: {1}' -f $App.LocalizedDisplayName, $TaskName)
}