Assets Scanned by Both Lansweeper and SCCM

Get an Overview of Lansweeper and SCCM Scanned Devices

System Center Configuration Manager (SCCM) or previously Systems Management Server (SMS) is a Microsoft product to manage devices and applications across enterprises. Lansweeper integrates with SCCM to retrieve asset data and ensure you have a complete view of everything that is in your network.

This overview lists all the devices which have both been scanned by SCCM and Lansweeper. This provides a nice list of assets that overlap as well as a good way to compare the data retrieved by both Lansweeper and SCCM to ensure that your data is accurate.

Scanned by both LS and SCCM

Assets Only Scanned by SCCM Query

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypename As Type,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.AssetName,
  tblAssets.Domain,
  tblAssets.Username,
  tblAssets.Userdomain,
  tblAssets.IPAddress,
  tblAssets.Description,
  tblAssetCustom.Manufacturer,
  tblAssetCustom.Model,
  tblAssetCustom.Location,
  Case (tblAssets.Assettype)
    When -1 Then tsysOS.OSname
    When 11 Then tblLinuxSystem.OSRelease
    When 13 Then tblMacOSInfo.SystemVersion
    Else ''
  End As OS,
  tblAssets.SP As SP,
  tblAssets.Firstseen,
  tblAssets.Lastseen
From tblAssets
  Left Join tblSccmAsset On tblAssets.AssetID = tblSccmAsset.AssetId
  Inner Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Inner Join tsysAssetTypes On tsysAssetTypes.AssetType = tblAssets.Assettype
  Inner Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
  Left Join tblLinuxSystem On tblLinuxSystem.AssetID = tblAssets.AssetID
  Left Join tblMacOSInfo On tblMacOSInfo.AssetID = tblAssets.AssetID
Where tblAssets.ScannedBy & 3 = 3
Order By tblAssets.ScannedBy Desc,
  tblAssets.Assettype,
  tblAssets.AssetName

Run This Report in 3 Easy Steps

Download-Install-Lansweeper

1. Download & Install Lansweeper

Save-and-Run-the-Report

3. Run the Report

Download Lansweeper to Run this Report

Harness the Power of Reporting