SELECT 
	rsc.Name
	,rsc.Guid
	,'"E:\Program Files\Altiris\Notification Server\Bin\Tools\importexportutil.exe" /export /q ' +cast(rsc.Guid as varchar(50)) + ' c:\temp\Components\' [ComponentExport]
	,RM_ResourceSoftware_Product.Name [Product Name]
	,RM_ResourceSoftware_Product.[Guid] AS [SoftwareProductGuid]
	,'"E:\Program Files\Altiris\Notification Server\Bin\Tools\importexportutil.exe" /export /q ' +cast(RM_ResourceSoftware_Product.[Guid] as varchar(50)) + ' c:\temp\Products\' [ProductExport]
	,vi.Name [License Name]
	,l.Guid [License Guid]
	,'"E:\Program Files\Altiris\Notification Server\Bin\Tools\importexportutil.exe" /export /q ' +cast(l.Guid as varchar(50)) + ' c:\temp\Licenses\' [LicenseExport]
	,vip.Name [Purchase Order Name]
	,sp.Guid [Purchase Order Guid]
	,'"E:\Program Files\Altiris\Notification Server\Bin\Tools\importexportutil.exe" /export /q ' +cast(sp.Guid as varchar(50)) + ' c:\temp\PO\' [POExport]
	,spd.Quantity [LicenseCount]
	,spd.[Purchase Date]
	,sld.[Maintenance Renewal Cost]
	,sld.[Support Renewal Cost]
	,sld.[License Type]
,newId() [RuleGuid]
FROM
	ResourceAssociation 
INNER JOIN 
	vRM_Software_License l
	ON ResourceAssociation.ParentResourceGuid = l.Guid 
INNER JOIN vItem vi
	ON l.Guid = vi.Guid
INNER JOIN 
	Inv_Software_License_Details sld
	ON l.Guid = sld._ResourceGuid
INNER JOIN 
	RM_ResourceSoftware_Product 
	ON ResourceAssociation.ChildResourceGuid = RM_ResourceSoftware_Product.Guid
LEFT JOIN 
	ResourceAssociation raL
	ON raL.ParentResourceGuid = l.Guid
	AND raL.ResourceAssociationTypeGuid = 'f7002a49-11a6-44ea-af19-2e06632ff831'
LEFT JOIN
	vRM_Software_Purchase sp
	ON sp.Guid = raL.ChildResourceGuid
LEFT JOIN
	vItem vip
	ON sp.Guid = vip.Guid
LEFT JOIN
	Inv_Software_Purchase_Details spd
	ON spd._ResourceGuid = sp.Guid
LEFT JOIN
	ResourceAssociation raC
	ON RM_ResourceSoftware_Product.Guid = raC.ParentResourceGuid
	AND raC.ResourceAssociationTypeGuid = '9D67B0C6-BEFF-4FCD-86C1-4A40028FE483'
LEFT JOIN
	RM_ResourceSoftware_Component rsC
	ON raC.ChildResourceGuid = rsC.Guid

WHERE
       (ResourceAssociation.ResourceAssociationTypeGuid = '59c323aa-e616-489a-bd30-a671f4f6c8c8')