Book Image

Microsoft System Center 2012 Service Manager Cookbook

Book Image

Microsoft System Center 2012 Service Manager Cookbook

Overview of this book

Microsoft System Center Service Manager (SCSM) offers enterprises a complete, integrated platform for automating and adapting IT Service Management best practices to your organization's requirements. "Microsoft System Center Service Manager Cookbook" provides you with real-world, immediately usable recipes which will show you how to configure and administer System Center Service Manager 2012 and understand how to solve particular problems and scenarios to take this tool further. In Microsoft System Center Service Manager Cookbook, you will get to grips with practical recipes which will show you how to configure and administer System Center Service Manager 2012. This cookbook features distinct recipes on the practical implementation of ITSM Frameworks and Processes, Microsoft System Center 2012 Service Manager Administration, how to configure Service Level Agreements (SLAs). It will also cover incident and problem management, the design of change and release management as well as implementing and editing security roles.
Table of Contents (20 chapters)
Microsoft System Center 2012 Service Manager Cookbook
Credits
About the Authors
About the Reviewers
www.PacktPub.com
Preface
Index

Using a CSV file to import items into the CMDB


Sometimes you may want to bulk import configuration items into the CMDB. One way to do this is to import them using a Comma-Separated Value (CSV) file containing the CIs that relate to any class type or projection type already existing within Service Manager.

Getting ready

To import data using this method, two files are required, as follows:

  • A file containing the CIs to be imported; structured in a comma-delimited method and saved with a .csv extension.

  • A file that defines the class types or projection types used by all items in the CSV file. Also, this file defines the order in which the data appears as columns. The file must end with an .xml extension, and the authors recommend that the you match the first part of the XML file name to the first part of the CSV file name.

How to do it...

First we need to create the data file. In this recipe we will create a CSV file that will allow us to import some computer/server configuration items into Service...