Book Image

Microsoft System Center 2016 Service Manager Cookbook - Second Edition

By : Steve Buchanan, Steve Beaumont, Anders Asp, Dieter Gasser, Andreas Baumgarten
Book Image

Microsoft System Center 2016 Service Manager Cookbook - Second Edition

By: Steve Buchanan, Steve Beaumont, Anders Asp, Dieter Gasser, Andreas Baumgarten

Overview of this book

Keep your organization up to speed with the Microsoft System Center 2016 Service Manager Cookbook. Over 100 practical recipes for SCSM 2016 give you all the tools to master IT service management.
Table of Contents (23 chapters)
Microsoft System Center 2016 Service Manager Cookbook - Second Edition
Credits
Foreword
About the Authors
About the Reviewers
www.PacktPub.com
Customer Feedback
Preface

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 you match the first part of the XML filename to the first part of the CSV filename.

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 Manager...