Symantec Management Platform (Notification Server)

I'm only manage to create an individual solution report using 

DECLARE @Product AS NVARCHAR (200)
--Enter the guid of the solution or its name.  
--If it is only part of the guid or name make sure to use % symbals as needed. 
SET @Product = 'Altiris Patch Management Solution'

SELECT vp.Name, vc.Name, vc.Domain, liu.* 
FROM LicenseInUse liu
JOIN vProduct vp ON vp.Guid = liu.LicensingPolicyGuid
JOIN vComputer vc ON vc.Guid = liu.ResourceGuid
WHERE vp.Name LIKE @Product OR vp.Guid LIKE @Product
ORDER BY vp.Name, vc.Name

but how can i create a SQL report like table below

Something like this?

	SELECT 
	vc.Name [Computer Name]
	,vc.[OS Name]
	,Case When Exists (
			Select 1 from LicenseInUse liu where (liu.LicensingPolicyGuid = 'C6D19F78-1434-49AC-BEC8-D18255E99F57' and vc.Guid = liu.ResourceGuid))
		Then 'Yes'
		Else 'No'
	End as [Patch Management]
	,Case When Exists (
			Select 1 from LicenseInUse liu where (liu.LicensingPolicyGuid = 'CD39B720-F871-11D2-8643-00104B74A9DF' and vc.Guid = liu.ResourceGuid))
		Then 'Yes'
		Else 'No'
	End as [Inventory Solution]
	,Case When Exists (
			Select 1 from LicenseInUse liu where (liu.LicensingPolicyGuid = 'AD3F5980-D9E9-11D3-A318-0008C7A09198' and vc.Guid = liu.ResourceGuid))
		Then 'Yes'
		Else 'No'
	End as [Software Management Solution]
	FROM
	vComputer vc
	where vc.IsManaged = 1 
	order by vc.Name

Hi MonitorMan, thanks a lot