Incorrect version extraction in CmdbIntegrationSoftwareModelUtil when software name ends with number . (CSTASK1362619) - Known Error

Incorrect version extraction in CmdbIntegrationSoftwareModelUtil when software name ends with number . (CSTASK1362619) Description When using the "Cleanse Software Model" transform operation from the Integration Commons for CMDB application, the Script Include CmdbIntegrationSoftwareModelUtil attempts to extract the software version from the software name if the version field is empty.

This is done using the regex pattern:

var PAT_VERSION = /\w?\d+(?:\.\d+)*$/;

This pattern tries to detect version numbers at the end of the software name. However, in some cases it may incorrectly interpret part of the software name as the version when the name ends with a number.

Example:

Software name: Rider1 Version: (empty)

Current result: Version is extracted as "r1"

Expected result: Software name should remain "Rider1" and version should remain empty.

This happens because the regex allows an optional character before the number and matches trailing digits, which may be part of the software name rather than the version.

In real-world data, software names may contain numbers for different reasons. Sometimes the number represents the version (for example Java8 or Postman10), and sometimes the number is part of the software name itself (for example 7Zip).

Steps to Reproduce

1. Navigate to the transform operation "Cleanse Software Model". 2. Use CmdbIntegrationSoftwareModelUtil to parse software name and version. 3. Provide input values: name = "Rider1" version = "" 4. Execute the transform.

Result: Version is extracted as "r1".

Expected result: Software name should remain "Rider1" and version should remain empty.

or Run any scheduled import where we get such values from API or create a sample import set with software name as that value for SCCM and run transform

Workaround Customers can modify the regex logic in the Script Include to better match their data patterns.

One possible approach is to only extract the version when there is a space before the version number.

This approach ensures version extraction happens only when the version is clearly separated from the software name (for example "Rider v1" or "Rider 1"). In cases like "Rider1", the name will remain unchanged and the version will stay empty.

For the above work around:

Go to script include "CmdbIntegrationSoftwareModelUtil" or go to below URL directly https:// .service-now.com/sys_script_include.do?sys_id=ed556f92c75200109cea1197fdc260d7

Modify 31 line which is

var PAT_VERSION = /\w?\d+(?:\.\d+)*$/;" to var PAT_VERSION = / v?\d+(?:\.\d+)*$/;" and save it. NOTE: However, customers should review their software inventory patterns before making this change. In some environments, version numbers may appear directly after the software name without a space (for example Java8 or Python3).

Because software naming conventions vary across environments and data sources, a single rule may not work for all cases. Customers may adjust the parsing logic based on their own data patterns and requirements.