Create a Custom Detection Script for RETScreen Expert (PowerShell)

Microsoft Endpoint Manager Configuration Manager (MEMCM / SCCM) and Microsoft Intune use Detection Rules to determine the presence of Applications & Win32 Apps. The detection rules ensure that application installations only begin to run if the application is not already installed on the device. This article will serve as an informative guide and give you a clear understanding of how to create an updated custom detection script for each new version of RETScreen Expert using PowerShell.

How to Create a Custom Detection Script for RETScreen Expert

RETScreen Expert (File Detection Method)

## Check for RETScreen Expert (File Detection Method)
$RETScreenExpertExe = (Get-ChildItem -Path "C:\Program Files\RETScreen\RETScreen Expert\RETScreenExpert.exe","C:\Program Files (x86)\RETScreen\RETScreen Expert\RETScreenExpert.exe" -ErrorAction SilentlyContinue)
$RETScreenExpertExe.FullName
$RETScreenExpertPath = $($RETScreenExpertExe.FullName).Replace("C:\Program Files\","").Replace("C:\Program Files (x86)\","")
$FileVersion = (Get-Item -Path "$($RETScreenExpertExe.FullName)" -ErrorAction SilentlyContinue).VersionInfo.FileVersion

## Create Text File with RETScreen Expert File Detection Method
$FilePath = "C:\Windows\Temp\RETScreen_Expert_Detection_Method.txt"
New-Item -Path "$FilePath" -Force
Set-Content -Path "$FilePath" -Value "If([String](Get-Item -Path `"`$Env:ProgramFiles\$RETScreenExpertPath`",`"`${Env:ProgramFiles(x86)}\$RETScreenExpertPath`" -ErrorAction SilentlyContinue).VersionInfo.FileVersion -ge `"$FileVersion`"){"
Add-Content -Path "$FilePath" -Value "Write-Host `"Installed`""
Add-Content -Path "$FilePath" -Value "Exit 0"
Add-Content -Path "$FilePath" -Value "}"
Add-Content -Path "$FilePath" -Value "else {"
Add-Content -Path "$FilePath" -Value "Exit 1"
Add-Content -Path "$FilePath" -Value "}"
Invoke-Item $FilePath
  • Click Run Script (F5)
  • A text file will open with the RETScreen Expert Detection Method script required to detect the current version of RETScreen Expert that is installed on the device you are running the script from.

Example:

If([String](Get-Item -Path "$Env:ProgramFiles\RETScreen\RETScreen Expert\RETScreenExpert.exe","${Env:ProgramFiles(x86)}\RETScreen\RETScreen Expert\RETScreenExpert.exe" -ErrorAction SilentlyContinue).VersionInfo.FileVersion -ge "9.0.0.0"){
Write-Host "Installed"
Exit 0
}
else {
Exit 1
}

RETScreen Expert (Registry Detection Method)

## Check for RETScreen Expert (Registry Detection Method)
$RETScreenExpert = Get-ChildItem -Path "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall","HKLM:\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall" | Get-ItemProperty | Where-Object {$_.DisplayName -match 'RETScreen Expert' -and $_.UninstallString -notlike '*MsiExec.exe*' } | Select-Object -Property DisplayName, DisplayVersion, PSChildName
$RETScreenExpert.DisplayVersion
$RETScreenExpert.PSChildName

## Create Text File with RETScreen Expert Registry Detection Method
$FilePath = "C:\Windows\Temp\RETScreen_Expert_Detection_Method.txt"
New-Item -Path "$FilePath" -Force
Set-Content -Path "$FilePath" -Value "If([Version](Get-ItemPropertyValue -Path 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\$($RETScreenExpert.PSChildName)','HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\$($RETScreenExpert.PSChildName)' -Name DisplayVersion -ea SilentlyContinue) -ge '$($RETScreenExpert.DisplayVersion)') {"
Add-Content -Path "$FilePath" -Value "Write-Host `"Installed`""
Add-Content -Path "$FilePath" -Value "Exit 0"
Add-Content -Path "$FilePath" -Value "}"
Add-Content -Path "$FilePath" -Value "else {"
Add-Content -Path "$FilePath" -Value "Exit 1"
Add-Content -Path "$FilePath" -Value "}"
Invoke-Item $FilePath
  • Click Run Script (F5)
  • A text file will open with the RETScreen Expert Detection Method script required to detect the current version of RETScreen Expert that is installed on the device you are running the script from.

Example:

If([Version](Get-ItemPropertyValue -Path 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\{eff7e647-8891-40f9-aeea-e55e2f67f924}','HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\{eff7e647-8891-40f9-aeea-e55e2f67f924}' -Name DisplayVersion -ea SilentlyContinue) -ge '9.0.0.0') {
Write-Host "Installed"
Exit 0
}
else {
Exit 1
}

Always make sure to test everything in a development environment prior to implementing anything into production. The information in this article is provided “As Is” without warranty of any kind.

Jason Bergner

I am an accomplished Software Engineer at Patch My PC, leveraging more than 18 years of hands-on experience in Configuration Manager administration and application packaging. I am driven by a genuine passion for solving complex problems and consistently strive to discover innovative and effective solutions. Sharing my extensive knowledge of application deployments is a true joy for me, and I am honored to contribute to the community here at Silent Install HQ.

Recent Posts