Report for IPv6 enabled?

[dteague]

Does anyone have a report that will display what computers have IPv6 enabled? If I go to a computer, it will show both the IPv4 and the IPv6 address. For example, if I lookup a coputer and select Config-Network it displays 192.168.9.207 , fe80::e06d:22d1:4d77:626 as the IP address, but all the reports I see just show the IPv4 address.

We turn off IPv6, so I'm looking for some code that will just display the Computer and ones that have an IPv6 address.

Anyone have anything?

[dawnlowery]

What would the tables be for the current release of Lansweeper?

[Hemoco · Accepted solution]

dawnlowery wrote:
What would the tables be for the current release of Lansweeper?

You need tblAssets instead of tblComputers. The tblNetwork table is still the same.

[Hemoco]

You can also check for '%:%'
A single value should also return the ipv6 machines.

[dteague]

Thanks, I had thought about looking for the double colons, but when reviewing IPv6 specs, saw it was possible that it only had that when there were zeros in back to back fields.

That works, and we are disabling it on the few machines that were missed.

[Hemoco]

try this:

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblNetwork.ServiceName, tblNetwork.IPAddress
From tblComputers Inner Join
tblNetwork On tblComputers.Computername = tblNetwork.Computername
Where tblNetwork.IPAddress Like '%::%'