Software Models without any discovery model and vice versa

[Gowthaman Jayab]

Hi All

Background :We are using SAM Pro and customer have two different teams one for managing the catalogs and other for license management. Both these teams create software models independently and in silo. This has resulted in lot of potential duplicates of software models and blocker for automation. Now we have to consolidate/remove the software models and define a process for creating the software models so that no such issue occurs in future. As part of this initiative, I have the below requirements.

• Report all the software models that don't have any associated discovery models.
• Report all the discovery models which don't have any related software models.

Since this data is not readily available as the relationship is established via DMAPs, I proposed a solution of creating a UI page however would like to understand if there are any better ways to do this. Please suggest.

Thanks in advance.

[Dash2]

If the request is to create reports

• Report all the software models that don't have any associated discovery models.
  
  You can create this report via regular reporting.

Just add a related list filter. The discovery model is a related record to the software model. Set the Equal to 0 (no discovery model). 

• Report all the discovery models which don't have any related software models.

Hope this helps

[Dash2]

If the request is to create reports

• Report all the software models that don't have any associated discovery models.
  
  You can create this report via regular reporting.

Just add a related list filter. The discovery model is a related record to the software model. Set the Equal to 0 (no discovery model). 

Then select the discovery model table from the related list

The logic here is that show all software models where the discovery model is 0. 

• Report all the discovery models which don't have any related software models

Then from the main filter, select software model is empty

Hope this helps

[Gowthaman Jayab]

I think this may work with SAM foundation and not with SAM Pro as the software model field in discovery model doesn't hold any value due to n-n relationships. SAM Pro uses D map for this.

[Scott Halverso1]

The first report is a bit challenging but we've done it by having a report run using a script include that returns sys_ids of the models that meet the criteria.  Below is the logic we used, we limited it to software models where we had entitlements related.

1. Filter down to SW Models where we have an entitlement
2. Then taking the publisher, product, version, edition, etc, values and query to see if there is at least one discovery model that matches, if not return that software model.

We haven't done the second report as we haven't seen the value.   The system runs a scheduled job that cleans up SW Discovery models.  The job is called "SAM - Delete Discovery Models if there are no related Installations". Plus a valid use case to have a SW discovery models and software model is for unlicensed software (unless you have turned on to automatically to make models).