08-12-2024 06:16 PM
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
08-16-2024 03:47 PM
Hi,
Bumping for any assistance.
Kind regards,
Brian
08-17-2024 03:53 AM
(I'm not official support) - the report looks good to me - what type of duplicate assets are you seeing?
Experience Lansweeper with your own data. Sign up now for a 14-day free trial.
Try Now