Compliance delta detection between reconciliation executions

Lionel Falk
Tera Contributor

Dear Community,

 

In there a way to identify in SAM Pro the delta between reconciliation runs to identifies the movements in the  Product Results, Software Models Results and License Metric Results? Other than exporting a Software license compliance position report between each reconciliation run and comparing them?

 

It is understood that between each reconciliation, SAM Pro can add or remove products, just like models. However it would be useful to identify which of these elements have changed and also their evolution of their compliance flag.

 

Thank you.

 

 

 

2 REPLIES 2

dreinhardt
Tera Sage

Hi @Lionel Falk,

I would suggest the following tables to get an overview about the software model results per reconciliation run, and with the help of e.g., PowerBI or scripts you should be able to build your delta report

 

samp_reconciliation_result

- overview about all recons (latest, past) to identify the reconciliation results in scope (RR number)

dreinhardt_0-1732133238569.png

 

samp_software_model_result

- includes all software models results & additional information per reconciliation result (RR)

dreinhardt_1-1732133434174.png

 

I hope these two tables contains enough details to compare software model or publisher results between multiple recons.

 

Best, Dennis

Should my response prove helpful, please consider marking it as the Accepted Solution/Helpful to assist closing this thread.

Lionel Falk
Tera Contributor

Thank you Dennis for this reply.

 

If I understand correctly, the samp_software_model_result is also displayed in the License usage of a specific publisher, right? And so it represents the current compliance status.

I am rather looking for the delta between the last 2 reconciliations, for example, in terms of changes occurring in software products, software models and software model compliance status.  So for a publisher with many software models, like Microsoft, the focus can be quickly set on the models that have changed their compliance status.

 

The current tedious and manual process in place relies on Software license compliance position reports extractions, and a comparison between 2 extracted reported outside of SAMP. So is there another, ideally in SAMP, to get this delta?