1E 23.11 (SaaS)

Navigate to Settings→Configuration→Connectors.

Click on the Add button.

In the Add connector popup, select the System Center Configuration Manager Connector type.

In Connector name, enter a logical name for this connector. In our example, we choose the name System Center Configuration Manager Inventory .

In SCCM Database Server, enter the name of the SQL Server instance where the Configuration Manager database is hosted, including custom port if used. In our example this is ACME-SQL01.

In SCCM Database, enter the name of the Configuration Manager database you want to connect to. In our example, this is called CM_CM1.

In our example, we will be using the SLA Integrate Services Agent service account to access the database. So we do the following:

1. Skip the SCCM SQL Server User and SCCM SQL Server Password fields.

2. Ensure Use Windows Authentication is checked.

Check the Run Consolidation Reports checkbox if you want consolidation actions to be processed each time the Sync Data action is executed for the connector.

This can lead to unnecessary processing if you enable this on more than one connector. The recommended method of processing consolidation actions is to schedule the action Generate Report - Basic Inventory Consolidation to execute after the Sync Data actions have run for all connectors. This will execute the remaining consolidation actions. Alternatively check the Run Consolidation Reports checkbox on one of your connectors. You can view action processes in Settings→Process log.

Click Add.

Select the Configuration Manager connector by checking the box at the left-hand end of its entry in the Connectors table.

Click the Test button.

1. The Test status column for the connector will display a clock icon

   

   indicating that the test has been queued for executing.

2. If the test succeeds, Test status will display a check icon

   and the Last tested column will display the date and time the test succeeded.

3. If the test fails, the Test status will display a failed icon

   and you'll need to check the details you entered for the connector.

In our example the test succeeds, so we can now continue to run the connector to populate an inventory repository.

Click the Execute button.

In the Execute action popup subsequently displayed, use the Repository menu to select the inventory repository you want to populate. In our example, this is a repository called Configuration Manager inventory.

Once the repository has been selected you can then select the action to run. In the case of inventory repositories, the actions will be restricted to inventory related actions. For a connector, you will be looking for an action with the form Sync Data - <connector name>. In our example this is Sync Data - System Center Configuration Manager Inventory, which includes the name that was set earlier in the Adding a Configuration Manager connector steps.

In our example, we also select to clear any existing data in the repository by checking the Clean sync checkbox.

Click Execute button in the Execute action popup to start the sync.

When the sync starts, a number of actions are queued to be performed on the selected repository. To check the progress of the sync actions:

1. Navigate to the Monitoring→Process log page.

2. Here you can see the sequence of actions that have been queued for the selected repository related to the Sync Data action selected. In the video, we speed up the process of synchronizing the data.

3. When each action has finished running you'll see a check icon

   appear in the Status column if it succeeds or a failed icon

   if it fails . In our example, all the actions succeed.

Once all the actions have succeeded, you can check the results. To do this:

1. Navigate to the Monitoring→Sync log page.

2. This displays the items that have been added to the selected repository as a result of running the sync. In our example, you can see a number of additions have been made to the Configuration Manager inventory repository.