SCCM Integration

Organizations using Microsoft SCCM for managing their computers can now import the Workstation data available in SCCM into ServiceDesk Plus Cloud. We have come with an integration which will not only help you to avoid scanning the same workstations but also allows you to import those already scanned workstation details into SDP OD. 

Prerequisites for SCCM Integration

In order for this integration to work, you need to make sure the following things are in place. 

• Add a probe that has access to the system where the SQL server for SCCM is installed. 
• If you select "SQL Authentication" as the authentication mode for the SQL server, then you need to add a Windows/WMI credential with a "SQL Server Username" and a "SQL Server Password" in the Credential Library. 

Accessing and Using the Feature

• Head to Setup>> Probes & Discovery >> SCCM Settings.   

• Click New SCCM Settings. 

• Enter the following details: 
  • The hostname of the workstation where the SQL server is installed. 
  • Port in which the SQL server is configured. 
  • Name of the Database which is linked to SCCM. 
  • Select the Authentication mode configured in SQL server. 
    • If you choose Windows Authentication, no credentials will be required. (Configuring SQL server for Windows Authentication)
    • If you choose SQL Authentication, the Windows/WMI type credential you have already configured will be listed in the credential drop-down. (Refer prerequisites)
  • Select the probe that has access to the SCCM/SQL server. (Refer prerequisites)
  • Save the settings. 
     

Testing the SQL server connection

After you have saved the SCCM settings, you can test if the connection to the SQL database server is working. 

To do that, Click on the settings icon in the SCCM integration list view and then click test. 

The connection status will be displayed. If it shows the "valid connection" status, you can click on Scan to import the workstation details from SCCM. 

Checking the probe status

You can also check the status of the probe by accessing the Probe tab. 

Click on task details icon in the probe list view. The status of the probes will be displayed. 
 

Once the probe is completed, the workstation details will be imported into SDP OD. You can view those workstation details by going to Assets >> Workstations. 

Configuring SQL Server for Windows Authentication

Prerequisite for configuring Windows Authentication  :

The selected probe must be installed either in the same server machine or any machine in the same domain as the SQL Server machine that has the SCCM Database.

Steps to Configure probe for Windows Authentication:

In the machine where the desired probe is installed, 

• Click Start and open "Run Window"
• Type "services.msc" in the run and select OK.
• Search and right click "ManageEngine SDP Cloud Probe" and select Properties. Switch to "Log On" tab.
• Select "This Account" radio button and click on Browse.
• In the "Select User" pop up, click on Advanced.
• Click on "Find Now".
• Select the user that has access to the SCCM Database in SQL Server.
• Click OK.
• Type the Password for the selected account and click Apply and then OK.
• With this, you have successfully configured the "ManageEngine SDP Cloud Probe" to scan the database in which SCCM is configured. 
  
  For adding a domain user to a specific database in SQL Server, please check the official help documentation.

What details will be imported

All Workstations available in SCCM along with their hardware details like Processors, Disks, Network adapters, etc., and Installed software information will be imported to ServiceDesk Plus Cloud.