Need urgent help creating a Report that matches Discovery Models to Entitlements

[FelixP]

Hello Community, 

I need your help. i was tasked to create a report that matches the two SAM tables cmdb_sw_discovery_model and alm_license. I don't know the dot-Walking route from cmdb_sam_discovery_model to alm_license could anyone of you who knows the route tell me how to do it ? my other idea was creating a connection on a unique identifyer aka a foreinkey but I don't know which column is the foreinkey that connects the Disocvery Models to the Entitlements. 

Thanks in advance for you help!

[dreinhardt · Accepted solution]

Hi @FelixP,

you could try the following. For each software entitlement you pick the linked software model. A software model is defined based on publisher, product, edition, version - the attributes the discovery model is using to get normalized.

You need a logic/script to walk through the discovery model table based on the software model parameters, to get all linked discovery models per software model linked to the entitlement. Maybe you could reuse the "Related link" action "Show matching discovery model"

What the use case for this report? 

Best, Dennis