→ 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: 
alex
Engaged Sweeper
Can you please help me with a report for duplicate ip adresses ?
1 ACCEPTED SOLUTION
Susan_A
Lansweeper Alumni
FYI for everyone: rename detection for Windows computers was added in Lansweeper 5.1.

View solution in original post

6 REPLIES 6
Susan_A
Lansweeper Alumni
FYI for everyone: rename detection for Windows computers was added in Lansweeper 5.1.
wgknowles
Engaged Sweeper II
Can you provide updated SQL Syntax for version 5?
Any chance of an automatic name change protocol in Version 5?
Hemoco
Lansweeper Alumni
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 Alumni
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
Engaged Sweeper
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
Lansweeper Alumni
Should this be a computer or device report?

New to Lansweeper?

Try Lansweeper For Free

Experience Lansweeper with your own data.
Sign up now for a 14-day free trial.

Try Now