How do we identify addtional data sources/fields in SCCM integration tool?

[Urie1]

Hello,

We are currently using SCCM integration to add devices to our asset table. We have a field that we have available in SCCM that i do no see in any of the SCCM data sources called "assigned user". 

Does anyone now if the data sources pulled from SCCM are static or can we choose more fields to be available when pulling data from SCCM?

[AshishKM · Accepted solution]

Hi,

You can pull additional data from SCCM ( if available ) via SQL Statement in SCCM Data Source and manage that via transform map to target table ( cmdb_ci_computer ) column.

Thanks

Ashish   

Please mark correct answer and helpful if it helps.

[Urie1]

I will try this and provide an update

[shloke04]

Hi @Urie 

Adding as many fields/attributes as you like is fine. 

In the SQL statement you'll need to make sure you've selected the field you want. 

You can then add an entry into the transform map for the SCCM data source to transform it into the CMDB .

Refer to screenshot below:

Also refer below blog which shows how we can customize the SCCM integration as well:

https://www.recastsoftware.com/resources/how-to-customize-sccm-data-in-the-servicenow-cmdb/

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke