![]() ![]() Left Join tblAssets On tblSccmAsset.AssetId = tblAssets.AssetID Inner Join tblSccmServer On tblSccmSite.SccmServerId = Inner Join tblSccmSite On tblSccmSite.SccmSiteId = tblSccmAsset.SccmSiteId This overview allows you to check why devices might not be scanned by Lansweeper or simply double-check data accuracy.Īssets Scanned by SCCM Query Select Top 1000000 tblAssets.AssetID,Ĭoalesce(tsysOS.Image, tsysAssetTypes.AssetTypeIcon10) As icon,Ĭoalesce(tblAssets.AssetName, tblSccmAsset.Name) As AssetName,Ĭoalesce(tblAssets.Domain, tblSccmAsset.FullDomainName) As Domain,Ĭoalesce(tblAssetCustom.Manufacturer, tblSccmAsset.PcManufacturer) AsĬoalesce(tblAssetCustom.Model, tblSccmAsset.PcModel) As Model,Ĭoalesce(tblAssets.IPAddress, tblSccmAsset.IpAddress) As IpAddress, 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 lists all the devices which have been scanned by SCCM. Lansweeper integrates with SCCM to retrieve asset data and ensure you have a complete view of everything that is in your network. System Center Configuration Manager (SCCM) or previously Systems Management Server (SMS) is a Microsoft product to manage devices and applications across enterprises.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |