Products on a specific collection report

C

CJF

I need to know if there is a way that I can edit this query to display
All the products using a collection ID? I'm a newbie SMS guy and I've
been trying to create a query that works for the past couple of hours
and can't seem to get it to work.

I'm using the "Products on a specific computer" query (below) as a
template.


Select DISTINCT
SYS.Netbios_Name0,SYS.Resource_Domain_OR_Workgr0,SP.CompanyName,
SP.ProductName, SP.ProductVersion
FROM v_GS_SoftwareProduct SP
JOIN v_R_System SYS ON SP.ResourceID=SYS.ResourceID
Where SYS.Netbios_Name0 Like @variable
ORDER By SP.CompanyName, SP.ProductName, SP.ProductVersion


Any help appreciated.


Thank you!


Chris
 
Top