network Adapters are not imported in SCSM with SCCM Connector

I can't find the network adapters in scsm 2012R2

I am using the SCCM Connector.

I see the entries in the table CMv5_NETWORK_ADAPTER in SCSM database

But I can't see any in the MT_Microsoft$Windows$Peripheral$NetworkAdapter

No errors in the eventlog

Eventlog :

Connector SCCM : WPI Client with SCCM Client,SCCMConnector.8bede7cc35204baf9369124e33a97a2b saving 23 datarows returned by query to table/view CMv5_NETWORK_ADAPTER. These include creates/updates or deletions at source.

Connector name:SCCM : WPI Client with SCCM Client, Id:SCCMConnector.8bede7cc35204baf9369124e33a97a2b. Finished MomStore.Cached_CMv5_NetworkAdapters synchronization

Any Help ?

February 9th, 2015 4:43am

Are you talking about this data that appears in the Computers CI?:

The data is being saved as a CI and can be opened in it's own form:

If this is the data you are after, then the questions are:
1) What do you want this data for?
2) Do you want to find this data in the Data Warehouse? Or the ServiceManager Database?

The only real difference is that the ServiceManager DB is the active DB and transactions are IMMEDIATE. Where as the DW Database takes 1 hour for the ETL jobs to run before it gets the data, BUT, it is normalised and is where you should be running your reports from.

Brett

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 6:58am

Yes, 

I talk about the date in the Computer CI. It's not there at all.

I want this data because I want to see the NetworkAdapters related to a computer.

Processor is showing up; But the Network adapters are not.

In the service manager database the MT_Microsoft$Windows$Peripheral$NetworkAdapter is empty.

We are creating a new webfront for the CMDB and I want to show the IP-Address of the Computer CI.

Now we query the serviceManager ; not the Datawarehouse.

Regards,

Frank

February 9th, 2015 7:36am


Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 7:41am

The main reason for not seeing this data may be that the data is NOT being captured in SCCM and therefore can not be passed through, or the SCCM connector either is not running or is restricted to a collection in SCCM that contains only a few computers.

Computer CI's can come in via the SCCM and the AD connectors.

In my opinion, don't ever use the AD connector to bring Computers over. It is a waste of time as the data comes in via SCCM anyhow and it just takes more time to process.

Start with investigating your SCCM environment to make sure you are seeing the network adapters in the browser, then work backwards to the connector.

Good luck

Brett

February 9th, 2015 7:44am

Everything in SCCM is OK .

I can see the network cards in the resource Explorer (SCCM); I see the cards in the sccm table

I see the entries in the table CMv5_NETWORK_ADAPTER in SCSM database

So expect the SCCM side is OK or their wouldn't be any info in the CMv5_NETWORK_ADAPTER  table, I guess

SCCM connector is working fine for processor, disks, primary user, Installed software.

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 7:53am

Yes, My SCCM connector is limited to one collection (workstation collection with SCCM Client; do not want servers at this stage)

February 9th, 2015 8:12am

Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 8:39am

February 9th, 2015 8:39am

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 4 hours 47 minutes ago
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 9:15am

Thanx for the Query. 

I think I found it.

ServiceName is in Network Adapter and Network Adapter Config empty.

I added those fields in CM Hardware Inventory . I'll check later if when hw inventory is finished;

resync connector.

I''l update after these jobs


February 9th, 2015 9:45am

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
Free Windows Admin Tool Kit Click here and download it now
February 9th, 2015 5:13pm

Now it works.

I had to add some extra properties to the hardwareInventory of SCCM. Some fields used by the Query were NULL and therefore .... no result in SCSM.

After adjusting , new results came in . After resync the connector, the network adapters appeared in SCSM.

I guess I can find this query in the configuration Manager management Pack.

Now I can validate the other queries ...

Thanks a lot for the fast help .

Now I can continue building the new CMDB with SCSM.

Best Regards,

Frank

February 10th, 2015 1:58am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics