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

1 Comment   [ + ] Show Comment

Comments

  • What is your error output/message?
Please log in to comment

There are no answers at this time

Answers

Answer this question or Comment on this question for clarity