Scripting

I'm trying to create a Report that will show the machine name, ip address, ip subnet, OS, and OS SP of all machines in a collection (prompt). This is what I've got, but it doesnt work.

SELECT v_R_System.Name0, v_GS_OPERATING_SYSTEM.Caption0, v_GS_OPERATING_SYSTEM.CSDVersion0, v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0

FROM v_R_System JOIN v_GS_OPERATING_SYSTEM on v_R_System.ResourceID = v_GS_OPERATING_SYSTEM.ResourceID JOIN

v_GS_NETWORK_ADAPTER_CONFIGUR on v_R_System.ResourceID = v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID join 

v_FullCollectionMembership FCM on FCM.ResourceID = v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID

WHERE FCM.CollectionID = @CollID