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

Leave a Reply

Your email address will not be published. Required fields are marked *