→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
SolusMIB
Engaged Sweeper II
We've had a problem with some HP machines and IPv6. Seems there is a bug with the sleep function in some HP desktops that creates a network storm. Normal broadcast traffic on my network, according to wireshark, is usually around 10,000 lines a minute. During an HP storm it is 1,250,000 lines per 30 seconds. That's just two machines bugging out.
It would be awesome to have a report that would just list machines that are IPv6 active. I looked around and didn't find anything relating.

1 ACCEPTED SOLUTION
Daniel_B
Lansweeper Alumni
There is no field which explicitly documents if IPv6 is enabled, but network adapters will have an IP in IPv6 format if it is enabled. The following report lists network interfaces from Windows computers that have an IPv6 address:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.Image As icon,
tsysOS.OSname,
tblNetwork.Description As [Network interface],
tblNetwork.IPAddress As IPAddresses
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblNetwork.IPAddress Like '%:%' And tblAssetCustom.State = 1 And
tblNetwork.IPEnabled = 1
Order By tblAssets.AssetName,
[Network interface]

View solution in original post

3 REPLIES 3
Mathb
Engaged Sweeper
I had the exact same issue this morning as described by requester. DHCP services fell down on their knees and IPv6 enabled desktops bombarded the core switchs with DHCP request flooding them rendering them unresponsive.. hey ! a neat DELL stack on it's knees... unbelievable. That report should be built-in cuz sometimes IPv6 is a pain.

As a request : Can IPv6 be searchable in the "search fied" at the top of the page ?
SolusMIB
Engaged Sweeper II
GOOD STUFF!! THANK YOU!
Daniel_B
Lansweeper Alumni
There is no field which explicitly documents if IPv6 is enabled, but network adapters will have an IP in IPv6 format if it is enabled. The following report lists network interfaces from Windows computers that have an IPv6 address:

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.IPAddress,
tblAssets.Lastseen,
tsysOS.Image As icon,
tsysOS.OSname,
tblNetwork.Description As [Network interface],
tblNetwork.IPAddress As IPAddresses
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblNetwork On tblAssets.AssetID = tblNetwork.AssetID
Where tblNetwork.IPAddress Like '%:%' And tblAssetCustom.State = 1 And
tblNetwork.IPEnabled = 1
Order By tblAssets.AssetName,
[Network interface]