How to add more than 1 SCCM Database to a single SN instance

[Patrick DeCarl1]

What needs to be updated to allow more than 1 SCCM database to be active

1. Update Or copy OOTB script include "SCCMHelper"
2. 1. Update function findComputer
   2. 1. Include new pram source
      2. For the first query(cmdb_ci_computer) include "grc.addQuery("discovery_source", source);
      3. For the second query (sys_object_source) update grs.addQuery("name", "SCCM"); --> grs.addQuery("name", source);

Update the OOTB Transform Maps:

1. SCCM 2016(or whatever year) Computer Identity:
2. 1. New Field Map to set discovery_source to SCCM
   2. 1. Check the onAfter Script to make sure "var sourceObj = new ObjectSource("SCCM", target.sys_class_name, target.sys_id, source.u_resourceid + '');" is in place.
      2. ** For new datasource make sure to update sys_id mapping script o update lines:
      3. 1. "var IMPORT_NAME = "SCCM";" (Change SCCM value to your new one)
         2. " gr.addQuery("name", "SCCM");" (Change SCCM value to your new one)
         3. "var sourceObj = new ObjectSource("SCCM", target.sys_class_name, target.sys_id, source.u_resourceid + '');" (Change SCCM value to your new one)
3. SCCM 2016 Disk:
4. 1. In the script box update the following to include SCCM as source:
   2. 1. SCCMHelper.findComputer(source.u_resourceid, "SCCM"))
   3. Update field map computer script to be answer = SCCMHelper.findComputer(source.u_resourceid, "SCCM");
   4. Create new Field map to set discovery_source to SCCM
5. SCCM 2016 Network:
6. 1. In the script box update the following to include SCCM as source:
   2. 1. var computer_sysid = SCCMHelper.findComputer(source.u_resourceid, "SCCM");
   3. Update field map cmdb_id script to be: answer = SCCMHelper.findComputer(source.u_resourceid, "SCCM");
   4. Create new Field map to set discovery_source to SCCM
7. SCCM 2016 Operating System:
8. 1. Create new Field map to set discovery_source to SCCM
   2. Update field map sys_id script to be: answer = SCCMHelper.findComputer(source.u_resourceid, "SCCM"); see above screenshots for examples. 
9. SCCM 2016 Processor:
10. 1. Create new Field map to set discovery_source to SCCM
    2. Update field map sys_id script to be: answer = SCCMHelper.findComputer(source.u_resourceid, "SCCM");
11. SCCM 2016 Incremental Import under data source SCCM 2016 Removed Software:
12. 1. Update the onStart script:
    2. 1. Update line 39 "var cid = SCCMHelper.findComputer(id);" to "var cid = SCCMHelper.findComputer(id, "SCCM");"
13. SCCM 2016 Incremental Import under SCCM 2016 Removed Software (AI) data source:
14. 1. Update the onStart script:
    2. 1. Update line ~39 "var cid = SCCMHelper.findComputer(id);" to "var cid = SCCMHelper.findComputer(id, "SCCM");"
15. Incremental Import (SAM enabled) 2016 under data source SCCM 2016 Software:
16. 1. In the script box update the following to include SCCM as source:
    2. 1. if (JSUtil.nil(SCCMHelper.findComputer(source.u_resourceid, "SCCM")))
    3. Create new Field map to set discovery_source to SCCM
    4. Update field map installed_on script to be: answer = SCCMHelper.findComputer(source.u_resourceid, "SCCM");
17. If active Incremental Import 2016 under data source SCCM 2016 Software:
18. 1. Update the onAfter script:
    2. 1. var sys_id = SCCMHelper.findComputer(source.u_resourceid); to var sys_id = SCCMHelper.findComputer(source.u_resourceid, "SCCM");
19. Incremental Import (SAM enabled) 2016 under data source SCCM 2016 Software (AI):
20. 1. In the script box update the following to include SCCM as source:
    2. 1. if (JSUtil.nil(SCCMHelper.findComputer(source.u_resourceid, "SCCM")))
    3. Create new Field map to set discovery_source to SCCM
21. Create All new Data sources for other SCCM DBs:
22. 1. Create all new data sources based on OOTB ones for other SCCM instances, but make sure you create new source tables, also run through the same steps above but instead of SCCM put your new discovery source for second SCCM. Make sure this value is saved on the choice list table for discovery source.

If other screenshots are needed to help understand the steps let me know. 

If you found this helpful, please click helpful button below.