Duplicate ip adress

[alex]

Can you please help me with a report for duplicate ip adresses ?

[Susan_A · Accepted solution]

FYI for everyone: rename detection for Windows computers was added in Lansweeper 5.1.

[wgknowles]

Can you provide updated SQL Syntax for version 5?
Any chance of an automatic name change protocol in Version 5?

[Hemoco]

wgknowles wrote:
Can you provide updated SQL Syntax for version 5?

Please use the report below.

Select Top 1000000 tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tsysAssetTypes.AssetTypename,
tsysAssetTypes.AssetTypeIcon10 As icon,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Inner Join (Select Top 1000000 Count(tblAssets.AssetID) As IPCount,
tblAssets.IPAddress
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Where tblAssetCustom.State = 1
Group By tblAssets.IPAddress
Having Count(tblAssets.AssetID) > 1) DuplicateIP On tblAssets.IPAddress =
DuplicateIP.IPAddress
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Where tblAssetCustom.State = 1
Order By tblAssets.IPNumeric

wgknowles wrote:
Any chance of an automatic name change protocol in Version 5?

A procedure based on MAC address is planned for a future update, but we do not yet have a release date for this feature.

[Hemoco]

Lansweeper uses the combination domain name\computer name as a unique identifier.
Currently, the correct way to rename a computer is to first rename it in Lansweeper and then rename the machine itself. You can rename a computer in the Lansweeper configuration console under Lansweeper\Scanned Computers by right-clicking on the machine and selecting “Rename computer”. The computer’s database entry will then continue to be updated as usual.
We have considered implementing an automatic name change protocol, but have yet to find a solution that works 100% of the time.

To find machines that have already been duplicated, please try the report below.

Select tblComputers.Computername, tblComputers.ComputerUnique,
tblComputers.Domain, tblComputers.Firstseen, tblComputers.Lastseen,
tblComputers.LastknownIP
From tblComputers Inner Join
(Select Count(tblComputers.Computername) As [IP Count],
tblComputers.LastknownIP
From tblComputers
Group By tblComputers.LastknownIP
Having Count(tblComputers.Computername) > 1) DuplicateIP On
DuplicateIP.LastknownIP = tblComputers.LastknownIP
Order By tblComputers.ComputerUnique

[alex]

A computer report.
If i join a computer to a domain or i rename it, lansweeper add it as a new computer. Since the ip adress wil not change, this report will hlep me quickly identify renamed computers and delete the ones with the old name.

[Hemoco]

Should this be a computer or device report?