Duplicate Scanned/NotScanned Assets List

[Raviraj]

Hello Team,
There are few assets which were shifted from Domain A to Domain B as these assets were not being scanned on the earlier Domain (i.e Domain A). Now I have 2 instances of the same asset but on different Domains.
I need a Full list of all such Duplicate Assets Which are either Scanned or Not Scanned.
Kindly guide !

[Hemoco]

Please use the report below to list machines that exist in both domains. Replace YourDomain1 with the NetBIOS name of the first domain and YourDomain2 with the NetBIOS name of the second domain.

It’s important to note that Lansweeper cannot detect computer name or domain name changes. Currently, the correct way to rename a computer or move it to a different domain is to first rename/move it in Lansweeper and then rename/move the machine itself. You can rename/move a computer by browsing to its Lansweeper webpage and then hitting the Edit Asset button. When the machine is rescanned, its existing database entry will then simply be updated. If you don’t rename/move the machine in Lansweeper first, a new database entry will be generated for it.

We've been considering implementing an automatic rename procedure based on MAC address, but duplicate MACs are not an uncommon occurrence, particularly on virtual machines.

Select Top 1000000 tsysOS.Image As icon,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen,
SubQuery1.AssetName As DuplicateName,
SubQuery1.Domain As DuplicateDomain,
SubQuery1.IPAddress As DuplicateIP,
SubQuery1.Firstseen As DuplicateFirstSeen,
SubQuery1.Lastseen As DuplicateLastSeen
From tblAssets
Inner Join tsysOS On tsysOS.OScode = tblAssets.OScode
Inner Join (Select tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
tblAssets.IPAddress,
tblAssets.Firstseen,
tblAssets.Lastseen
From tblAssets
Where tblAssets.Domain = 'YourDomain1') SubQuery1 On SubQuery1.AssetName =
tblAssets.AssetName
Where tblAssets.Domain = 'YourDomain2'
Order By tblAssets.Domain,
tblAssets.AssetName