Data sources clean-up/update for Service Manager

11:17 am in Uncategorized by kurtvh


In this blog I want to share some experience with importing data in Service Manager. As you probably already now, you can automatically import CI’s (and other object) in Service Manager via connectors. SCSM connectors are available for Active Directory, System Center Configuration Manager, Operations Manager & CSV file import.

Information from Active Directory, OpsMgr, ConfigMgr or CSV is imported in SCSM and in this way you can keep your CI’s in SCSM in sync with the “source” in an automated way. Nice functionality and it’s a real added value of SCSM, but there are some attention points. Be aware that you are going to use this information and maybe build some automation in SCSM based properties of the CI’s… If certain properties are not available or up-to-date then this could break your automation, ending up with for example incidents in the wrong queue and so on. This could negatively impact the KPI reporting…

This blog provides an overview on how you could check/update/adjust/complete the data sources before you start importing the information in Service Manager.

Active Directory data sources:

  • Issues
    • AD object that are expired or not used anymore
    • AD object properties that are not filled in or wrong information is specified
    • Missing AD accounts
  • Cleanup/Update/Adjust information
    • There are a lot of AD tools available to accomplish this task.
      • In case of you need bulk adjustment of settings for your environment then you need something powerful. There are some xls sheets with vba code behind that can do the job, but there is also a very powerful tool ADModify that has functionality to do bulk changes. Watch out with this tool, think before hitting the “Next” button !!!
      • Some examples of AD cleanup tooling: Hyena, JiJi Active Directory Cleaner or AD Janitor (These are not free tools!)
      • If you don’t want to pay for such tooling you always have the scriptable way to accomplish this task. Check Microsoft script center for some example scripts.
    • Hey, if you have Opalis available in your environment, then you could create a workflow to do some AD maintenance…
  • Mapping Active Directory Domain Services Attributes to Service Manager Properties

System Center Configuration Manager data sources:

System Center Operations Manager data sources:

  • Two connectors exist for the integration of OpsMgr with SCSM.
    • Alerts connector
    • CI connector for objects discovered by SCOM
  • Issues
    • Noisy OpsMgr environment is raising to many incident work items.
    • OpsMgr discovered objects are not available in SCSM.
  • Cleanup/Update/Adjust information
    • For the alerts:
      • try and understand what is causing the alerts in the first place.  Attempt to tune these alerts to reduce the number of tickets in SCSM
      • Check the documentation that is delivered with the mgmt pack, for many of them there is very useful information in these docs
      • You probably have to work together with your monitoring team to clean and make it work like you want.
    • CI’s via OpsMgr
      • All you need is the management packs that contain the service model i.e. classes/properties, and relationship types to make them visible in SCSM.
      • Generally the service model is defined in Discovery or the Library MP so you could just import those MPs.
      • There is a nice tool to compare mgmt packs between SCOM & SCSM:
      • Service Manager maintains a list of Allowed classes. You can mange the Allowed List using PowerShell – managing-the-allowed-list-for-the-operations-manager-ci-connector-with-powershell.aspx
  • SCOM information that is synchronized
    • Organizational Unit (AD OU)
    • Network Name
    • IP Address
    • DNS Forest Name
    • NetBIOS Computer Name
    • Virtual Machine (True/False)
    • Logical Processors
    • DNS Domain Name
    • Hosts Windows Computer Role
    • Hosts System Center License
    • Hosts Windows Local Application

I hope this blog provides you with some information to start discussing the data sources cleanup/adjustments with the different teams in your environment.

Have fun,

Kurt Van Hoecke