Microsoft SAM Properties

[Cairns]

Hi all,

Can anyone else see these properties within their SAM properties page:

• Ratio of the entitlement cost of a Microsoft SQL Server Standard with Software Assurance to the cost of Microsoft SQL Server Enterprise with Software Assurance (com.snc.samp.sqlserver.standard_sa.to.enterprise_sa.cost.ratio)
• Ratio of the entitlement cost of a Microsoft Software Assurance entitlement to the cost of a Microsoft Non-Software Assurance entitlement (com.snc.samp.ms.sa.to.nonsa.cost.ratio)

We have a couple of customers who recently upgraded to Yokohama and Zurich and we can no longer see these properties listed.
Does anyone know if these have been moved elsewhere? I cannot find any documentation mentioning what has happened to these properties.

Thanks in advance.

[MaxMixali]

Hi hope that can help:

New Location

Internally stored inside:

•com.snc.samp.ms.sql_server plugin XML

--SAM Pro core calculation scripts

--SQL Server optimization jobs

--“SQL Server License Recommendation” logic

You can verify this in:

System Definition → Scripts

Search for:

--MS SQL Enterprise ratio

--SA vs Non-SA ratio

--costRatio

Check in your instance

1)Go to: All -> Software Asset Management -> Administration -> Properties -> You will NOT find them.

2.Search in system properties directly: 

   sys_properties.list -> They no longer exist.

3.Check XML of plugin: 

        com.snc.samp.ms_sql_server_license -> You will see hardcoded ratio mappings.

[Cairns]

Hi @MaxMixali ,

Thank you for your response.

I am still able to see both these properties in the sys_properties table.

Could you verify which script table you are seeing this in on your end.

[MaxMixali]

These two SAM cost-ratio properties are read by code stored in:

Function
SQL Server Standard → Enterprise SA cost ratio
Microsoft SA → Non-SA cost ratio
SQL server reconciliation logic
Normalization and downgrade/upgrade logic

Location
Script Includes (sys_script_include) under the SAM Microsoft Licensing engine
Script Includes (sys_script_include) under the SAM entitlement evaluator
Business Rules (sys_script) for SAMP license reconciliation
SAMP MS Scripts, specifically in SoftwareAsset and MsSQLServerLicenseEvaluation* includes