Symantec Management Platform (Notification Server)

HI All,

I am trying to publish a web page with all of our deliverable software. 

I would like to get the following data  (same data as on the Properties page of a Software release)

Software Release Name         

Software Vendor Name

Software Version

I am struggling with the SQL to go from Software release to company / version

from searching the tables it seems that company data is stored in  RM_ResourceCompany and software release data is in Inv_Software_Release,  I have not been able to locate version data nor can I find any way to join release to company.

The version is in an inventory table and the company is assigned via a resource association. To find this out, we can view the Software Release in the Resource Manager:

In the Resource Manager window, we can see that there's a resource association we're probably interested in:

Resource associations are defined through a parent-child relationship in the ResourceAssociation table, so somwehere in there is a relationship between the Software Resource (Inv_Software_Release or vRM_Software_Release_Item) and the Guid of a record in RM_ResourceCompany (or vRM_Company_Item). That relationship with have a ResourceAssociationTypeGuid of the "Software Component to Company" Resource Association's Guid. You can find the value in Settings.

To view the full list of resource associations, you can use the Tasks -/ Resource Association Grid feature, but we already know the version is in Inventory, so let's look at View -/ Inventory.

There's not a lot of inventory for a Software Resource, but the Software Component data class seems to have the version information:

The Status tab tells us that the table is Inv_Software_Component, so a join to the _ResourceGuid column in that table should do the trick.

I know I didn't just give you the answer, but I hope this helps.