Duplicate Asset name / Machine name Detection

[dmangubat]

Is there's a way for Lansweeper 5305 to determine if an assetname or machine name is already in the database? Because we are now facing some issues having duplicate assetnames (not MAC add).

Scenario: If I will add new asset to Lansweeper, it will not tell me that the assetname I used is already in the system resulting to duplicate asset name.

Is there's a way to prevent this?



Thank you so much in advance.

[dmangubat]

Thank you so much for replying! 🙂

[Susan_A · Accepted solution]

FYI: you can use the report below to track down assets that share the same asset name.

As explained by Daniel and in the knowledge base as well, Lansweeper will never use *just* an asset name to uniquely identify an asset, which is why reusing the same name will not generate errors or warnings. A Windows computer's ID is its computer name/domain name combination; a non-Windows device's ID is its MAC (if found), IP (if a MAC is not found) or a random string (if the asset is manually generated without a MAC or IP).

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

[Daniel_B]

The easiest way would be to just enter the asset name you would like to check into the web console search bar and see if you receive any assets with this name. Lansweeper won't allow two computers with the same combination of domain name and hostname (that is, asset name). But if only the asset name is the same as another asset, there is no function to prevent adding the second asset.

You could use a report as well to search for assets, like the following example:

Select tblAssets.AssetID,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.IPAddress
From tblAssets
Where tblAssets.AssetName In ('AssetName1', 'AssetName2', 'AssetName3')

[dmangubat]

Hi Daniel.B,

Thank you for replying.

Actually Unique IDs are not being duplicated, I don't have an issue with it.

My problem is the Asset Name / Machine Name or Asset Alias. It's that when I tried to put the alias to an asset It seems that LS can't determine if the Asset Alias or Asset Name already exist causing some asset name duplication. Even our organization followed a rule in naming assets still sometimes supports from other offices made a mistake in naming their assets, not knowing that the name they used is already being used in other region or offices.

Thank you! 🙂

[Daniel_B]

This depends on the asset type. You can find an explanation on how Lansweeper uniquely identifies assets in this KB article. Duplicate UniqueIDs won't be allowed. You might have Windows computers from a different domain but with the same host name, or Windows computers which have duplicate entries because they weren't successfully scanned while being connected to WiFi or VPN. This would need to be resolved at the origin (open required ports for scanning).

If this doesn't explain your issue, could you describe in more detail which assets are getting duplicated in your case.