Limit the software installation data in SAM

[Ashupakasma]

Hello Experts,

I want to limit the data on the Software installation table (cmdb_sam_sw_install)

(2720962 total Software Installations),

but I want to limit the data on this table and only want to see the software that has defined metrics.

If I group them by "license metric" result, I can see that the license metric result: (empty) (2694204) does not define any metric.

Now my question is - I want to see the data which having license metrics defined only, how can I achieve it? Please guide me on this.

Why I want to achieve this because during reconciliation it took a lot of time to produce the result, Yesterday I ran the reconciliation and it took 18 Hrs to complete the recon.

@mikew_samexpert  @Victor Paredes @Victor Paredes1 

[Community Alums]

Query Business rule will help in restricting records that you want to see but I am not sure if it will help reconciliation run only on these records.

[dreinhardt]

Hi @Ashupakasma,

I course 18hrs to perform a whole reconcile is to much! I'm workin with customer who managing  100+M software installations with focus on TOP 5 publishers (MSFT, Oracle, IBM, SAP, VMware) and the whole reconcile is about 5hrs.

I would recommend to review the reconciliation steps in detail to get a better feeling about the long runs in that process

- Navigate to All > samp_recon_progress_summary.LIST

- Order by the latest "Reconciliation Result"

- Open "Latest Order" Link related to the result

- Here you can review the steps per publishers as aggregated times

In general, the amout of data included into the reconciliation process is based on your software models and the mapped discovery models. Based on this, the results of "metrics results" can be different for each reconcile.

First, please review the times and get in touch with the support to troubleshoot these. If you've enables the system property to create software models for each licensable discovery model, I would suggest to disable the property and remove all not needed models and keep the ones in scope.

Best, Dennis

[mikew_samexpert]

Totally agree with the statements in your last paragraph, Dennis!

[Ashupakasma]

Hi @dreinhardt ,

Thanks for this explanation. I will surely try the solution you have provided. But as of now we have raised HI support case with ServiceNow and waiting for their input on this. Will let you know, on the progress.