Assets Scanned by SCCM

Get an Overview of 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 been scanned by SCCM. This provides a list of assets that have been scanned by SCCM regardless of whether they have been scanned by Lansweeper or not. This overview allows you to check why devices might not be scanned by Lansweeper or simply double-check data accuracy.

Assets scanned by SCCM

Assets Scanned by SCCM Query

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypename As Type,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  Coalesce(tblAssets.AssetName, tblSccmAsset.Name) As AssetName,
  Coalesce(tblAssets.Domain, tblSccmAsset.FullDomainName) As Domain,
  Coalesce(tblAssetCustom.Manufacturer, tblSccmAsset.PcManufacturer) As
  Manufacturer,
  Coalesce(tblAssetCustom.Model, tblSccmAsset.PcModel) As Model,
  tblSccmAsset.LastScanDate,
  Coalesce(tblAssets.IPAddress, tblSccmAsset.IpAddress) As IpAddress,
  tblAssets.Description,
  tblSccmSite.Name As SCCMSite,
  tblSccmServer.ServerName As SCCMServer
From tblSccmAsset
  Inner Join tblSccmSite On tblSccmSite.SccmSiteId = tblSccmAsset.SccmSiteId
  Inner Join tblSccmServer On tblSccmSite.SccmServerId =
    tblSccmServer.SccmServerId
  Left Join tblAssets On tblSccmAsset.AssetId = tblAssets.AssetID
  Left Join tblAssetCustom On tblAssets.AssetID = tblAssetCustom.AssetID
  Left Join tsysAssetTypes On tsysAssetTypes.AssetType = tblSccmAsset.Assettype
  Left Join tblState On tblState.State = tblAssetCustom.State
  Left Join tsysOS On tblAssets.OScode = tsysOS.OScode
Order By 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