DarkAllien/sql_cu_install.ps1

## sql_cu_install.ps1
<#
.SYNOPSIS
	This script performs the installation or uninstallation of an application(s).
.DESCRIPTION
	The script is provided as a template to perform an install or uninstall of an application(s).
	The script either performs an "Install" deployment type or an "Uninstall" deployment type.
	The install deployment type is broken down into 3 main sections/phases: Pre-Install, Install, and Post-Install.
	The script dot-sources the AppDeployToolkitMain.ps1 script which contains the logic and functions required to install or uninstall an application.
.PARAMETER DeploymentType
	The type of deployment to perform. Default is: Install.
.PARAMETER DeployMode
	Specifies whether the installation should be run in Interactive, Silent, or NonInteractive mode. Default is: Interactive. Options: Interactive = Shows dialogs, Silent = No dialogs, NonInteractive = Very silent, i.e. no blocking apps. NonInteractive mode is automatically set if it is detected that the process is not user interactive.
.PARAMETER AllowRebootPassThru
	Allows the 3010 return code (requires restart) to be passed back to the parent process (e.g. SCCM) if detected from an installation. If 3010 is passed back to SCCM, a reboot prompt will be triggered.
.PARAMETER TerminalServerMode
	Changes to "user install mode" and back to "user execute mode" for installing/uninstalling applications for Remote Destkop Session Hosts/Citrix servers.
.PARAMETER DisableLogging
	Disables logging to file for the script. Default is: $false.
.EXAMPLE
    powershell.exe -Command "& { & '.\Deploy-Application.ps1' -DeployMode 'Silent'; Exit $LastExitCode }"
.EXAMPLE
    powershell.exe -Command "& { & '.\Deploy-Application.ps1' -AllowRebootPassThru; Exit $LastExitCode }"
.EXAMPLE
    powershell.exe -Command "& { & '.\Deploy-Application.ps1' -DeploymentType 'Uninstall'; Exit $LastExitCode }"
.EXAMPLE
    Deploy-Application.exe -DeploymentType "Install" -DeployMode "Silent"
.NOTES
	Toolkit Exit Code Ranges:
	60000 - 68999: Reserved for built-in exit codes in Deploy-Application.ps1, Deploy-Application.exe, and AppDeployToolkitMain.ps1
	69000 - 69999: Recommended for user customized exit codes in Deploy-Application.ps1
	70000 - 79999: Recommended for user customized exit codes in AppDeployToolkitExtensions.ps1
.LINK
	http://psappdeploytoolkit.com
#>
[CmdletBinding()]
Param (
	[Parameter(Mandatory=$false)]
	[ValidateSet('Install','Uninstall')]
	[string]$DeploymentType = 'Install',
	[Parameter(Mandatory=$false)]
	[ValidateSet('Interactive','Silent','NonInteractive')]
	[string]$DeployMode = 'Interactive',
	[Parameter(Mandatory=$false)]
	[switch]$AllowRebootPassThru = $false,
	[Parameter(Mandatory=$false)]
	[switch]$TerminalServerMode = $false,
	[Parameter(Mandatory=$false)]
	[switch]$DisableLogging = $false
)

