SCCM Service graph connector Not pulling all data from SCCM db

[Nidhi Priya]

Below are the list of Fields that are present in SCCM DB and We want these fields to be fetched in Servicenow and to be mapped in cmdb_Ci_computer/ asset tables..  Primary User, Recently logged on User, Last Activity, Last Logon Time, Virtual Machine, Client Activity.

Please help ua ASAP as we are already live and customer is looking for all this info

[anubhavkapoor76]

@Nidhi Priya Is there any specific IHUB ETL application you are referring to in this SCCM SG connector. May be it is "SG-SCCM Computer OU"?

You will have to edit the mappings for the cmdb_ci_computer class in that specific IHUB ETL application

Mark this helpful/correct if it works for you.

Thanks,

Anu

[Nidhi Priya]

Actually, According to SCCM Team, All those fields are available in SCCM DB.. So, we need to fetch it into Servicenow. I think OOB SCCM SQL Query doesnot fetch those fields. 

We need to know how to fetch other fields from SCCM DB?

Will this "IntegrationHub ETL" requires License? 

Please suggest

[anubhavkapoor76 · Accepted solution]

@Nidhi Priya - IntegrationHUB ETL is a free platform offering and does not require and licensing on its own.

So you would need to alter the SQL Query in Data source "SG-SCCM Computer OU" as below and bring in those fields 

Once you have brought the fields, then you would need to make changes to the mapping in IntegrationHUB ETL and map it to correct target fields of cmdb_ci_computer table.

Mark this helpful/correct if it works for you.

Thanks,

Anu

[Nidhi Priya]

This was really helpful Anu. Thanks a lot.

Just to clear again- IntegrationHUB ETL is a free platform offering and does not require licensing. No Addition cost? Right?

It would really be helpful if you can share some docs on IntegrationHUB ETL.