cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
BrianMcNulty
Engaged Sweeper II

Hi,

We have an issue where duplicate assets are generating from a custom made report - we are running the latest Lansweeper classic version which is v11.4.0.3.

The tables for the report in question:

Thanks

Select Top (1000000) tblAssets.Lastseen As [Last successful scan],
tblAssets.Firstseen As [Created at],
tsysAssetTypes.AssetTypename As AssetType,
tblAssets.AssetID,
tblAssets.AssetName,
tblAssets.Domain,
Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
tblAssets.IPAddress,
tsysIPLocations.IPLocation,
tblAssetCustom.DNSName,
tblAssets.FQDN,
tblAssets.Mac As MACAddress,
tblAssetCustom.Model,
tblAssetCustom.Manufacturer,
tblAssets.Description,
tblAssetCustom.Serialnumber,
Case
When tsysOS.osname Is Not Null Then tsysOS.osname
When tblLinuxSystem.OSRelease Is Not Null Then tblLinuxSystem.OSRelease
When tblMacOSInfo.SystemVersion Is Not Null Then tblMacOSInfo.SystemVersion
When tsysAssetTypes.AssetType = -1 And Coalesce(tblSccmAsset.OsCaption,
tblSccmAsset.OperatingSystemNameandVersion, '') <> '' Then
Coalesce(tblSccmAsset.OsCaption,
tblSccmAsset.OperatingSystemNameandVersion)
Else ''
End As OS,
tblAssetCustom.OrderNumber,
tblAssetCustom.PurchaseDate,
tblAssetCustom.Warrantydate,
tblAssetCustom.Custom1,
tblAssetCustom.Custom2,
tblAssetCustom.Custom3,
tblAssetCustom.Custom4,
tblAssetCustom.Custom5,
tblAssets.Uptime
From tblAssets
Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
Inner Join tsysIPLocations On tsysIPLocations.LocationID =
tblAssets.LocationID
Left Outer Join tblADComputers On tblAssets.AssetID = tblADComputers.AssetID
Inner Join tblState On tblState.State = tblAssetCustom.State
Left Outer Join tblLinuxSystem On tblAssets.AssetID = tblLinuxSystem.AssetID
Left Outer Join tsysOS On tblAssets.OScode = tsysOS.OScode
Left Outer Join tblMacOSInfo On tblAssets.AssetID = tblMacOSInfo.AssetID
Left Outer Join tblSccmAsset On tblAssets.AssetID = tblSccmAsset.AssetId
Order By tblAssets.AssetName

 

2 REPLIES 2
BrianMcNulty
Engaged Sweeper II

Hi,

 

Bumping for any assistance.

 

Kind regards,

 

Brian

Jacob_H
Lansweeper Employee
Lansweeper Employee

(I'm not official support) -  the report looks good to me - what type of duplicate assets are you seeing?