How data gets created through SCCM integration??

[Devansh00]

Hi all, 

I want to know how data gets created into CMDB through SCCM integration is there any particular user to perform this action or directly data enters. Because i have to write a condition whenever the data gets created by the SCCM the Assets State and Substate should change. 

Thanks!!

[Kieran Anson]

Can you confirm on whether you're using the new SCCM service graph connector?

[Devansh00]

Yes, we are using Service graph connector.

[Kieran Anson]

Thanks for confirming, the OOB ETL definition for device identity doesn't set the state/status fields explicitly, so it'll be taking the default value which is "installed".

I would check whether your stakeholder wants this to only apply for SCCM, or whether any newly created CI/Assets should default to in stock/available to have a consistent process. 

If that is not desired, although I would strongly encourage, you should modify the ETL definition with an after script. In there, you can use the output to check whether a CI was inserted. If yes, modify the state of the inserted record to your desired value. This in turn will update the asset for you.

If you need step by step instructions, I can provide those too. I don't have SCCM data available but can provide pseudo code 

[monalipatil]

Hi Devansh,

You  can check created by of inserted record, for sure there you can see specific user name. Based on that you can configure your logic. Also you can check in integration which user is used

Thank you

[Devansh00]

Hi Monali,

As i  checked created by is not the same all time it has changed for the record, for some records it is admin and for other records it showing another username but the updated by is the same for all the records..