Duplicate Entries after moving to a new domain

[abustraan]

I recently created a new domain. Moved all of the assets to the new domain. And Everything looks great until I run several of my reports. they list all assets twice:

Select Top 1000000 tblAssets.AssetID,
tblADusers.Lastname,
tblADusers.Firstname,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
Case tblSoftware.softwareVersion When '17.0.416.0' Then 'Original'
When '17.0.476.0' Then 'SP1' When '17.0.501.0' Then 'SP2'
When '17.0.1099.0' Then '17.1' When '17.0.1117.0' Then '17.2' Else 'Unknown'
End As [Service Pack],
tblSoftwareUni.SoftwarePublisher As Publisher,
tsysOS.Image As icon,
tsysOS.OSname
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where (tblSoftwareUni.softwareName Like 'Autodesk Revit Architecture 2017' And
tblSoftwareUni.softwareName Like 'Autodesk Revit MEP 2017' And
tblAssetCustom.State = 1) Or
(tblSoftwareUni.softwareName Like 'Autodesk Revit 2017' And
tblSoftware.softwareVersion Like '17.%')
Order By Software,
tblAssets.AssetName,
Version

[abustraan]

Opened the SQL Database and did a query for users with the old domain. Is there a way to truncate those via Lansweeper, or do I need to do it within SQL?

thanks!

[abustraan]

Thank you for the reply. Unfortunately, I already had the checkbox ticked.

I've added some more versions of the software so here's my updated report:

Select Top 1000000 tblAssets.AssetID,
tblADusers.Lastname,
tblADusers.Firstname,
tblAssets.AssetUnique,
tblAssets.Domain,
tblSoftwareUni.softwareName As Software,
tblSoftware.softwareVersion As Version,
Case tblSoftware.softwareVersion When '17.0.416.0' Then 'Original'
When '17.0.476.0' Then 'SP1' When '17.0.501.0' Then 'SP2'
When '17.0.1099.0' Then '17.1' When '17.0.1117.0' Then '17.2'
When '17.0.1128.0' Then '17.2.1' Else 'Unknown' End As [Service Pack],
tblSoftwareUni.SoftwarePublisher As Publisher,
tsysOS.Image As icon,
tsysOS.OSname
From tblSoftware
Inner Join tblAssets On tblSoftware.AssetID = tblAssets.AssetID
Inner Join tblSoftwareUni On tblSoftware.softID = tblSoftwareUni.SoftID
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysOS On tblAssets.OScode = tsysOS.OScode
Inner Join tblADusers On tblADusers.Username = tblAssets.Username
Where (tblSoftwareUni.softwareName Like 'Autodesk Revit Architecture 2017' And
tblSoftwareUni.softwareName Like 'Autodesk Revit MEP 2017' And
tblAssetCustom.State = 1) Or
(tblSoftwareUni.softwareName Like 'Autodesk Revit 2017' And
tblSoftware.softwareVersion Like '17.%')
Order By Software,
tblAssets.AssetName,
Version

[Bruce_B]

It's likely that all of your Windows assets have duplicated if you changed the domain. Windows assets get uniquely identified in Lansweeper based on a combination of NetBIOS domain name and NetBIOS computer name, as further explained in this article.

To merge these assets you can use the rename detection feature though, which merges Windows computer assets that have the same serial number, model and MAC address. This option is explained here and can be activated under Configuration\Server Options (scroll down to the bottom).