→ Having trouble accessing our new support portal or creating a ticket? Please notify our team here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
dteague
Engaged Sweeper III
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?
1 ACCEPTED SOLUTION
Hemoco
Lansweeper Alumni
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.

View solution in original post

5 REPLIES 5
dawnlowery
Engaged Sweeper
What would the tables be for the current release of Lansweeper?
Hemoco
Lansweeper Alumni
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
Lansweeper Alumni
You can also check for '%:%'
A single value should also return the ipv6 machines.
dteague
Engaged Sweeper III
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
Lansweeper Alumni
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 '%::%'