To address this issue in an impacted environment, follow these steps in the Snow License Manager database:

1. Backup: Back up the current Snow License Manager database backup before performing any database-related actions.
2. Script execution: The following script is divided into four commands:
   • Command One: Remove the index IX_tblSoftware_ExecutablePathReversed bound to dbo.tblSoftware.
   • Command Two: Drop the column ExecutablePathReversed from dbo.tblSoftware.
   • Command Three: Recreate the ExecutablePathReversed column and populate it with the reverse of the ExecutablePath column.
   • Command Four: Recreate the index IX_tblSoftware_ExecutablePathReversed bound to dbo.tblSoftware.

USE SnowLicenseManager;


-- Command One

IF EXISTS(SELECT 1 FROM sys.indexes WHERE name = 'IX_tblSoftware_ExecutablePathReversed')

    DROP INDEX IX_tblSoftware_ExecutablePathReversed ON dbo.tblSoftware;


-- Command Two

IF EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tblSoftware' AND TABLE_SCHEMA = 'dbo' AND COLUMN_NAME = 'ExecutablePathReversed')

    ALTER TABLE dbo.tblSoftware DROP COLUMN ExecutablePathReversed;


-- Command Three

IF NOT EXISTS(SELECT 1 FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_NAME = 'tblSoftware' AND TABLE_SCHEMA = 'dbo' AND COLUMN_NAME = 'ExecutablePathReversed')

    ALTER TABLE dbo.tblSoftware ADD ExecutablePathReversed AS REVERSE(ExecutablePath);


-- Command Four

IF NOT EXISTS(SELECT 1 FROM sys.indexes WHERE name = 'IX_tblSoftware_ExecutablePathReversed')

    CREATE NONCLUSTERED INDEX IX_tblSoftware_ExecutablePathReversed ON dbo.tblSoftware (ExecutablePathReversed);

3. Data Update Job: After applying the script, run the next Data Update Job as a Full SRS Rule Reset via the RUN_COMPLETE_RULESET_DAY setting in the Snow Management and Configuration Center to ensure all rules are considered.

Following these steps will ensure that SRS Rules trigger correctly based on data sets collected from inventory sources.