WINS/DNS for a Collection

SELECT  

	S.Name0 AS [System Name],

	OS.Caption0 AS [Operating System],

	OS.CSDVersion0 AS [Service Pack],

	OS.InstallDate0 AS [Original OS Install Date],

	OS.LastBootUpTime0 AS [Last Boot Time],

	NAC.IPAddress0 AS [IP Address],

	NAC.IPSubnet0 AS [Subnet Mask],  

	NAC.DefaultIPGateway0 AS [Gateway],

	NAC.DNSServerSearchOrder0 AS [DNS Servers],

	NAC.WINSPrimaryServer0 AS [Pri WINS],

	NAC.WINSSecondaryServer0 AS [Sec WINS],

	BIOS.SMBIOSBIOSVersion0 AS [System ROM Version], BIOS.ReleaseDate0 AS [System ROM Date]

 FROM

	dbo.v_GS_NETWORK_ADAPTER_CONFIGUR NAC 

	INNER JOIN dbo.v_GS_OPERATING_SYSTEM OS ON NAC.ResourceID = OS.ResourceID 

	INNER JOIN dbo.v_GS_PC_BIOS BIOS ON OS.ResourceID = BIOS.ResourceID 

	INNER JOIN dbo.v_GS_SYSTEM S ON BIOS.ResourceID = S.ResourceID

	join dbo.v_FullCollectionMembership_Valid FCM on NAC.ResourceID = FCM.ResourceID 

 where  

	FCM.CollectionID = @variable and 

	NAC.IPaddress0 is Not Null