You are browsing the archive for management server.

Avatar of kurtvh

by kurtvh

Importing data into SCSM (part 1) – the SCSM AD & SCCM connectors

10:40 pm in Uncategorized by kurtvh

The Service Manager database contains information about the environment. After a fresh installation, we have an empty database. This SCSM database can be easily populated with different entries (configuration items for SCSM) with the use of connectors. In the SCSM console, you have four different connectors that can be configured.

clip_image002

Active Directory Connector: This connector enables the import of users, groups, printers, and computers from Active Directory as configuration items (CI) into the Service Manager database. Complete domain, OU or a selection of different objects are source configurations that can be set during installation of the connector.

Configuration Manager Connector: This connector enables the import data from Microsoft System Center Configuration Manager 2007 Site Database into the System Center Service Manager database. The ConfigMgr connector can enable a couple of functions:

– Importing assets by using a Configuration Manager Connector can add details about a configuration item that has already been imported by using an AD Connector, or add new configuration items that do not exist in Active Directory.

– Importing configuration baselines from ConfigMgr and then use that to automatically generate incidents for non-compliant configuration items.

Operation Manager Alert Connector: The OpsMgr alert connector is used to automatically generate incidents that are based on Operations Manager alerts.

Operation Manager CI Connector: The CI connector imports discovered objects from Operation Manager as configuration items into the SCSM database.

This first blog post will cover the installation and configuration of the AD & ConfigMgr connector.

Installation of the Active Directory Connector

Pre-requisites:

– Connector account with read rights in Active Directory

Installation of the connector

In the Service Manager console, click Administration.

In the Administration pane, expand Administration, and then click Connectors.

In the Tasks pane, under Connectors, click Create Connector, and then select Active Directory Connector.

clip_image004

The Active Directory Connector Wizard starts…

On the Before you Begin page, click Next.

clip_image006

On the General page, in the Name box, type a name for the new connector. On this page, we can enable or disable the connector.

clip_image008

On the Domain or Organizational Unit page, we have two configuration options:

– Select Use the domain: <domain name> for complete domain import

– Or select Let me choose the domain or OU and then click Browse to choose a domain or an organizational unit (OU) in your environment. (I have selected a specific OU “Accounts” in this example setup.)

In the Credentials area, click New or select an existing Run As account from the drop down list.

Configuration made on this page can be tested using the Test Connection button.

clip_image010

On the Objects page, we can configure the connector to import “All computers, printers, users, and user groups” or alternatively to import only selected items with selecting “Select individual computers, printers, users or user groups”.

clip_image012

On the Summary page, make sure that settings are correct, and then click Create.

On the Completion page, make sure that Active Directory Connector successfully configured appears, and then click Close.

clip_image014

Go back to the Administration pane, expand Administration, and then click Connectors.

Select the just created AD connector and navigate to the Tasks pane, under AD Connector, click Synchronize Now.

Wait a few moments and you can see that the discovered objects from AD are imported as configuration items in SCSM. To check the import, just navigate to the Configuration Items in the SCSM console, expand Configuration Items and select for example All Computers. The CI’s are listed in the results pane.

clip_image016

(Example of the imported Configuration items)

Next step is to configure the Configuration Manager Connector. This will import more meta-data information for the imported configuration items from AD. (or add new configuration items)

Installation of the ConfigMgr Connector

The following procedure can be used to import data from ConfigMgr 2007.

Pre-requisites:

– Connector account that must be a member of the smsdbrole_extract and the db_datareader groups on SCCM site database.

Installation of the connector

In the Service Manager console, click Administration.

In the Administration pane, expand Administration, and then click Connectors.

In the Tasks pane, under Connectors, click Create Connector, and then select Configuration Manager Connector.

clip_image018

On the Before you Begin page, click Next.

On the General page, in the Name box enter a name for the new connector and provide a description if needed. On this page, we can enable or disable the connector.

clip_image020

On the Select Management Pack page, in the Connector Management Pack list, select System Center Configuration Manager Connector Configuration, and then click Next.

clip_image022

On the Connect to System Center Configuration Manager Database page, specify the name of your SCCM server and the name of the SMS database.

In the Credentials area, click New or select an existing Run As account from the drop down list.

Note: Account must have rights in the SCCM database to import object information like it is specified in the pre-requisites.

clip_image024

On the Collections page, select the appropriate collection, and then click Next. I have enabled the configuration for “All Systems” collection. This can be changes at a later stage…

clip_image026

