#####################################################
# Check-AppsNotEnabledForTaskSequenceInstall
# Script Author(s): Sean Huggans
$ScriptVersion = "23.2.6.1"
#####################################################
# Variables
##############################################
$global:SiteServer = "SITESERVER"
$global:SiteCode = "FOO"
$LogFile = "Check-AppsEnabledForTaskSequenceInstall.log"
$LogDir = "c:\Temp"
$LogPath = "$($LogDir)\$($LogFile)"
 
#####################################################
# Functions
##############################################
 
function Log-Action ($Message, $StampDateTime, $WriteHost)
{
    ################################
    # Function Version 19.5.11.4
    # Function by Sean Huggans
    ################################
	New-Item -ItemType directory -Path $LogDir -Confirm:$false -Force | out-null
    if (($StampDateTime -eq $false) -or ($StampDateTime -eq "no")) {
        $Message | Out-File $LogPath -Append
    } else {
	    "[ $(get-date -Format 'yyyy.MM.dd HH:mm:ss') ] $($Message)" | Out-File $LogPath -Append
    }
    if ($WriteHost -eq $true) {
        Write-Host $Message
    }
}
 
function Invoke-SQL
{
	param (
		[string]$dataSource = "$global:SiteServer",
		[string]$database = "CM_$global:SiteCode",
		[string]$sqlCommand = $(throw "Please specify a query.")
	)
 
	$connectionString = "Data Source=$dataSource; " +
	"Integrated Security=SSPI; " +
	"Initial Catalog=$database"
 
	$connection = new-object system.data.SqlClient.SQLConnection($connectionString)
	$command = new-object system.data.sqlclient.sqlcommand($sqlCommand, $connection)
	$connection.Open()
 
	$adapter = New-Object System.Data.sqlclient.sqlDataAdapter $command
	$dataset = New-Object System.Data.DataSet
	$adapter.Fill($dataSet) | Out-Null
 
	$connection.Close()
	$dataSet.Tables	
}
 
#####################################################
# Execution Logic
##############################################
Log-Action -message "-------- Beginning Check for Application Packages not enabled for task sequence installation..." -WriteHost $true
# Get application package digests
$AllAppPackages = Invoke-SQL -sqlCommand "select LatestApp.DisplayName, LatestApp.SDMPackageDigest from fn_ListLatestApplicationCIs(1033) LatestApp"
foreach ($AppPackage in $AllAppPackages) {
    # Check each app package for AutoInstall being true
    if ($AppPackage.SDMPackageDigest -like "*<AutoInstall>true</AutoInstall>*") {
        Log-Action -message " - Application ""$($AppPackage.DisplayName)"" was already enabled for task sequence installations, skipping." -WriteHost $true
    } else {
        Try {
            $AppPackage2 = Get-CMApplication -Name $AppPackage.DisplayName
            Set-CMApplication -Id $AppPackage2.CI_ID -AutoInstall $true
            Log-Action -message " - WARNING!  Application ""$($AppPackage.DisplayName)"" was not enabled for task sequence install without deployment, this was successfully corrected." -WriteHost $true
        } catch {
            Log-Action -message " - ERROR!  Application ""$($AppPackage.DisplayName)"" is not enabled for task sequence install without deployment, and there was an error attempting to correct it automatically." -WriteHost $true
        }
    }
}
Log-Action -message "Finished Check for Application Packages not enabled for task sequence installation." -WriteHost $true