# Microsoft SMS and SCCM Connector {% hint style="info" %} Alemba is currently reviewing and updating the whole of the connector section, including all subsections. Expect this section to be updated by end of June, 2025. {% endhint %} It describes the details of the third-party application, that is, Microsoft SCCM including: * The name of the .NET assembly file * Connection methodology * The resource and link types that can be discovered on the application * The attributes of each resource and link type that can be imported into the ASM Core Configuration Management Database (CMDB) You should familiarize yourself with the information in Installing Connectors before installing any connectors, and read the Integration topics for more information on how to configure them. ## Use Case Scenario
PurposeAn organization uses Microsoft SMS or SCCM to discover and maintain resources present in its organization networks.
RoleThe role of the connector is to expose the resources and their relationships to allow for population and ongoing consistency controls of the ASM Core CMDB.
## Connector Description The table below provides a description of the Microsoft SCCM Connector. | Information fields | Description | | ----------------------- | ----------------------------------------- | | Connector name | MS SMS/SCCM <-> ASM Core | | Third-party application | Microsoft SCCM | | .NET Assembly name | Infra.Connector.SCCM.dll | | Connector class | Infra.Connector.SCCM.SCCMConnector | | Configuration file | Infra.Connector.SCCM.icnf | | Connection methodology | ODBC connection to an SQL Server database | ## Connection Parameters The table below provides a description on the connection parameters of the Microsoft SMS and SCCM Connector. | Information fields | Description | | ------------------- | ---------------------------------------------------------------------------- | | Database Connection | Database connection string or system DSN to the SMS/SCCM SQL Server database | | Database Login ID | Database login ID | | Database Password | Database password | Below you can see an example of the connection parameters of an SMS/SCCM source including connection details. ## Customization The Microsoft SMS and SCCM Connector permits extensions to the schema through customization of the configuration file. The possible customizations include but are not restricted to: * New resource types * New resource properties * New link types ## Connector Diagnostics The connector has the facility to trace information. The data can be obtained through Polling tracing or Application tracing. ## Resource Types This section lists the resource types and properties exposed by the connector on Microsoft SMS 20003 or SCCM 2007 systems. ### Resource Types for SMS 2003 #### Metered Software Metered software refers to a software product whose usage is monitored across an SMS site. The connector ensures that only the active Metered software are exposed and imported in the Federated CMDB. The attributes of Metered software are as follows: * Rule ID * Rule Name * Comment * File Name * File Version * Last Update Time * Original File Name * Security Key * Site Code * Source Site #### Package A Package is a software deployment package configured within SMS to be distributed to the systems within a site. The attributes of Package are as follows: * Package ID * Name * Description * Language * Manufacturer * Version * MIF Filename * MIF Name * MIF Publisher * MIF Version * Source Date * Source Site ### Resource Types for SMS 2003 Source Version * Stored Pkg Path * Stored Pkg Version #### Resource A Resource is a discovered system within an SMS site. Resource ID is used as the unique identifier of the Resource. The attributes of Resource are as follows: * Resource ID * Active * IP Addresses * IP Subnets * IPX Addresses * IPX Network Numbers * MAC Addresses * AD Site Name * CPU Type * Decommissioned * Hardware ID * User Domain * User Name * Name * NetBIOS Name * OS * Domain * SMBIOS UUID * Community Name * Last Hardware Scan * Manufacturer * Model * Description * Roles * Status * System Type * BIOS Serial No * \# Processors * Processor Speed * Chassis Type * Chassis Serial No * CD-ROM * Modem * Physical drives * Storage (Mb) * Total Physical Memory (Kb) * Total Virtual Memory (Kb) * Total Storage (Mb) ### Resource Types for SCCM 2007 #### Metered Software Metered software refers to a software product whose usage is monitored across an SCCM site. The connector ensures that only the active Metered software are exposed and imported in the Federated CMDB. The attributes of Metered software are as follows: * Rule ID * Rule Name * Comment * File Name * File Version * Last Update Time * Original File Name * Security Key * Site Code * Source Site #### Package A Package is a software deployment package configured within SCCM to be distributed to the systems within a site. The attributes of Package are as follows: * Package ID * Name * Description * Language * Manufacturer * Version * MIF Filename * MIF Name * MIF Publisher * MIF Version * Source Date * Source Site * Source Version * Stored Pkg Path #### Resource A Resource is a discovered system within an SCCM site. The attributes of Resource are as follows: * Resource ID * Active * AD Domain Name * AD Site Name * CPU Type * Decommissioned * Hardware ID * Internet Enabled * User Domain * User Name * Name * NetBIOS Name * OS * Domain * SMBIOS GUID * SMBIOS UUID * Community Name * Last Hardware Scan * Manufacturer * Model * Description * Roles * Status * System Type * BIOS Serial No * \# Processors * Processor Speed * Chassis Type * Chassis Serial No * Total Physical Memory (KB) * Total Virtual Memory (KB) * Total Storage (MB) * IP Address * IP Subnet * MAC Address ## Link Types A link is defined by its name, a higher resource type, and a lower resource type. The higher and lower resources correspond to the resources types of the resources that are located at the ends of the link. The table below lists the link types that the connector has to discover on Microsoft SMS 2003 or SCCM 2007 systems. The links can then be imported into the ASM Core CMDB.
Link nameLink descriptionHigher resource typeLower resource type
Installed onA relationship describing that a particular instance of a Metered software product is currently installed on a given ResourceMetered softwareResource
Distributed toA relationship indicating that a particular package has been successfully distributed to a given ResourcePackageResource