We've updated the ServiceNow Community Code of Conduct, adding guidelines around AI usage, professionalism, and content violations. Read more

Incomplete MSFT SQL Server Edition Information in Software Discovery Model

Nurulaslah Anua
Tera Contributor

This discovery model, "Microsoft SQL Server 2016 (64-bit)," doesn't specify an edition. We discovered 50 devices with this model installed.

We searched these 50 devices in the MS-SQL instances table (cmdb_ci_db_mssql_instance) and found multiple editions (Enterprise and Standard).

How can we normalize the discovery model "Microsoft SQL Server 2016 (64-bit)" when some devices have the Standard edition and others have the Enterprise edition?

 

NurulaslahAnua_0-1709272056645.png

 

search the same devices from MS-SQL instances table

 

NurulaslahAnua_0-1709272459217.png

 

 

Also without edition our SAM ELP will be incorrect. Please help!

10 REPLIES 10

MikeW_SAMBeast
Giga Expert

Please check that the Discovery Patterns and Service Mapping plugin is as at the current release.