ben chernys

www.softwaretoolhouse.com

Ben Chernys

Meta-Update

Software Tool House Inc.

Canada / Germany

Tel.: +49 (0) 162 175 0956

[email protected]


Data Migration ITSM 6 to 7 with

Meta-Update


Objectives

• ITSM 6 -> 7 Migration Challenges

• Project Overview

• Meta-Update: an introduction to an ARS data scripting tool giving ARS developers the power of the API

• Meta-Update Scripts: ITSM 6 -> 7 Migration

Agenda


ITSM 6 to 7 Migrations

• Completely different and more complex table layout. Many more tables and fields.

• Much more validation of data fields: Many values acceptable in 6 cannot be used in 7.

• Documentation sadly lacking.

Migration Challenges


ITSM 6 to 7 Migrations

• Each customer will have different desires with respect to field value transformation and mapping, Source and Target classes may be different, Historical requesters may not exist, Categorisations will be different.

Migration Challenges


Project

Project


Project Overview

• Data migration responsibility for end customer’s production migration weekend.

• BMC responsible for foundation data.• Fixed Price• Incidents, Changes, CMDB• Work with customer, implementation team.


Project Milestones

• Production Data Summary

• Data Mapping Sessions

• Mapping Document

• Full Migration to Development

• Production Migration

• Migration Results Document


Production Data Summary

• Investigation of production server data.

• Interviews with client’s data managers.

• Human analysis using both ARS tools and scripted schema and query tools tailored for the client’s production dataset.


Data Summary

Data Summary


Data Mapping Preparation

• Client’s data managers select a set of “root request” records to be brought over.

• Migration scripts are tailored and run taking over the selected “root request” records’ well formed trees.

Preparation


Data Mapping Sessions

• Held with client’s data managers once selected records brought over.

• Migrations of single, well formed trees take place during the session.

• Changes are made and results are immediate with a press of the refresh button.

Sessions


Sessions


Data Mapping Documents

• “Human generated” from scripts

• All records read and output identified and listed.

• Field by field assignments listed.

Mapping


Data Mapping Documents

Mapping


Scripts

Scripts


Introducing Meta-Update

Scripts



• Meta-Update is a Remedy ARS Data Integration, Server sync, File Import, Export, Batch and Workflow tool.

Meta-Update’s ROI is typically its first use.

Scripts

Meta-Update is a new way to harness the power of the ARS API: with no programming at all!

Meta-Update shortens API development by 90%



• creates repeatable, reliableharnessing the power of the API, with queries and assignments in a language your ARS Administrator already speaks.

Scripts

An ARS AdministratorCommand scripts,

Query = Src, HPD:HelpDesk, ‘Customer Name’ = “$Fle, Cust$” AND ‘Name’ = “$Fle, NmL$, $Fle, NmF$”


References

• ARS: $Field$

Scripts

A Tag is a reference to an ARS record, file record, SQL row, a named variable set, a diary entry, program arguments, the environment.

• Meta-Update: $Tag, Field$

A Field is an ARS field’s database name or id, a field defined from a file or SQL definition, a program argument, environment variable, assigned string variable name.


What is Meta-Update?

Scripts


Assignment Sections

• Status = Assigned• 7 = 2• Status = @if(“$X, Sta$” == “yy”) 2• Status = @if(“$X, Sta$” == “yy”, &

“Assigned”, “New”)• Status = @LookUp, StaX, $X, Sta$

Meta-Update Scripting


Assignment Sections

• Variable assignments

• Load records

• Perl compatible regular expressions

• Server processes

• External processes

• If then else

Meta-Update Scripting


ITSM 6 – 7 Scripts

Scripts


Three Entry Points

• One

Scripts

a single CI Root Asset, Help Desk Case, Change

• File a CSV of CI Root Assets, HPD Cases, Changes

• All All CI Root Assets, HPD Cases, Changes


Scripts



Scripts

CI Pre Assignments


Ben Chernys

Meta-Update


Canada / Germany

Tel.: +49 (0) 162 175 0956

[email protected]


Data Migration ITSM 6 to 7 with

Meta-Update