Hi,
The SCCM connector excludes certain network adapters. Adapters without MAC address are excluded, for instance. This is the internal query used by SCSM to import data from the staging tables to the classes. Perhaps it helps you narrow down your issue.
SELECT N.Lfx_RowId AS Lfx_RowId,
N.Lfx_SourceId,
(case
when isnull(N.Lfx_Timestamp,'1900-01-01') > isnull(NC.Lfx_Timestamp,'1900-01-01')
then N.Lfx_Timestamp
else NC.Lfx_Timestamp end) AS Lfx_Timestamp,
N.Lfx_Status as Lfx_Status,
COALESCE(CS.Name0, S.Netbios_Name0) + '.' + COALESCE(CS.Domain0, S.Resource_Domain_OR_Workgr0) AS 'PrincipalName',
N.Name0 AS 'DisplayName',
N.DeviceID0 AS 'DeviceID',
N.Name0 AS 'Name',
N.Description0 AS 'Description',
ISNULL(N.Speed0, 0) AS 'Bandwidth',
ISNULL(N.MaxSpeed0, 0) AS 'MaxSpeed',
N.ProductName0 AS 'ProductName',
NC.DefaultIPGateway0 AS 'DefaultIPGateway',
NC.DHCPServer0 AS 'DHCPHostname',
(CASE WHEN ISNULL(NC.IPEnabled0, 0) = 0 THEN 'False'
ELSE 'True' END) AS 'IPEnabled',
N.AdapterType0 AS 'AdapterType',
NC.Index0 AS 'Index',
N.Manufacturer0 AS 'Manufacturer',
N.MACAddress0 AS 'MACAddress',
N.ServiceName0 AS 'ServiceName',
NC.DHCPEnabled0 AS 'DHCPEnabled',
NC.DHCPServer0 AS 'DHCPServer',
NC.DNSDomain0 AS 'DNSDomain',
NC.IPAddress0 AS 'IPAddress',
NC.IPSubnet0 AS 'IPSubnet'
FROM LFXSTG.CMv5_NETWORK_ADAPTER N
INNER JOIN LFXSTG.CMv5_NETWORK_ADAPTER_CONFIGUR NC
ON N.MACAddress0 = NC.MACAddress0
AND N.ServiceName0 = NC.ServiceName0
AND N.ResourceID = NC.ResourceID
AND N.Lfx_SourceId = NC.Lfx_SourceId
INNER JOIN [LFXSTG].CMv5_SYSTEM S
ON N.ResourceID=S.ResourceID AND N.Lfx_SourceId = S.Lfx_SourceId
INNER JOIN LFXSTG.CMv5_COMPUTER_SYSTEM CS
ON S.ResourceID=CS.ResourceID
AND S.Lfx_SourceId = CS.Lfx_SourceId
WHERE N.MACAddress0 IS NOT NULL
AND N.ServiceName0 != 'RasPppoe' AND N.ServiceName0 != 'PptpMiniport'
AND NC.IPEnabled0 != 0
AND S.Netbios_Name0 IS NOT NULL
AND S.Resource_Domain_OR_Workgr0 IS NOT NULL
AND CS.Lfx_Status = 'U'
HTH,
Dieter
-
Marked as answer by
FrankCoast
Tuesday, February 10, 2015 6:50 AM