SCCM-SNOW Integration error? view V_GS_SN_SAMP_ADD_REMOVE_PRORAMS_EDITION does not exist

[sachin2085]

SCCM-Servicenow Integration

Integration with SCCM was working fine till SCCM version Microsoft SCCM 2012 v2. Post SCCM upgrade to 1702 SCCM integration has started failing with  error.Object V_GS_SN_SAMP_ADD_REMOVE_PRORAMS_EDITION" does not exist. 

I am not able to see this particular view listed in the docs which is used for SCCM integration in the DOCS.

https://docs.servicenow.com/bundle/jakarta-platform-administration/page/integrate/cmdb/reference/sccm-import-process-and-tables.html

https://docs.servicenow.com/bundle/kingston-platform-administration/page/integrate/cmdb/reference/how-sccm-integration-works.html

Has anyone faced this situation earlier or what could be the reason

[Ashutosh Munot1]

Hi,

This is the error coming due to some field this field is missing in your database or its name might have changed.

Please show you sql query!!!

Also check if this object is used in your query or not.

Thanks,
Ashutosh

[sachin2085]

SELECT
product0 as Product,
edition0 as Edition,
version0 as Version,
publisher0 as Publisher,
timestamp,
resourceID
FROM V_GS_SN_SAMP_ADD_REMOVE_PROGRAMS_EDITION
WHERE Edition0 IS NOT NULL
AND Product0 IS NOT NULL
AND Publisher0 IS NOT NULL
AND Version0 IS NOT NULL

[Ashutosh Munot1]

Hi,

So this is the problem... Check with SCCM team is there any change in V_GS_SN_SAMP_ADD_REMOVE_PROGRAMS_EDITION.

Thanks,
Ashutosh Munot

Please mark Helpful or Correct.

[Ashutosh Munot1]

I can see there is some name change here.

Thanks,
Ashutosh