How to collect DNS Settings From Servers With SQL Report

How to collect DNS Settings From Servers With SQL Report  :

1. go to Administration and client Settings ==> Hardware inventory ==> set classes
2. Network Adapter configuration (Win32_NetworkAdapterConfiguration)
3. select   (Wins Secondary server  , Wins Primary server ,DNS Host Name , DNS Server Search order )
4. SQL Report 

SELECT  dbo.v_GS_SYSTEM.Name0 AS [System Name],
 dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operating System],
 dbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service Pack],
        dbo.v_GS_OPERATING_SYSTEM.InstallDate0 AS [Original OS Install Date],
 dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last Boot Time],
 dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.IPAddress0 AS [IP Address],
 dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.IPSubnet0 AS [Subnet Mask], 
 dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.DefaultIPGateway0 AS [Gateway],
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.DNSServerSearchOrder0 AS [DNS Servers],
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.WINSPrimaryServer0 AS [Pri WINS],
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.WINSSecondaryServer0 AS [Sec WINS],
        dbo.v_GS_PC_BIOS.SMBIOSBIOSVersion0 AS [System ROM Version], dbo.v_GS_PC_BIOS.ReleaseDate0 AS [System ROM Date]
FROM    dbo.v_GS_NETWORK_ADAPTER_CONFIGUR INNER JOIN
        dbo.v_GS_OPERATING_SYSTEM ON
        dbo.v_GS_NETWORK_ADAPTER_CONFIGUR.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID INNER JOIN
        dbo.v_GS_PC_BIOS ON dbo.v_GS_OPERATING_SYSTEM.ResourceID = dbo.v_GS_PC_BIOS.ResourceID INNER JOIN
        dbo.v_GS_SYSTEM ON dbo.v_GS_PC_BIOS.ResourceID = dbo.v_GS_SYSTEM.ResourceID
where  v_GS_SYSTEM.Name0 LIKE @variable and v_GS_NETWORK_ADAPTER_CONFIGUR.IPaddress0 is Not Null

Prompt

Name: Variable

Prompt Text: Collection ID

Provide a SQL Statement is checked

command = SELECT CollectionID, Name FROM v_Collection