Based on the previous post handling the removal of the Ask software (the beloved add-on that everyone joyfully installs along with Java) a more developed script took form to handle any type of software.
Its based on the following borrowed pieces of code,
Get-LHSInstInstalledApp has been extended to also output the installationdate. Apart from that everything is as is from the original function
Convert-DateString has been used to convert the InstallationDate string to a date that can be used for calculations
ExitWithCode is a function that is simply used to end the script with an accumulated Exit Code from all uninstallations.
The script will accept best canada online casinos the following parameters;
ApplicationName – a wild card search for the applications we want to remove.
PublisherName – we can validate that the right publisher have installed the application
InstallDateOlder – amount of days since the application was installed for us to remove it. Standard is 30
IgnoreInstallDate – True / False – we can choose to completely ignore when the application was installed
If the application is something other than an MSI – it will just report that a productcode is missing and not attempt the installation.
A log-file will be created in %WINDIR%\TEMP\APP_(yourappname)_Removal.LOG
Each uninstall will have a log-file written in %WINDIR%\TEMP with AP_UNINSTALL as prefix.
Running the script requires admin permissions
#======================================================================== # Created with: PowerShell ISE # Created on: 2015-02-21 23:32 # Created by: Nicke Källén # Organization: Applepie.se # Filename: SCCM_Uninstall_Unused_Application # Comment: Uninstalls an application (msi support only) based # on Display Name in ARP, Publisher and how long ago # it was installed # Convert-DateString function # http://www.powershellmagazine.com/2013/07/08/pstip- # converting-a-string-to-a-system-datetime-object/ # Get-LHSInstalledApp - appended InstallDate to output # https://gallery.technet.microsoft.com/scriptcenter/ # Get-Installed-Application-615fa73a # Exit function # http://weblogs.asp.net/soever/returning-an-exit- # code-from-a-powershell-script #======================================================================== param ( [Parameter(Position=0,Mandatory=$true,ValueFromPipeline=$True)] [string]$ApplicationName = "", [Parameter(Position=1,Mandatory=$false,ValueFromPipeline=$false)] [string]$PublisherName = "", [int]$InstallDateOlder = "30", [Parameter(mandatory=$false)] [bool]$IgnoreInstallDate=$false ) function Convert-DateString ([String]$Date, [String[]]$Format) { $result = New-Object DateTime $convertible = [DateTime]::TryParseExact( $Date, $Format, [System.Globalization.CultureInfo]::InvariantCulture, [System.Globalization.DateTimeStyles]::None, [ref]$result) if ($convertible) { $result } } Function Get-LHSInstalledApp { <# .SYNOPSIS List installed applications for local or remote computers. .DESCRIPTION List installed applications for local or remote computers. List both 32-bit and 64-bit applications. Note that dotNet 4.0 Support for Powershell 2.0 needed. Output looks like this: ------------------------- ComputerName : N104100 AppID : {90120000-001A-0407-0000-0000000FF1CE} AppName : Microsoft Office Outlook MUI (German) 2007 Publisher : Microsoft Corporation Version : 12.0.6612.1000 Architecture : 32bit UninstallString : MsiExec.exe /X{90120000-001A-0407-0000-0000000FF1CE} .PARAMETER ComputerName Outputs applications for the named computer(s). If you omit this parameter, the local computer is assumed. .PARAMETER AppID Outputs applications with the specified application ID. An application's appID is equivalent to its subkey name underneath the Uninstall registry key. For Windows Installer-based applications, this is the application's product code GUID (e.g. {3248F0A8-6813-11D6-A77B-00B0D0160060}). Wildcards are permitted. .PARAMETER AppName Outputs applications with the specified application name. The AppName is the application's name as it appears in the Add/Remove Programs list. Wildcards are permitted. .PARAMETER Publisher Outputs applications with the specified publisher name. Wildcards are permitted .PARAMETER Version Outputs applications with the specified version. Wildcards are permitted. .EXAMPLE PS C:\> Get-LHSInstalledApp This command outputs installed applications on the current computer. .EXAMPLE PS C:\> Get-LHSInstalledApp | Select-Object AppName,Version | Sort-Object AppName This command outputs a sorted list of applications on the current computer. .EXAMPLE PS C:\> Get-LHSInstalledApp wks1,wks2 -Publisher "*microsoft*" This command outputs all installed Microsoft applications on the named computers. * regular expression to match any characters. .EXAMPLE PS C:\> Get-LHSInstalledApp wks1,wks2 -AppName "*Office 97*" This command outputs any Application Name that match "Office 97" on the named computers. * regular expression to match any characters. .EXAMPLE PS C:\> Get-Content ComputerList.txt | Get-LHSInstalledApp -AppID "{1A97CF67-FEBB-436E-BD64-431FFEF72EB8}" | Select-Object ComputerName This command outputs the computer names named in ComputerList.txt that have the specified application installed. .EXAMPLE Get-LHSInstalledApp | Where-Object {-not ( $_.AppID -like "KB*") } | ConvertTo-CSV -Delimiter ';' -NoTypeInformation | Out-File -FilePath C:\temp\AppsInfo.csv Invoke-Item C:\temp\AppsInfo.csv Outputs all installed application except KB fixes to an CSV file and opens in Excel .INPUTS System.String, you can pipe ComputerNames to this Function .OUTPUTS PSObjects containing the following properties: ComputerName - computer where the application is installed AppID - the application's AppID AppName - the application's name Publisher - the application's publisher Version - the application's version Architecture - the application's architecture (32-bit or 64-bit) UninstallString - the application uninstall String .NOTES More Info: ========== Why not using Get-WmiObject --------------------------- * Win32_Product At first glance, Win32_Product would appear to be one of those best solutions. The Win32_product class is not query optimized. Queries such as “select * from Win32_Product where (name like 'Sniffer%')” require WMI to use the MSI provider to enumerate all of the installed products and then parse the full list sequentially to handle the “where” clause:, * This process initiates a consistency check of packages installed, and then verifying and repairing the installations. * If you have an application that makes use of the Win32_Product class, you should contact the vendor to get an updated version that does not use this class. On Windows Server 2003, Windows Vista, and newer operating systems, querying Win32_Product will trigger Windows Installer to perform a consistency check to verify the health of the application. This consistency check could cause a repair installation to occur. You can confirm this by checking the Windows Application Event log. You will see the following events each time the class is queried and for each product installed: Event ID: 1035 Description: Windows Installer reconfigured the product. Product Name: <ProductName>. Product Version: <VersionNumber>. Product Language: <languageID>. Reconfiguration success or error status: 0. Event ID: 7035/7036 Description: The Windows Installer service entered the running state. I would not recommend querying Win32_Product in your production environment unless you are in a maintenance window. * Win32Reg_AddRemovePrograms Win32Reg_AddRemovePrograms is not a standard Windows class. This WMI class is only loaded during the installation of an SMS/SCCM client. What is great about Win32Reg_AddRemovePrograms is that it contains similar properties and returns results noticeably quicker than Win32_Product. Using Registry: ---------------- By default, if your process is running as a 32 bit process you will end up accessing the 32 bit "reflection" of the remote system. Therefore, registry keys like HKLM\Software will actually be mapped to HKLM\Software\Wow6432Node which gets very frustrating! You can access the 64 bit "reflection" via WMI, but personally I find that quite painful. Fortunately, in .NET 4, the registry class had some extra features added to it which allowed for a new overload "RegistryView". Therefore, you can now specify exactly which "reflection" of the registry you want to access and manipulate! No more headaches! In order to use this function, the Powershell instance must support .Net 4.0 or greater, which is fairly straightforward if you follow these instructions. 1. Open notepad and copy the below text exactly as shown into the document. <?xml version="1.0"?> <configuration> <startup useLegacyV2RuntimeActivationPolicy="true"> <supportedRuntime version="v4.0.30319"/> <supportedRuntime version="v2.0.50727"/> </startup> </configuration> 2. Save this document as c:\windows\System32\WindowsPowerhsell\v1.0\Powershell.exe.config (and/or c:\windows\System32\WindowsPowerhsell\v1.0\Powershell_ise.exe.config) (in addition for the 32bit Powershell on a 64bit Windows C:\Windows\SysWOW64\WindowsPowerShell\v1.0\*.config) 3. Reload powershell and type the following command: $PsVersionTable.clrVersion (It should show Major version 4 if .Net 4 is supported.) NAME: Get-LHSInatalledApp.ps1 AUTHOR: u104018 LASTEDIT: 02/06/2012 16:01:40 KEYWORDS: Registry Redirection, Installed software, Registry64, WOW6432Node,Accessing Remote x64 Registry From an x86/x32 OS Computer .LINK http://poshcode.org/3186 http://blogs.technet.com/b/heyscriptingguy/archive/2011/11/13/use-powershell-to-quickly-find-installed-software.aspx http://msdn.microsoft.com/en-us/library/aa393067%28VS.85%29.aspx #Requires -Version 2.0 #> [cmdletbinding(DefaultParameterSetName = 'Default', ConfirmImpact = 'low')] Param( [Parameter(ParameterSetName='AppID', Position=0,Mandatory=$False,ValueFromPipeline=$True)] [Parameter(ParameterSetName='Default', Position=0,Mandatory=$False,ValueFromPipeline=$True)] [string[]] $ComputerName=$ENV:COMPUTERNAME, [Parameter(ParameterSetName='AppID', Position=1)] [String] $AppID = "*", [Parameter(ParameterSetName='Default', Position=1)] [String] $AppName = "*", [Parameter(ParameterSetName='Default', Position=2)] [String] $Publisher = "*", [Parameter(ParameterSetName='Default', Position=3)] [String] $Version = "*" ) BEGIN { ${CmdletName} = $Pscmdlet.MyInvocation.MyCommand.Name If (!($PsVersionTable.clrVersion.Major -ge 4)) {Write-Error "Requires .Net 4.0 support for Powershell 2.0"; Return} } # end BEGIN PROCESS { #Write-Verbose -Message "${CmdletName}: Starting Process Block" ForEach ($Computer in $ComputerName) { Write-Verbose "`$Computer contains $Computer" IF (Test-Connection -ComputerName $Computer -Count 2 -Quiet) { try { Write-Verbose "Get Architechture Type of the system" $OSArch = (Get-WMIObject -ComputerName $Computer win32_operatingSystem -ErrorAction Stop).OSArchitecture if ($OSArch -like "*64*") {$Architectures = @("32bit","64bit")} else {$Architectures = @("32bit")} #Create an array to capture program objects. $arApplications = @() foreach ($Architecture in $Architectures){ #We have a 64bit machine, get the 32 bit software. if ($Architecture -like "*64*"){ #Define the entry point to the registry. $strSubKey = "SOFTWARE\\WOW6432Node\\Microsoft\\Windows\\CurrentVersion\\Uninstall" $SoftArchitecture = "32bit" $RegViewEnum = [Microsoft.Win32.RegistryView]::Registry64 } #We have a 32bit machine, use the 32bit registry provider. elseif ($Architectures -notcontains "64bit"){ #Define the entry point to the registry. $strSubKey = "SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall" $SoftArchitecture = "32bit" $RegViewEnum = [Microsoft.Win32.RegistryView]::Registry32 } #We have "64bit" in our array, capture the 64bit software. else{ #Define the entry point to the registry. $strSubKey = "SOFTWARE\\Microsoft\\Windows\\CurrentVersion\\Uninstall" $SoftArchitecture = "64bit" $RegViewEnum = [Microsoft.Win32.RegistryView]::Registry64 } Write-Verbose "Create a remote registry connection to the Computer." $Reg = [Microsoft.Win32.RegistryKey]::OpenRemoteBaseKey('LocalMachine', $Computer, $RegViewEnum) $RegKey = $Reg.OpenSubKey($strSubKey) Write-Verbose "Get all subkeys that exist in the entry point." $RegSubKeys = $RegKey.GetSubKeyNames() Write-Debug "Architecture : $Architecture" Write-Debug "SoftArchitecture : $SoftArchitecture" Write-Verbose "Enumerate the subkeys." foreach ($SubKey in $RegSubKeys) { Write-Debug "`$SubKey : $SubKey" $Program = $Reg.OpenSubKey("$strSubKey\\$SubKey") $strDisplayName = $Program.GetValue("DisplayName") if ($strDisplayName -eq $NULL) { continue } # skip entry if empty display name switch ($PsCmdlet.ParameterSetName) { "AppID" { if ((split-path $SubKey -leaf) -like $AppID) { $RegKey = ("HKLM\$strSubKey\$SubKey").replace("\\","\") $output = new-object PSObject $output | add-member NoteProperty "ComputerName" -value $computer $output | add-member NoteProperty "RegKey" -value ($RegKey) # useful when debugging $output | add-member NoteProperty "AppID" -value (split-path $SubKey -leaf) $output | add-member NoteProperty "AppName" -value $strDisplayName $output | add-member NoteProperty "Publisher" -value $Program.GetValue("Publisher") $output | add-member NoteProperty "Version" -value $Program.GetValue("DisplayVersion") $output | add-member NoteProperty "Architecture" -value $SoftArchitecture $output | add-member NoteProperty "UninstallString" -value $Program.GetValue("UninstallString") $output | add-member NoteProperty "InstallDate" -value $Program.GetValue("InstallDate") $output } #end if } #end "AppID" "Default" { If (( $strDisplayName -like $AppName ) -and ( $Program.GetValue("Publisher") -like $Publisher ) -and ( $Program.GetValue("DisplayVersion") -like $Version )) { $RegKey = ("HKLM\$strSubKey\$SubKey").replace("\\","\") $output = new-object PSObject $output | add-member NoteProperty "ComputerName" -value $computer $output | add-member NoteProperty "RegKey" -value ($RegKey) # useful when debugging $output | add-member NoteProperty "AppID" -value (split-path $SubKey -leaf) $output | add-member NoteProperty "AppName" -value $strDisplayName $output | add-member NoteProperty "Publisher" -value $Program.GetValue("Publisher") $output | add-member NoteProperty "Version" -value $Program.GetValue("DisplayVersion") $output | add-member NoteProperty "Architecture" -value $SoftArchitecture $output | add-member NoteProperty "UninstallString" -value $Program.GetValue("UninstallString") $output | add-member NoteProperty "InstallDate" -value $Program.GetValue("InstallDate") $output } #end if } #end "Default" } #end switch } # end foreach ($SubKey in $RegSubKeys) } # end foreach ($Architecture in $Architectures) } Catch { write-error $_ } } Else { Write-Warning "\\$Computer DO NOT reply to ping" } # end IF (Test-Connection -ComputerName $Computer -count 2 -quiet) } # end ForEach ($Computer in $computerName) } # end PROCESS END { Write-Verbose "Function ${CmdletName} finished." } } # end Function Get-LHSInatalledApp function Log { [cmdletbinding()] param ( [Parameter(Position=1,Mandatory=$true,ValueFromPipeline=$true)] [string]$text, [Parameter(Position=0,Mandatory=$true,ValueFromPipeline=$False)] [string]$filename ) begin { Write-Debug 'Logging starting' Write-Debug "Filename: $($filename)" } process { foreach ($txt in $text) { Out-File $filename -append -noclobber -inputobject $txt -encoding ASCII Write-Verbose $txt } } end { Write-Debug 'Logging ending' } } function ExitWithCode { param ($exitcode) Write-Verbose "Ending with $($ExitCode)" $host.SetShouldExit($exitcode) exit } function Remove-InstalledMSI { [cmdletbinding()] param ( [Parameter(Position=0,Mandatory=$true,ValueFromPipeline=$True,ValueFromPipelineByPropertyName)] [ValidatePattern('\{.+\}')] [Alias('AppID')] [string]$ProductCode = $null, [Parameter(Position=1,Mandatory=$false,ValueFromPipeline=$False)] [string]$LogFilePath, [Parameter(Position=1,Mandatory=$false,ValueFromPipeline=$False)] [string]$Property ) begin { Write-Verbose 'Start of Remove-InstallMSI' $exitcode = $null } process { foreach ($pc in $ProductCode) { Write-Verbose "Uninstall ProductCode: $($pc)" $AppName = $((Get-LHSInstalledApp -AppID $pc).AppName) Write-Verbose "AppName: $($AppName)" if ($LogFilePath -ne $null) { $LogFilePath = "c:\windows\TEMP\AP_UNINSTALL_$($AppName).log" } else { Write-verbose "LogFilePath: $LogFilePath" } $argumentlist = "/x $pc /qn REBOOT=ReallySuppress /lv `"$($LogFilePath)`" " $argumentlist += $Property Write-Verbose "Argument List: $($argumentlist)" $exitcode = (Start-Process -filepath "msiexec.exe" -ArgumentList $argumentlist -Wait -PassThru).ExitCode Write-Verbose "Exit Code: $($exitcode)" $output = new-object PSObject $output | add-member NoteProperty "ProductCode" -value $pc $output | add-member NoteProperty "AppName" -value $AppName $output | add-member NoteProperty "ExitCode" -value $($ExitCode) $output | add-member NoteProperty "LogFilePath" -value $LogFilePath $output } } end { Write-Verbose 'End of Remove-InstallMSI' } } $logfile = "$env:windir\temp\AP_$($ApplicationName)_Removal.log" Write-Verbose "Logfile: $($logfile)" try { Remove-Item $logfile -force -ErrorAction SilentlyContinue } catch { Write-Warning $_ } log $logfile '--------------------------------------------' log $logfile "$(get-date) - $($ApplicationName) - Removal Started" log $logfile "$(get-date) - $($ApplicationName) - Searching for $($PublisherName) $($ApplicationName)" if ($IgnoreInstallDate -eq $true) { Write-Verbose "IgnoreInstallDate set $($IgnoreInstallDate)" log $logfile "$(get-date) - $($ApplicationName) - Ignoring installation date" } else { Write-Verbose "IgnoreInstallDate set $($IgnoreInstallDate)" log $logfile "$(get-date) - $($ApplicationName) - Removal only if install date is more than $($InstallDateOlder) days ago" } if ($PublisherName) { $applist = Get-LHSInstalledApp -AppName "*$($ApplicationName)*" -Publisher "*$($PublisherName)*" } else { $applist = Get-LHSInstalledApp -AppName "*$($ApplicationName)*" } log $logfile "$(get-date) - $($ApplicationName) - Found $($applist.Count) $($ApplicationName) installations" log $logfile '--------------------------------------------' $applist | foreach { write-verbose "AppName: $($_.AppName)"} $ReturnValue = 0 Write-Verbose "Current Exit Code: $($ReturnValue)" $applist | where {$_.appid -notmatch ('\{.+\}') } | foreach { log $logfile "$(get-date) - $($_.AppName) has no productcode" } $applist = $applist | where {$_.appid -match ('\{.+\}') } if ($IgnoreInstallDate -eq $true) { $uninstall = $applist | Remove-InstalledMSI } else { $uninstall = $applist | where-object { ($_.InstallDate -notin ($null,'')) -and` ( ((get-date) - (Convert-DateString -Date $($_.InstallDate) -Format 'yyyyMMdd')).days -gt $InstallDateOlder ) }` | Remove-InstalledMSI } $uninstall | foreach { log $logfile "$(get-date) - $($_.AppName) - Exit Code: $($_.ExitCode)" ; $returnvalue += $_.exitcode } log $logfile '--------------------------------------------' log $logfile "$(get-date) - $($ApplicationName) - Removal Finished" ExitWithCode($ReturnValue)
