Microsoft SMS and SCCM Connector

This section of the documentation contains technical specifications about the connector that is implemented to link ASM Core and System Center Configuration Manager (SCCM).

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

Purpose

An organization uses Microsoft SMS or SCCM to discover and maintain resources present in its organization networks.

Role

The 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

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 name

Link description

Higher resource type

Lower resource type

Installed on

A relationship describing that a particular instance of a Metered software product is currently installed on a given Resource

Metered software

Resource

Distributed to

A relationship indicating that a particular package has been successfully distributed to a given Resource

Package

Resource