SQL queries for SCCM ServiceNow integration

[SNowUser11]

HI,

Where do i get the out of box SQL queries ServiceNow uses to import data from SCCM?

Many Thanks

[Harsh Vardhan · Accepted solution]

i am assuming here, you are looking for sql queries which has used in sccm data source. if yes

you can check the SCCM data source , there it has defined all the sql queries in "SQL statement" field. 

Steps:

Go to the Data Source Module >> Open your SCCM Data source module>> there you will see the sql queries which has used for the particular data source. 

OR

if you have installed SCCM plugins in your instance then you will find below module ( data source) , open it and you will see the sql .

eg: you can open one of the sccm data source "SCCM 2016 Software". 

If my answer helped you, kindly mark it as correct and helpful.

[SNowUser11]

Hey Harsh,

Thanks very much. So can we customize these OOB SQL queries or modify the transform maps or in case needed create new Data sources 

Thanks

[Karthick Nagara]

Hi SNowUser11,

Did you modify the query statement. Was there any impacts out of it.

Im also trying to include a WHERE clause to the SQL Statement of SCCM data source. Please let me know.