TRY NOW

Lansweeper versus SCCM Assets

SCCM

Get an Overview of Lansweeper and SCCM 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 report shows all of the assets within Lansweeper and the source of the asset data whether it is Lansweeper, SCCM or both. This can help in identifying missing devices or just give you an overview of where your data originated from. Lansweeper vs SCCM assets

Lansweeper versus SCCM Assets Query

Select Top 1000000 tblAssets.AssetID,
  tsysAssetTypes.AssetTypename As Type,
  Coalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,
  tblAssets.AssetName,
  Case
    When tblAssets.ScannedBy & 3 = 3 Then 'LS & SCCM'
    When tblAssets.ScannedBy & 2 = 2 Then 'SCCM'
    When tblAssets.ScannedBy & 1 = 1 Then 'LS'
    Else ''
  End As ScannedBy,
  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
Order By tblAssets.ScannedBy Desc,
  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.