→ Celebrate SysAdmin Day 2024 with Lansweeper Enter our Giveaway here

cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
abustraan
Engaged Sweeper III
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

3 REPLIES 3
abustraan
Engaged Sweeper III
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
Engaged Sweeper III
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
Lansweeper Alumni
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).

New to Lansweeper?

Try Lansweeper For Free

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

Try Now