PENDINGSCCM Custom Report problem

[jmaravig]

I've been tasked with creating a report that shows all products from one company. This company has multiple dev tools all with different names. I have to create a report that shows all machines with these tools installed and also with version ideally. I have typed in the following code so far but the results are blank. I'm suspecting my joins are incorrect. Can anyone shed some light on this or point me in the right direction please?
Thanks,
Jeff

select distinct
v_R_System.Netbios_Name0 AS [Computer Name],
v_GS_SoftwareProduct.CompanyName AS [Company Name],
v_GS_SoftwareProduct.ProductName AS [Product Name],
v_GS_SoftwareProduct.ProductVersion AS [Product Version],
v_R_User.Full_User_Name0 AS [Full User Name],
v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],
v_GS_COMPUTER_SYSTEM.UserName0 AS [UserName],
v_GS_COMPUTER_SYSTEM.Model0 AS [Model]
from v_R_System
LEFT join v_GS_OPERATING_SYSTEM v_GS_OPERATING_SYSTEM on (v_GS_OPERATING_SYSTEM.ResourceID = v_R_System.ResourceID)
LEFT join v_GS_SoftwareProduct on (v_GS_OPERATING_SYSTEM.ResourceID = v_GS_SoftwareProduct.ResourceID)
LEFT join v_GS_COMPUTER_SYSTEM v_GS_COMPUTER_SYSTEM on (v_GS_COMPUTER_SYSTEM.ResourceID = v_R_System.ResourceID)
LEFT join v_R_User on (v_R_User.User_Name0 = v_R_System.User_Name0)
LEFT join v_FullCollectionMembership v_FullCollectionMembership on (v_FullCollectionMembership.ResourceID = v_R_System.ResourceID)
Where v_FullCollectionMembership.CollectionID = u/CollectionID
Order by v_R_System.Netbios_Name0