Video Screencast Help
Give us your opinion and win with Symantec! Please help us by taking this survey to tell us about your experience with Symantec Connect, so that we can continue to grow and improve.  Take the survey.

reports

Created: 13 Mar 2013 | 2 comments

good afternoon everyone

I need know how get product type, or if someone knows where is it (in that table)

thanks in advance

Comments 2 CommentsJump to latest comment

The Gaffer's picture

The product type is associated to a software product via a resource association. Here's a query which returns the software products and their types in the database.

select p.Guid [_ItemGuid]
,p.Name [Software Product]
,t.Name [Software Type]
from dbo.vRM_Software_Product_Item p
left outer join ResourceAssociation ra
on p.Guid = ra.ParentResourceGuid and ra.ResourceAssociationTypeGuid='ae4dbdf7-457b-4828-a83e-b64b91ae0e87'
left outer join [RM_ResourceSoftware_Type] t
on t.Guid = ra.ChildResourceGuid
order by 2
diana.mesta's picture

thank you very much the gaffer =)