TRY NOW

Assets Only Scanned by SCCM Audit

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 audit shows all devices which have only been scanned by SCCM. As a result, these assets will only have limited information and if scanned by Lansweeper, additional information could be retrieved. This allows you to identify which devices are not scanned by Lansweeper, so you can add them to a Lansweeper scanning target to retrieve the detailed information using Lansweeper. Assets only scanned by SCCM

Assets Only 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
Where (tblSccmAsset.AssetId Is Null) Or
  (tblAssets.ScannedBy = 2)
Order By tblAssets.Assettype,
  tblAssets.AssetName

Show

Hide

NO CREDIT CARD REQUIRED

Ready to get started?
You’ll be up and running in no time.

Explore all our features, free for 14 days.