Skip to main content

System Center Configuration Manager (SCCM)

Integrate System Center Configuration Manager (SCCM) with Cloudaware to inventory devices, users, sites, and disks directly from the SCCM database.

info
  • Audience: Cloudaware administrators, EUC/Endpoint teams, and endpoint operations teams
  • Outcome: SCCM inventory is connected to Cloudaware, and endpoint, user, site, and disk records are available in CMDB for asset correlation, coverage review, and reporting

Capabilities​

The integration supports:

  • Read-only discovery of SCCM inventory directly from the SCCM SQL database
  • CMDB records for SCCM devices, users, sites, disks, and user group relationships
  • Endpoint inventory reporting and asset correlation in CMDB Navigator, CMDB list views, and reports

Prerequisites​

Before you begin, make sure you have:

  • Access to a Cloudaware account.
  • A user with access to the Admin Console and permissions to manage cloud accounts, organizations, and integrations (Cloudaware Administrator).
  • SCCM SQL database hostname and port.
  • SCCM database name.
  • SCCM database username and password with read access to the required SCCM inventory tables.
  • TunHub configured if the SCCM SQL database is available only on a private network.

Add a SCCM Instance to Cloudaware​

  1. In Cloudaware, go to Admin.
  2. Find System Center Configuration Manager, then click + ADD.
  3. Enter the following values:
    • Name: A display name for the SCCM integration.
    • Host: The SCCM SQL database hostname.
    • Port: The SCCM SQL database port.
    • Database: The SCCM database name.
    • Username: The database username.
    • Password: The database password.
  4. Click Save.
  5. Confirm that the integration status indicator is green.
tip

Allow the initial discovery cycle to complete after enabling the integration. Large SCCM environments may take additional time before all records appear in CMDB.

View System Center Configuration Manager (SCCM) Data in CMDB​

  1. In Cloudaware, open CMDB Navigator.
  2. In the left pane, select SYSTEM CENTER CONFIGURATION MANAGER.
  3. Open an object list, e.g., SCCM Devices, to view discovered records.

Supported Objects​

Cloudaware ingests the following System Center Configuration Manager (SCCM) objects:

SCCM ObjectCMDB Object API Name
SCCMCA10S__CaSccmConfigurationManager__c
SCCM DeviceCA10S__CaSccmDevice__c
SCCM DiskCA10S__CaSccmDisk__c
SCCM SiteCA10S__CaSccmSite__c
SCCM UserCA10S__CaSccmUser__c
SCCM User GroupCA10S__CaSccmUserGroup__c
SCCM User Group User LinkCA10S__CaSccmUserGroupUserLink__c

Troubleshooting​

note

Initial data collection may take time to complete.

Connection Fails or Integration Shows Red Status​

  • Verify that the SCCM SQL database hostname, port, database name, username, and password are correct.
  • Confirm that Cloudaware can reach the SCCM SQL database. If the database is on a private network, check the TunHub configuration.
  • Confirm that the SQL Server allows connections from the network path used by Cloudaware or TunHub.

No Data Appears Several Hours After a Successful Save​

  • Allow the initial discovery cycle to complete.
  • Confirm that the database user has read access to SCCM device, user, site, disk, and user group inventory data.
  • In CMDB Navigator, verify that you are viewing the SYSTEM CENTER CONFIGURATION MANAGER section and related resources.

Some SCCM Records Are Missing​

  • Check whether the missing records are present in the SCCM database.
  • Verify that the database user can read the required SCCM inventory tables and views.
  • Review SCCM inventory collection timing, because recently changed endpoint data may not be available until SCCM updates its database and Cloudaware completes the next discovery cycle.

Still stuck? Contact Cloudaware Support at support@cloudaware.com with the SCCM database host name and a brief description of the issue.

Reconfigure or Remove the Integration​

warning

To rotate database credentials or change connection settings, edit the existing integration instead of deleting and re-creating it.

Update the Integration Details​

  1. Go to Admin.
  2. Select System Center Configuration Manager.
  3. Select the specific integration.
  4. Open the three-dot menu (⋮), then click Edit.
  5. Update the required fields.
  6. Click Save.

Remove the Integration from Cloudaware​

  1. Go to Admin.
  2. Select System Center Configuration Manager.
  3. Select the specific integration.
  4. Open the three-dot menu (⋮), then click Delete.
  5. Confirm the deletion if prompted.

Security Notes​

  • Use a dedicated SQL user for Cloudaware discovery with read-only access to the SCCM data required for inventory collection.
  • Do not reuse privileged SQL Server administrator credentials for the integration.
  • Store and rotate the SCCM database password according to your organization's credential management policy.
  • Restrict network access to the SCCM SQL database so that only approved Cloudaware or TunHub connectivity paths can reach it.
  • Review SCCM data classification with your security team, because endpoint and user inventory may contain hostnames, usernames, device metadata, and other operational identifiers.