ServiceNow SCCM Integration custom fields

[Hanumant Madan1]

Hello All,

We have integrated SCCM with ServiceNow successfully.

We have analyzed and found we do not get few fields with the OOB query from SCCM.

• Last SCCM Scan
• Last logged in User

Can anyone help us understand if they modified the SCCM integration query on ServiceNow side to fetch the required data, what impact does it have in long term w.r.t to upgrades> I mean are customizations overwritten and remove during upgrade?

If we have to add this in a OOB query, what all things we will have to touch upon to make it successful and how much time can it take to complete end to end solution.

Also, We see ServiceNow table has "Assigned To" field which is empty for us and as we read more it seems SCCM side there is some field called "user" which ServiceNow pulls and maps to Assigned To, but only when the match is found exactly? Is that the correct understanding.

Any other suggestions in addition to above questions will really help.

Thank you!

Regards,

HM

[Rahul Priyadars]

Are you using SCCM service Graph connector for same which uses Robust Transform or the OLD Connector?

Regards

RP

[Hanumant Madan1]

Hi Rahul,

It is service graph connector based integration.

Regards,

HM

[Rahul Priyadars]

@Hanumant Madane if you take my view. Do not customize service graph connector.

Rather write one custom JDBC data source for SCCM Sql server.

Use query to fetch the data 

put data into Staging table

Using transform map update the fields 

This can be done out side of Service Graph connector so future connector upgrade will not touch ur enhancements too.

Regards

RP

[Vikram Gupta]

Hi @Rahul Priyadars  if we want to fetch multiple fields from multiple view then table will be different in sccm so how one data source will satisfy for different table data