Change the Out of the box SQL statement for service graph for SCCM

[lmundere]

Hi,

anyone managed to change the Out of the box SQL statement for the service graph connector for SCCM? Whenever I change the Statement in Computer Identity, and do test load 20 records, i see the fields that modified with the correct data, but when I run the import, the SQL statement somehow goes back to Out of the box statement. How to solve this? 

[lmundere · Accepted solution]

Finally found it, you would need to go to Service Graph Connectors > SCCM > Instance, then you will open the record (s) that is there, depending on how many connections you have, on the related list, there is Custom SQL Statement, then choose the one you want to edit, add the custom SQL and it will show up in the data source