How to add SCCM adapter in a container install ?

Here is the procedure to deploy SCCM & BCM
 

1. Login to Jenkins machine as the user that owns the git repos
2. Navigate to the directory where CUSTOMER_CONFIGS Repo is present. (Location where onprem installer .zip was unzipped to get all Repo folders)
3. cd CUSTOMER_CONFIGS
4. git clone onprem-remedyserver-config.git
5. cd onprem-remedyserver-config
6. Open input file and make needed changes:

               vi customer/<customer_service>/<customer_service>-<environment>.sh  (eg: vi customer/itsm/itsm-poc.sh)
                change below parameters values to 'true' and save the file
                  SCCM="true"
                  BCM="true"

Update the $SCCM with SCCM environment values and SCCM_INTEGRATION_AR_USER_NAME with hannah_admin

7. Commit above changes and push to git repo.

                   git add -A
                   git commit -am "<commit message>"
                   git push origin master
Above steps cover the changes to input file to have SCCM and BCM options set to 'true'.

Follow below steps to run HELIX_NON_PLATFORM_DEPLOY pipeline in SERVICE_MODE:

1. Open Jenkins app in browser
2. Select HELIX_ONPREM_DEPLOYMENT and open the last successful job from Build History pane
3. Select 'DEPLOYMENT_MODE' as "SERVICE" under the 'ENVIRONMENT DETAILS' section.
4. Select ONLY "HELIX_NON_PLATFORM_DEPLOY" options under "PRODUCT_DEPLOY" section (Please do not select any other pipeline).
5. Click Rebuild         

                     
This will run HELIX_NON_PLATFORM_DEPLOY pipeline in SERVICE_MODE and deploy SCCM and BCM job containers.

Perform the following post deployment tasks. 
In the Spoon client, specify the database connection values for source, target, and PDI repository server for the SCCM_CMDB_Import and SCCM_CMDB_Delete jobs.


Source server: (SCCM SQL DB server)

1. 1. 1. Log on to the Spoon client.
      2. Open the SCCM_CMDB_Import job.
      3. In the Spoon Explorer, select SCCM_CMDB_Import > Database connections > SCCMSQLDBBMC (right click-Edit)> General 
      4. From the Connection Type list, select MS SQL Server.
      5. From the Access list, select Native (JDBC).
      6. Specify or replace the values for Host Name, Database Name, Instance Name, Port Number, User Name, and Password fields.
      7. Click OK.
      8. Repeat steps from 2 to 7 for the SCCM_CMDB_Delete job.

Target server: (AR Server)

1. 1. 1. Log on to the Spoon client.
      2. Open the SCCM_CMDB_Import job.
      3. In the Spoon Explorer, select SCCM_CMDB_Import > Database connections > SCCMCMDBServer (Right click ->Edit)> General. 
      4. From the Connection Type list, select AR System.
      5. From the Access list, select Native (JDBC).
      6. Specify or replace the values for Server Name, TCP Port, User Name, and Password fields.
      7. Click OK.
      8. Repeat steps from 2 to 7 for the SCCM_CMDB_Delete job.

PDI Repository server:

1. 1. 1. Log on to the Spoon client.
      2. Open the SCCM_CMDB_Import job.
      3. In the Spoon Explorer, select SCCM_CMDB_Import > Database connections > PDIRepo_Server > General. 
      4. From the Connection Type list, select AR System.
      5. From the Access list, select Native (JDBC).
      6. Specify or replace the values for Host Name, Database Name, Instance Name, Port Number, User Name, and Password fields.
      7. Click OK.
      8. In the Spoon Explorer, select SCCM_CMDB_Delete > Database connections > PDIRepo_Server > General
      9. Repeat steps from 3 to 7 for the SCCM_CMDB_Delete job.

Specify the job log table parameter for the SCCM_CMDB_Import and SCCM_CMDB_Delete jobs.

1. 1. 1. Log on to the Spoon client.
      2. Open the SCCM_CMDB_Import job.
      3. Right click SCCM_CMDB_Import job.
      4. Select Settings > Log tab > Job log table.
      5. In the Log connection field, specify the name of the PDI Repository server.
      6. In the Log table field, specify UDM:JobLog table name.
      7. Click OK.
      8. Repeat steps from 2 to 7 for the SCCM_CMDB_Delete job.

Specify job entry log parameter for the SCCM_CMDB_Import and SCCM_CMDB_Delete jobs.

1. 1. 1. Log on to the Spoon client.
      2. Open the SCCM_CMDB_Import job.
      3. Right click SCCM_CMDB_Import job.
      4. Select Settings > Log tab > Job entry log.
      5. In the Log connection field, specify the name of the PDI Repository server.
      6. In the Log table field, specify UDM:JobEntryLog table name.
      7. Click OK.
      8. Repeat steps from 1 to 7 for the SCCM_CMDB_Delete job.