Try {
	## Set the script execution policy for this process
	Try { Set-ExecutionPolicy -ExecutionPolicy 'ByPass' -Scope 'Process' -Force -ErrorAction 'Stop' } Catch {}

	##*===============================================
	##* VARIABLE DECLARATION
	##*===============================================
	## Variables: Application

	[string]$appVendor = 'Microsoft'
	[string]$appName = 'SQL'
	[string]$appVersion = '2012 (KB4057116)'
	[string]$appArch = 'x64'
	[string]$appLang = 'EN'
	[string]$appRevision = '01'
	[string]$appScriptVersion = '1.1.0'
	[string]$appScriptDate = '10/01/2018'
	[string]$appScriptAuthor = 'octavian.cordos'

	$SQLSetupEXE = "SQLServer2012-KB4057116-x64.exe"
	$InstallArgs = "/Q /IAcceptSQLServerLicenseTerms /Action=Patch /allinstances"
	$UninstallArgs = "/quiet /IAcceptSQLServerLicenseTerms /Action=RemovePatch /allinstances"
	#Required free disk space on drive C
	[double]$FreeDiskSpaceRequired = 2000

	##*===============================================
	## Variables: Install Titles (Only set here to override defaults set by the toolkit)
	[string]$installName = ''
	[string]$installTitle = ''

	##* Do not modify section below
	#region DoNotModify

	## Variables: Exit Code
	[int32]$mainExitCode = 0

	## Variables: Script
	[string]$deployAppScriptFriendlyName = 'Deploy Application'
	[version]$deployAppScriptVersion = [version]'3.6.8'
	[string]$deployAppScriptDate = '02/06/2016'
	[hashtable]$deployAppScriptParameters = $psBoundParameters

	## Variables: Environment
	If (Test-Path -LiteralPath 'variable:HostInvocation') { $InvocationInfo = $HostInvocation } Else { $InvocationInfo = $MyInvocation }
	[string]$scriptDirectory = Split-Path -Path $InvocationInfo.MyCommand.Definition -Parent

	## Dot source the required App Deploy Toolkit Functions
	Try {
		[string]$moduleAppDeployToolkitMain = "$scriptDirectory\AppDeployToolkit\AppDeployToolkitMain.ps1"
		If (-not (Test-Path -LiteralPath $moduleAppDeployToolkitMain -PathType 'Leaf')) { Throw "Module does not exist at the specified location [$moduleAppDeployToolkitMain]." }
		If ($DisableLogging) { . $moduleAppDeployToolkitMain -DisableLogging } Else { . $moduleAppDeployToolkitMain }
	}
	Catch {
		If ($mainExitCode -eq 0){ [int32]$mainExitCode = 60008 }
		Write-Error -Message "Module [$moduleAppDeployToolkitMain] failed to load: `n$($_.Exception.Message)`n `n$($_.InvocationInfo.PositionMessage)" -ErrorAction 'Continue'
		## Exit the script, returning the exit code to SCCM
		If (Test-Path -LiteralPath 'variable:HostInvocation') { $script:ExitCode = $mainExitCode; Exit } Else { Exit $mainExitCode }
	}

	#endregion
	##* Do not modify section above
	##*===============================================
	##* END VARIABLE DECLARATION
	##*===============================================


	If ($deploymentType -ine 'Uninstall') {
		##*===============================================
		##* PRE-INSTALLATION
		##*===============================================

		[string]$installPhase = 'Pre-Installation'

		#Check free disk space on drive C:

		[double]$FreeDiskSpaceAvailable = Get-FreeDiskSpace -Drive 'C:'

		if ($FreeDiskSpaceAvailable -lt $FreeDiskSpaceRequired) {
			Write-Log "$FreeDiskSpaceAvailable MB is less than specified minimum ($FreeDiskSpaceRequired MB) of free disk space on drive C:"
			Write-Log "Exiting..."
			Exit-Script -ExitCode 69000
		}
		Else {
			Write-Log "$FreeDiskSpaceAvailable MB is more than specified minimum ($FreeDiskSpaceRequired MB) of free disk space on drive C:"
		}

		##*===============================================
		##* INSTALLATION
		##*===============================================
		[string]$installPhase = 'Installation'

		## <Perform Installation tasks here>

		# Install SQL Server Service Pack

    # Add regkey to Control Restart (0 initial, 1 needs restart)
    Push-Location
    Set-Location HKLM:
    $registryPath = "SYSTEM\SCCM"

    $Group = "SQL_Restart"
    $Group_value = "0"
    New-Item -Path $registryPath
    New-ItemProperty -Path $registryPath -Name $Group -Value $Group_value -PropertyType String –Force
    Pop-Location

    Get-Service -name SQLSERVERAGENT | Stop-Service

    #Execute SQL KB Install
    		Write-Log "Start: SQL KB installation program MAIN"
		Try {
        	Write-Log "starting $SQLSetupEXE with parameters $InstallArgs"
        	Execute-Process -Path $SQLSetupEXE -Parameters $InstallArgs -PassThru -WindowStyle Hidden -CreateNoWindow
    	}
    	Catch {
           Write-Log "Installation of $SQLSetupEXE has failed. Error message: $_.Exception.Message" -Severity 3
           Write-Log "End: SQL KB installation program MAIN"
           Exit-Script -ExitCode 69004
    	}
		Write-Log "End: SQL KB installation program MAIN"

    # Add regkey to Control Restart (0 initial, 1 needs restart)
    Push-Location
    Set-Location HKLM:
    $Group_value = "1"
    New-Item -Path $registryPath
    New-ItemProperty -Path $registryPath -Name $Group -Value $Group_value -PropertyType String –Force
    Pop-Location

		## Handle Zero-Config MSI Installations
		If ($useDefaultMsi) {
			[hashtable]$ExecuteDefaultMSISplat =  @{ Action = 'Install'; Path = $defaultMsiFile }; If ($defaultMstFile) { $ExecuteDefaultMSISplat.Add('Transform', $defaultMstFile) }
			Execute-MSI @ExecuteDefaultMSISplat; If ($defaultMspFiles) { $defaultMspFiles | ForEach-Object { Execute-MSI -Action 'Patch' -Path $_ } }
		}


		##*===============================================
		##* POST-INSTALLATION
		##*===============================================
		[string]$installPhase = 'Post-Installation'

		## <Perform Post-Installation tasks here>
		Write-Log "Performing post-installation tasks"

Function Reboot_Pending {
    <#
    .SYNOPSIS
        The function is checking if there is a reboot pending.
    .DESCRIPTION
        The function is checking if there is a reboot pending.
    #>
    $Reboot = $false
    $SCCMUpdate = get-wmiobject -query "SELECT * FROM CCM_SoftwareUpdate" -namespace "ROOT\ccm\ClientSDK"
    $Reboot = $Reboot -or ([wmiclass]'ROOT\ccm\ClientSDK:CCM_ClientUtilities').DetermineIfRebootPending().RebootPending
    $Reboot = $Reboot -or ([wmiclass]'ROOT\ccm\ClientSDK:CCM_ClientUtilities').DetermineIfRebootPending().IsHardRebootPending
    if(@(((Get-ItemProperty("HKLM:\SYSTEM\CurrentControlSet\Control\Session Manager")).$("PendingFileRenameOperations")) | where { $_ }).length -ne 0) {$Reboot=$true}
    if(@($SCCMUpdate | where { $_.EvaluationState -eq 8 -or $_.EvaluationState -eq 9 -or $_.EvaluationState -eq 10  }).length -ne 0) {$Reboot=$true}
    return $Reboot
}
		If (Reboot_Pending) {
            Write-Log "System reboot is pending"
            Exit-Script -ExitCode 3010
            #Restart-Computer
            #Invoke-WmiMethod -Namespace root\ccm\clientsdk -Class CCM_ClientUtilities -Name RestartComputer
        }
		Else {
        	Write-Log "Starting SQL Agent Service"
			Try {
				Start-Service -name SQLSERVERAGENT -Erroraction Stop
				Write-Log "SQL Agent Service has been started"
			}
			Catch {
				Write-Log "SQL Agent service could not be started. Exiting..." -Severity 3
				Exit-Script -ExitCode 69005
			}
        }

		## Display a message at the end of the install
		#If (-not $useDefaultMsi) { Show-InstallationPrompt -Message 'You can customize text to appear at the end of an install or remove it completely for unattended installations.' -ButtonRightText 'OK' -Icon Information -NoWait }
	}
	ElseIf ($deploymentType -ieq 'Uninstall')
	{
		##*===============================================
		##* PRE-UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Pre-Uninstallation'

		## Show Welcome Message, close Internet Explorer with a 60 second countdown before automatically closing
		#Show-InstallationWelcome -CloseApps 'iexplore' -CloseAppsCountdown 60

		## Show Progress Message (with the default message)
		#Show-InstallationProgress

		## <Perform Pre-Uninstallation tasks here>

		Write-Log "Stoping SQL Agent Service"
		Try {
			Stop-Service -name SQLSERVERAGENT -Erroraction Stop
			Write-Log "SQL Agent Service has been stopped"
		}
		Catch {
			Write-Log "SQL Agent service could not be stopped. Exiting..." -Severity 3
			Exit-Script -ExitCode 69001
		}

		##*===============================================
		##* UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Uninstallation'

		## Handle Zero-Config MSI Uninstallations
		If ($useDefaultMsi) {
			[hashtable]$ExecuteDefaultMSISplat =  @{ Action = 'Uninstall'; Path = $defaultMsiFile }; If ($defaultMstFile) { $ExecuteDefaultMSISplat.Add('Transform', $defaultMstFile) }
			Execute-MSI @ExecuteDefaultMSISplat
		}

		# <Perform Uninstallation tasks here>

		# Uninstall SQL Server Service Pack
		Write-Log "Start: SQL SERVICE PACK removal program MAIN"

		#Execute SQL SP removal
		Try {
        	Write-Log "starting $SQLSetupEXE with parameters $UninstallArgs"
        	Execute-Process -Path $SQLSetupEXE -Parameters $UninstallArgs -PassThru -WindowStyle Hidden
    	}
    	Catch {
           Write-Log "Removal of $SQLSetupEXE has failed. Error message: $_.Exception.Message" -Severity 3
           Write-Log "End: SQL SERVICE PACK inatallation program MAIN"
           Exit-Script -ExitCode 69006
    	}
		Write-Log "End: SQL SERVICE PACK removal program MAIN"

		##*===============================================
		##* POST-UNINSTALLATION
		##*===============================================
		[string]$installPhase = 'Post-Uninstallation'

		## <Perform Post-Uninstallation tasks here>

		Write-Log "Performing post-uninstallation tasks"

		If ((Get-PendingReboot).IsSystemRebootPending) {
            Write-Log "System reboot is pending"
            Exit-Script -ExitCode 3010
            #Restart-Computer
        }
		Else {
        	Write-Log "Starting SQL Agent Service"
			Try {
				Start-Service -name SQLSERVERAGENT -Erroraction Stop
				Write-Log "SQL Agent Service has been started"
			}
			Catch {
				Write-Log "SQL Agent service could not be started. Exiting..." -Severity 3
				Exit-Script -ExitCode 69005
			}
         }

	}

	##*===============================================
	##* END SCRIPT BODY
	##*===============================================

	## Call the Exit-Script function to perform final cleanup operations
	Exit-Script -ExitCode $mainExitCode
}
Catch {
	[int32]$mainExitCode = 60001
	[string]$mainErrorMessage = "$(Resolve-Error)"
	Write-Log -Message $mainErrorMessage -Severity 3 -Source $deployAppScriptFriendlyName
	Show-DialogBox -Text $mainErrorMessage -Icon 'Stop'
	Exit-Script -ExitCode $mainExitCode
}
	<#
	.SYNOPSIS
	This script performs the installation or uninstallation of an application(s).
	.DESCRIPTION
	The script is provided as a template to perform an install or uninstall of an application(s).
	The script either performs an "Install" deployment type or an "Uninstall" deployment type.
	The install deployment type is broken down into 3 main sections/phases: Pre-Install, Install, and Post-Install.
	The script dot-sources the AppDeployToolkitMain.ps1 script which contains the logic and functions required to install or uninstall an application.
	.PARAMETER DeploymentType
	The type of deployment to perform. Default is: Install.
	.PARAMETER DeployMode
	Specifies whether the installation should be run in Interactive, Silent, or NonInteractive mode. Default is: Interactive. Options: Interactive = Shows dialogs, Silent = No dialogs, NonInteractive = Very silent, i.e. no blocking apps. NonInteractive mode is automatically set if it is detected that the process is not user interactive.
	.PARAMETER AllowRebootPassThru
	Allows the 3010 return code (requires restart) to be passed back to the parent process (e.g. SCCM) if detected from an installation. If 3010 is passed back to SCCM, a reboot prompt will be triggered.
	.PARAMETER TerminalServerMode
	Changes to "user install mode" and back to "user execute mode" for installing/uninstalling applications for Remote Destkop Session Hosts/Citrix servers.
	.PARAMETER DisableLogging
	Disables logging to file for the script. Default is: $false.
	.EXAMPLE
	powershell.exe -Command "& { & '.\Deploy-Application.ps1' -DeployMode 'Silent'; Exit $LastExitCode }"
	.EXAMPLE
	powershell.exe -Command "& { & '.\Deploy-Application.ps1' -AllowRebootPassThru; Exit $LastExitCode }"
	.EXAMPLE
	powershell.exe -Command "& { & '.\Deploy-Application.ps1' -DeploymentType 'Uninstall'; Exit $LastExitCode }"
	.EXAMPLE
	Deploy-Application.exe -DeploymentType "Install" -DeployMode "Silent"
	.NOTES
	Toolkit Exit Code Ranges:
	60000 - 68999: Reserved for built-in exit codes in Deploy-Application.ps1, Deploy-Application.exe, and AppDeployToolkitMain.ps1
	69000 - 69999: Recommended for user customized exit codes in Deploy-Application.ps1
	70000 - 79999: Recommended for user customized exit codes in AppDeployToolkitExtensions.ps1
	.LINK
	http://psappdeploytoolkit.com
	#>
	[CmdletBinding()]
	Param (
	[Parameter(Mandatory=$false)]
	[ValidateSet('Install','Uninstall')]
	[string]$DeploymentType = 'Install',
	[Parameter(Mandatory=$false)]
	[ValidateSet('Interactive','Silent','NonInteractive')]
	[string]$DeployMode = 'Interactive',
	[Parameter(Mandatory=$false)]
	[switch]$AllowRebootPassThru = $false,
	[Parameter(Mandatory=$false)]
	[switch]$TerminalServerMode = $false,
	[Parameter(Mandatory=$false)]
	[switch]$DisableLogging = $false
	)

	Try {
	## Set the script execution policy for this process
	Try { Set-ExecutionPolicy -ExecutionPolicy 'ByPass' -Scope 'Process' -Force -ErrorAction 'Stop' } Catch {}

	##*===============================================
	##* VARIABLE DECLARATION
	##*===============================================
	## Variables: Application

	[string]$appVendor = 'Microsoft'
	[string]$appName = 'SQL'
	[string]$appVersion = '2012 (KB4057116)'
	[string]$appArch = 'x64'
	[string]$appLang = 'EN'
	[string]$appRevision = '01'
	[string]$appScriptVersion = '1.1.0'
	[string]$appScriptDate = '10/01/2018'
	[string]$appScriptAuthor = 'octavian.cordos'

	$SQLSetupEXE = "SQLServer2012-KB4057116-x64.exe"
	$InstallArgs = "/Q /IAcceptSQLServerLicenseTerms /Action=Patch /allinstances"
	$UninstallArgs = "/quiet /IAcceptSQLServerLicenseTerms /Action=RemovePatch /allinstances"
	#Required free disk space on drive C
	[double]$FreeDiskSpaceRequired = 2000

	##*===============================================
	## Variables: Install Titles (Only set here to override defaults set by the toolkit)
	[string]$installName = ''
	[string]$installTitle = ''

	##* Do not modify section below
	#region DoNotModify

	## Variables: Exit Code
	[int32]$mainExitCode = 0

	## Variables: Script
	[string]$deployAppScriptFriendlyName = 'Deploy Application'
	[version]$deployAppScriptVersion = [version]'3.6.8'
	[string]$deployAppScriptDate = '02/06/2016'
	[hashtable]$deployAppScriptParameters = $psBoundParameters

	## Variables: Environment
	If (Test-Path -LiteralPath 'variable:HostInvocation') { $InvocationInfo = $HostInvocation } Else { $InvocationInfo = $MyInvocation }
	[string]$scriptDirectory = Split-Path -Path $InvocationInfo.MyCommand.Definition -Parent

	## Dot source the required App Deploy Toolkit Functions
	Try {
	[string]$moduleAppDeployToolkitMain = "$scriptDirectory\AppDeployToolkit\AppDeployToolkitMain.ps1"
	If (-not (Test-Path -LiteralPath $moduleAppDeployToolkitMain -PathType 'Leaf')) { Throw "Module does not exist at the specified location [$moduleAppDeployToolkitMain]." }
	If ($DisableLogging) { . $moduleAppDeployToolkitMain -DisableLogging } Else { . $moduleAppDeployToolkitMain }
	}
	Catch {
	If ($mainExitCode -eq 0){ [int32]$mainExitCode = 60008 }
	Write-Error -Message "Module [$moduleAppDeployToolkitMain] failed to load: `n$($_.Exception.Message)`n `n$($_.InvocationInfo.PositionMessage)" -ErrorAction 'Continue'
	## Exit the script, returning the exit code to SCCM
	If (Test-Path -LiteralPath 'variable:HostInvocation') { $script:ExitCode = $mainExitCode; Exit } Else { Exit $mainExitCode }
	}

	#endregion
	##* Do not modify section above
	##*===============================================
	##* END VARIABLE DECLARATION
	##*===============================================


	If ($deploymentType -ine 'Uninstall') {
	##*===============================================
	##* PRE-INSTALLATION
	##*===============================================

	[string]$installPhase = 'Pre-Installation'

	#Check free disk space on drive C:

	[double]$FreeDiskSpaceAvailable = Get-FreeDiskSpace -Drive 'C:'

	if ($FreeDiskSpaceAvailable -lt $FreeDiskSpaceRequired) {
	Write-Log "$FreeDiskSpaceAvailable MB is less than specified minimum ($FreeDiskSpaceRequired MB) of free disk space on drive C:"
	Write-Log "Exiting..."
	Exit-Script -ExitCode 69000
	}
	Else {
	Write-Log "$FreeDiskSpaceAvailable MB is more than specified minimum ($FreeDiskSpaceRequired MB) of free disk space on drive C:"
	}

	##*===============================================
	##* INSTALLATION
	##*===============================================
	[string]$installPhase = 'Installation'

	## <Perform Installation tasks here>

	# Install SQL Server Service Pack

	# Add regkey to Control Restart (0 initial, 1 needs restart)
	Push-Location
	Set-Location HKLM:
	$registryPath = "SYSTEM\SCCM"

	$Group = "SQL_Restart"
	$Group_value = "0"
	New-Item -Path $registryPath
	New-ItemProperty -Path $registryPath -Name $Group -Value $Group_value -PropertyType String –Force
	Pop-Location

	Get-Service -name SQLSERVERAGENT \| Stop-Service

	#Execute SQL KB Install
	Write-Log "Start: SQL KB installation program MAIN"
	Try {
	Write-Log "starting $SQLSetupEXE with parameters $InstallArgs"
	Execute-Process -Path $SQLSetupEXE -Parameters $InstallArgs -PassThru -WindowStyle Hidden -CreateNoWindow
	}
	Catch {
	Write-Log "Installation of $SQLSetupEXE has failed. Error message: $_.Exception.Message" -Severity 3
	Write-Log "End: SQL KB installation program MAIN"
	Exit-Script -ExitCode 69004
	}
	Write-Log "End: SQL KB installation program MAIN"

	# Add regkey to Control Restart (0 initial, 1 needs restart)
	Push-Location
	Set-Location HKLM:
	$Group_value = "1"
	New-Item -Path $registryPath
	New-ItemProperty -Path $registryPath -Name $Group -Value $Group_value -PropertyType String –Force
	Pop-Location

	## Handle Zero-Config MSI Installations
	If ($useDefaultMsi) {
	[hashtable]$ExecuteDefaultMSISplat = @{ Action = 'Install'; Path = $defaultMsiFile }; If ($defaultMstFile) { $ExecuteDefaultMSISplat.Add('Transform', $defaultMstFile) }
	Execute-MSI @ExecuteDefaultMSISplat; If ($defaultMspFiles) { $defaultMspFiles \| ForEach-Object { Execute-MSI -Action 'Patch' -Path $_ } }
	}


	##*===============================================
	##* POST-INSTALLATION
	##*===============================================
	[string]$installPhase = 'Post-Installation'

	## <Perform Post-Installation tasks here>
	Write-Log "Performing post-installation tasks"

	Function Reboot_Pending {
	<#
	.SYNOPSIS
	The function is checking if there is a reboot pending.
	.DESCRIPTION
	The function is checking if there is a reboot pending.
	#>
	$Reboot = $false
	$SCCMUpdate = get-wmiobject -query "SELECT * FROM CCM_SoftwareUpdate" -namespace "ROOT\ccm\ClientSDK"
	$Reboot = $Reboot -or ([wmiclass]'ROOT\ccm\ClientSDK:CCM_ClientUtilities').DetermineIfRebootPending().RebootPending
	$Reboot = $Reboot -or ([wmiclass]'ROOT\ccm\ClientSDK:CCM_ClientUtilities').DetermineIfRebootPending().IsHardRebootPending
	if(@(((Get-ItemProperty("HKLM:\SYSTEM\CurrentControlSet\Control\Session Manager")).$("PendingFileRenameOperations")) \| where { $_ }).length -ne 0) {$Reboot=$true}
	if(@($SCCMUpdate \| where { $_.EvaluationState -eq 8 -or $_.EvaluationState -eq 9 -or $_.EvaluationState -eq 10 }).length -ne 0) {$Reboot=$true}
	return $Reboot
	}
	If (Reboot_Pending) {
	Write-Log "System reboot is pending"
	Exit-Script -ExitCode 3010
	#Restart-Computer
	#Invoke-WmiMethod -Namespace root\ccm\clientsdk -Class CCM_ClientUtilities -Name RestartComputer
	}
	Else {
	Write-Log "Starting SQL Agent Service"
	Try {
	Start-Service -name SQLSERVERAGENT -Erroraction Stop
	Write-Log "SQL Agent Service has been started"
	}
	Catch {
	Write-Log "SQL Agent service could not be started. Exiting..." -Severity 3
	Exit-Script -ExitCode 69005
	}
	}

	## Display a message at the end of the install
	#If (-not $useDefaultMsi) { Show-InstallationPrompt -Message 'You can customize text to appear at the end of an install or remove it completely for unattended installations.' -ButtonRightText 'OK' -Icon Information -NoWait }
	}
	ElseIf ($deploymentType -ieq 'Uninstall')
	{
	##*===============================================
	##* PRE-UNINSTALLATION
	##*===============================================
	[string]$installPhase = 'Pre-Uninstallation'

	## Show Welcome Message, close Internet Explorer with a 60 second countdown before automatically closing
	#Show-InstallationWelcome -CloseApps 'iexplore' -CloseAppsCountdown 60

	## Show Progress Message (with the default message)
	#Show-InstallationProgress

	## <Perform Pre-Uninstallation tasks here>

	Write-Log "Stoping SQL Agent Service"
	Try {
	Stop-Service -name SQLSERVERAGENT -Erroraction Stop
	Write-Log "SQL Agent Service has been stopped"
	}
	Catch {
	Write-Log "SQL Agent service could not be stopped. Exiting..." -Severity 3
	Exit-Script -ExitCode 69001
	}

	##*===============================================
	##* UNINSTALLATION
	##*===============================================
	[string]$installPhase = 'Uninstallation'

	## Handle Zero-Config MSI Uninstallations
	If ($useDefaultMsi) {
	[hashtable]$ExecuteDefaultMSISplat = @{ Action = 'Uninstall'; Path = $defaultMsiFile }; If ($defaultMstFile) { $ExecuteDefaultMSISplat.Add('Transform', $defaultMstFile) }
	Execute-MSI @ExecuteDefaultMSISplat
	}

	# <Perform Uninstallation tasks here>

	# Uninstall SQL Server Service Pack
	Write-Log "Start: SQL SERVICE PACK removal program MAIN"

	#Execute SQL SP removal
	Try {
	Write-Log "starting $SQLSetupEXE with parameters $UninstallArgs"
	Execute-Process -Path $SQLSetupEXE -Parameters $UninstallArgs -PassThru -WindowStyle Hidden
	}
	Catch {
	Write-Log "Removal of $SQLSetupEXE has failed. Error message: $_.Exception.Message" -Severity 3
	Write-Log "End: SQL SERVICE PACK inatallation program MAIN"
	Exit-Script -ExitCode 69006
	}
	Write-Log "End: SQL SERVICE PACK removal program MAIN"

	##*===============================================
	##* POST-UNINSTALLATION
	##*===============================================
	[string]$installPhase = 'Post-Uninstallation'

	## <Perform Post-Uninstallation tasks here>

	Write-Log "Performing post-uninstallation tasks"

	If ((Get-PendingReboot).IsSystemRebootPending) {
	Write-Log "System reboot is pending"
	Exit-Script -ExitCode 3010
	#Restart-Computer
	}
	Else {
	Write-Log "Starting SQL Agent Service"
	Try {
	Start-Service -name SQLSERVERAGENT -Erroraction Stop
	Write-Log "SQL Agent Service has been started"
	}
	Catch {
	Write-Log "SQL Agent service could not be started. Exiting..." -Severity 3
	Exit-Script -ExitCode 69005
	}
	}

	}

	##*===============================================
	##* END SCRIPT BODY
	##*===============================================

	## Call the Exit-Script function to perform final cleanup operations
	Exit-Script -ExitCode $mainExitCode
	}
	Catch {
	[int32]$mainExitCode = 60001
	[string]$mainErrorMessage = "$(Resolve-Error)"
	Write-Log -Message $mainErrorMessage -Severity 3 -Source $deployAppScriptFriendlyName
	Show-DialogBox -Text $mainErrorMessage -Icon 'Stop'
	Exit-Script -ExitCode $mainExitCode
	}