Create a Custom Detection Script for Memento Database Desktop (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 Memento Database Desktop using PowerShell.

How to Create a Custom Detection Script for Memento Database Desktop

Memento Database Desktop (File Detection Method)

## Check for Memento Database Desktop (File Detection Method)
$MementoDatabaseExe = (Get-ChildItem -Path "C:\Program Files\Memento Database\mementodb.exe","C:\Program Files (x86)\Memento Database\mementodb.exe" -ErrorAction SilentlyContinue)
$MementoDatabaseExe.FullName
$MementoDatabasePath = $($MementoDatabaseExe.FullName).Replace("C:\Program Files\","").Replace("C:\Program Files (x86)\","")
$FileVersion = (Get-Item -Path "$($MementoDatabaseExe.FullName)" -ErrorAction SilentlyContinue).VersionInfo.FileVersion

## Create Text File with Memento Database Desktop File Detection Method
$FilePath = "C:\Windows\Temp\Memento_Database_Detection_Method.txt"
New-Item -Path "$FilePath" -Force
Set-Content -Path "$FilePath" -Value "If([String](Get-Item -Path `"`$Env:ProgramFiles\$MementoDatabasePath`",`"`${Env:ProgramFiles(x86)}\$MementoDatabasePath`" -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 Memento Database Desktop Detection Method script required to detect the current version of Memento Database Desktop that is installed on the device you are running the script from.

Example:

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

Memento Database Desktop (Registry Detection Method)

## Check for Memento Database Desktop (Registry Detection Method)
$MementoDatabase = Get-ChildItem -Path "HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall","HKLM:\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\Uninstall" | Get-ItemProperty | Where-Object {$_.DisplayName -match 'Memento Database Desktop' } | Select-Object -Property DisplayName, DisplayVersion, PSChildName
$MementoDatabase.DisplayVersion
$MementoDatabase.PSChildName

## Create Text File with Memento Database Desktop Registry Detection Method
$FilePath = "C:\Windows\Temp\Memento_Database_Detection_Method.txt"
New-Item -Path "$FilePath" -Force
Set-Content -Path "$FilePath" -Value "If([Version](Get-ItemPropertyValue -Path 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\$($MementoDatabase.PSChildName)','HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\$($MementoDatabase.PSChildName)' -Name DisplayVersion -ea SilentlyContinue) -ge '$($MementoDatabase.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 Memento Database Desktop Detection Method script required to detect the current version of Memento Database Desktop that is installed on the device you are running the script from.

Example:

If([Version](Get-ItemPropertyValue -Path 'HKLM:\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall\Memento Database Desktop_is1','HKLM:\SOFTWARE\WOW6432Node\Microsoft\Windows\CurrentVersion\Uninstall\Memento Database Desktop_is1' -Name DisplayVersion -ea SilentlyContinue) -ge '3.1.1') {
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.