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
Admin Script Editor
Admin Script Editor is an integrated scripting environment available free here at ITNinja

Share