05-06-2013 01:16 PM
05-07-2013 11:41 AM
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
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now