How to remove executables with wrong versions for usage metering from software products

Last updated
Save as PDF

Issue

In the past, wrong executable versions have been delivered with LIS Premium for usage tracking. The versions did not contain explicit wildcard. While in LIS this was corrected, the update mechanism does not remove any previously delivered executables.

Example:

Executable	Wrong Version	Correct Version
acrobat.exe	10	10.%

Solution

Open SQL Management Studio, connect to your database server and run following SQL script:

use M42Production
go
delete
from    SPSApplicationUsageClassExecutable
where    Version not like '%[%]%'