There is a method to see which discovery models belong to a software model by opening the form of the software model and clicking "Show Matching Discovery Models".
This opens the list in a separate tab and depends on a client-callable script include called SAMPQueryAJAX.
What is the best way to show the relationship between all software models and their associated discovery models, preferably as a report? The options I thought about are: using a database view, having a calculated field in the discovery model table, or using Performance Analytics using a breakdown relation or a manual breakdown.
This isn't quite what your are looking for. This report shows all the software models that have entitlements that are missing discovery models. We do this all through a script include dynamically. For what you are looking to do a database view won't work. It needs to run as a query. I'd recommend scripting a scheduled job and populating a custom table. Precomputing the data is the only way to get any performance out of it. For our approach we didn't precompute the data and it's really slow even with adding database indexes.
Thanks Scott, a report like that would be very helpful. Could that be available is an out-of-box dashboard?
So far your suggestion of a custom table for keeping track of the many-to-many relationship between software models and discovery models seems like the only way. Additional findings below:
Seems like the software discovery models have a reference field to software models, though it is empty in every record.
The only documented way we have found to populate it is a UI action called "Match model" as mentioned in the article below, which is under ITSM asset management:
