

Installed Services View = Installed Services Business Object.Installed Software View = Installed Software Business Object.Workstation View = Config-Computer Business Object.Map and Import the SCCM Views into existing CSM Business Objects, for example:.Create an External Connection (SQL Server) to the SCCM data.Disk View: For logical disk data/drives.Installed Services: For installed services.Installed Software: For installed programs/software.Workstations View: For workstation data.Create Views of the SCCM data to share, for example:.When sharing data with an SCCM Database, Users will most likely want to: This could require creating a Linked Server. Before CSM can share data in a normalized External Database, one or more database Views need to be created to collect, combine, and filter the shared (imported/linked) information. Note: SCCM utilizes a normalized Microsoft SQL Server (MSSQL) database (data is spread across many tables).

CSM provides several wizards to walk Users through the steps to create the External Connection, create the External Business Object, and import/link the external data. Typically, SCCM workstation data is imported into the Config-Computer Business Object, and all other data (installed programs/software, installed services, disks, etc.) is linked to using supporting Business Objects (either existing or newly created External Supporting Business Objects). A special External Business Object keeps track of the external data and facilitates viewing/updating that data in CSM keeps track of the external data and facilitates viewing/updating that data in CSM. When linking to external data, view (and sometimes update) the external data in CSM but it continues to reside in the External Database.A Business Object keeps track of the external data and facilitates viewing/updating that data in CSM. Re-imports can be run manually or they can be regularly scheduled using the CSM Scheduler.

From that point forward, the records can diverge, although data can be re-imported (entirely replacing existing data or appending/updating changed data) if desired.

Microsoft® System Center Configuration Manager (SCCM) Integration
