Populate additional value using SCCM

[ARAVINDA11]

@Ankur Bawiskar @Community Alums  OR Anyone

Can you please help with the below scenario

In cmdb_ci_computer Data are populating through SCCM so I Tried to find any data source  is available as there is no data source available for Service graph connector sccm

my requirement was:

in cmdb_ci_computer I want to have a 2 fields called Last logged on user & Primary user

Please help how can I achive this step using SCCM after creating the field i want to auto populate

[Premankit]

@ARAVINDA11  I am going with assumption that in you environment SCCM is already configured and is it using Service Graph Connector for Microsoft SCCM. Please correct if my assumption is wrong. 

If above is the case then the DATA Source is SG-SCCM Computer Identity. You can check this in "IntegrationHub ETL". If you don't see that you need to review your SCCM spoke. Possibility is you are not using service graph connector for Microsoft SCCM. 

To your requirement 

1- Any reason to chose cmdb_ci_computer to create those fields? Computer class contains Personal computers too which will always have one person logging in. If you need to capture Server logging info develop fields on Server class. 

2- Based on field names,  I am assuming that you are trying to get information of who logged to system lastly and who the owner of system is. If that is case I would recommend use Assigned to/ Managed by/Supported by/Most frequent user field for primary User. 

You can find step by step instruction for SCCM configuration here
 https://docs.servicenow.com/bundle/vancouver-servicenow-platform/page/product/configuration-manageme... 

[ARAVINDA11]

@Premankit Thanks for your reply this dosent give full answer to my question 

if i want to add a separate field in source table of data source and transfter to separate field of target table that is computer table how can i achieve this , I can see they are using robust tansform map , In robust transform map i dont see it they are placing in target table as they are storing in temp let me know can these values are still populating 

Pls note how the below connection are working I can see these field is available in my source table as they mentioned in data source but the target field value are different they are throwing into temp what is this & how the values are populating

[Premankit]

Please use “IntegrationHub Etl” that is simplified interface. What you need is to update the mapping to the cmdb table. Its jst drag and drop for data tablets like flow designer.