On the Schedule page, in the Synchronize list, set how often, and at what time, synchronization should occur, and then click Next.

clip_image028

On the Summary page, confirm the connector settings you made, and then click Create.

On the Confirmation page, make sure that You have successfully completed the System Center Configuration Manager Connector Wizard is displayed, and then click Close.

clip_image030

Go back to the Administration pane, expand Administration, and then click Connectors.

Select the just created SCCM connector and navigate to the Tasks pane, under SCCM Connector, click Synchronize Now.

In production environments where many objects are defined in ConfigMgr, it can take several hours to complete the import. A status of the import procedures is displayed on the connector result pane.

clip_image032

When the import is finished, we have detailed information available on the objects imported via the AD connector.

To check the import, just navigate to the Configuration Items in the SCSM console, expand Configuration Items and select for example All Computers. The CI’s are listed in the results pane. You can see that after the import a more exhaustive list of information is available for each configuration item.

clip_image034

Next blog post will cover the configuration of the OpsMgr connectors…

Enjoy,

Kurt Van Hoecke

http://www.linkedin.com/in/bunkco

Installing Service Manager part I

4:07 pm in Uncategorized by The WMI guy

As mentioned a couple of days ago the System Center Service Manager Beta 2 is now available http://scug.be/blogs/scsm/archive/2009/10/03/service-manager-beta-2-available.aspx 

In the following blog post I’m going to describe the steps required to install Service Manager Beta 2

 

Software requirements:

Service Manager management server

The 64-bit edition of Windows Server 2008 Standard or the 64-bit edition of Windows Server 2008 Enterprise

Microsoft .NET Framework version 3.5 with SP1*

Service Manager or Data warehouse databases

The 64-bit edition of Windows Server 2008 Standard or the 64-bit edition of Windows Server 2008 Enterprise

clip_image001Note

Installation on a computer running Windows Server 2003, even with SQL Server 2008 is not supported.

The 64-bit version of SQL Server 2008

SQL Server Reporting Services (SSRS) component of SQL Server 2008

The Microsoft .NET Framework 3.5 with SP1 is required on the computer hosting the data warehouse databases when installing Service Manager in a four-computer scenario. *

 

· Default SQL_Latin1_General_CP1_CI_AS collation with a default instance.

· SQL FTS: Full-text search must be installed. For more information about full-text search, see the SQL Server 2008 Full-Text Search: Internals and Enhancements white paper at http://go.microsoft.com/fwlink/?LinkID=129544.

· Service Account configured as Local System.

· SQL Server Reporting Services (MSSQLSERVER) service configured and running. For more information about how to configure the MSSQLSERVER service, see the Microsoft MSDN Web site at http://go.microsoft.com/fwlink/?LinkId=91847.

· For this release, make sure that the collation in SQL Server is identical on both computers that host the Service Manager and the data warehouse databases. For more information about SQL Server collations, see the Microsoft MSDN Web site at http://go.microsoft.com/fwlink/?LinkId=146998.

 

image

 

Select install a service manager management server. This will install the service manager server locally and also install the service manager database remotely on a SQL 2008 server. The datawarehouse will be installed later on.

clip_image004

You don’t need to enter a product key during this beta setup. Just click next.

clip_image006

Select a installation folder.

clip_image008

Pre-requisite checker

clip_image010

On the Configure the Service Manager database page, Service Manager will check the current computer to see if an instance of SQL Server exists. If one is found, the default is for Service Manager to create a new database in the existing instance. If an instance displays, click Next.

Important

For this release, Service Manager does not support case-sensitive instances. Setup will fail if you attempt to install Service Manager on a case-sensitive SQL instance.

clip_image012

 

The Service manager database called Servicemanager is the database that contains the

  • configuration items
  • work items
  • incidents

 

Type a Service Manager Management Group and select a security group for the SM admins.

clip_image014

The user name and password you provide here must be the same ones used for the Service Manager account on the data warehouse management server.

clip_image016

Make sure the account used as service manager service account is a local administrator.

 

clip_image018

On the Configure the Service Manager workflow account page, click Domain account, specify the user name, password, and domain for the account, and then click Test Credentials. Make sure that a The credentials were accepted. message displays, and then click Next

clip_image020

clip_image022

Select Install after reviewing the summary.

clip_image024

Verify that everything is installed correctly

clip_image028

When we look in SQL we see a new Database that has been created

clip_image026

After opening the console we see a lot of configuration that needs to be done but that’s for in a new post.

clip_image030

 

Have fun,

Alexandre Verkinderen