SCCM Integration

SCCM Integration

Organizations using Microsoft SCCM to manage their workstations can now import the workstation data available in SCCM into AssetExplorer Cloud.
 
SCCM integration prevents duplicate scanning of workstations and also imports previously scanned workstation details into AssetExplorer Cloud.

Role Required: SDAdmin
 

Prerequisites for SCCM Integration 

  1. Add a probe with access to the system where the SQL server for SCCM is installed.
  2. If you select SQL authentication mode for the server, add a Windows/WMI/SQL Server credential type with the SQL server username and password in the Credential Library.
 

Add New SCCM Settings  

  1. Go to Setup > Probes & Discovery > SCCM Integration.
  2. Click New SCCM Settings.
  3. Enter the hostname of the machine where the SQL server is installed.  
  4. Specify the port in which the SQL server is configured.
  5. Provide the name of the database which is linked to SCCM.
    1. Select the authentication mode configured for the SQL server.
    2. If you choose Windows Authentication, no credentials will be required. (refer prerequisites)
      1. If you choose SQL Authentication, the Windows/WMI type credential you have already configured will be listed in the credential drop-down.
    3. Select the probe that has access to the SCCM/SQL server.
  6. Save the settings.

  

Testing the SQL Server Connection 

After configuring the SCCM settings, you can verify the connection to ensure that the SQL database connection is working.

Click the settings icon against the SCCM integration in the list view and then click Test.
 
Upon successful connection, the Connection Status column in the list view will display "valid connection".

You can click the settings icon against the SCCM in the list view and select Scan to import the workstation details from SCCM.
   
Once the scan is completed, the workstation details will be imported into AssetExplorer Cloud. You can view the 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 contains the SCCM Database.

Steps to Configure Probe for Windows Authentication

In the machine where the desired probe is installed,
  1. Click Start and open the Run window
  2. Type services.msc in the run and select OK.
  3. Search for ManageEngine SDP Cloud Probe. Right-click it and select Properties.
  4. In the properties window, go to the Log On tab.
  5. Select This Account radio button and click Browse.
  6. In the Select User pop-up, click Advanced > Find Now.
  7. Select the user who has access to the SCCM Database in SQL server and click OK.
  8. Type the password for the selected account, click Apply, and then OK.
  9. With this, you have successfully configured the probe to scan the database in which SCCM is configured.
To learn more about adding a domain user to a specific database in SQL Server, click here.
 
Idea
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 AssetExplorer Cloud. 

    • Related Articles

    • Microsoft Azure

      Azure integration is an additional authorization over Microsoft single sign-on. This integration allows you to import users' department and site details in addition to the basic information from the Azure directory. Role Required: SDAdmin/OrgAdmin in ...

    • Mobile Device Manager (Cloud)

      Integrate AssetExplorer Cloud with Mobile Device Manager Cloud application to allow technicians to track and manage smartphone and tablet devices. Once integrated, the device information from mobile and smartphone devices is brought into ...

    • Zoho Analytics

      Zoho Analytics is a cloud-based reporting and business intelligence management tool that helps users extract valuable insights from their business data. This integration enables SDAdmins to analyze their asset desk data visually, generate dynamic ...

    • Microsoft Azure AD User Sync

      Sync users periodically from Azure Active Directory to AssetExplorer Cloud. You can import users based on criteria and custom-map Azure fields with AssetExplorer fields as required. AssetExplorer Cloud just reads user information from Azure via API ...

    • Zoho Directory

      Zoho Directory allows you to manage your organization's users across various applications. With this integration, you can add or edit users, configure roles and permissions, assign users and technicians, track login activity, update passwords, and ...