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.
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