440 likes | 577 Views
Meta-Update Management Summary. Meta-Update in a Nut Shell ARS / ITSM Pain Points, How Meta-Update Helps Features & Benefits Customer Case Studies Software Tool House Services. Software Tool House Inc. Software Tool House is a BMC Partner. Ben Chernys. 2012-Mar-15. Release 5.17.
E N D
Meta-UpdateManagement Summary Meta-Update in a Nut ShellARS / ITSM Pain Points, How Meta-Update Helps Features & Benefits Customer Case StudiesSoftware Tool House Services Software Tool House Inc Software Tool House is a BMC Partner Ben Chernys • 2012-Mar-15 Release 5.17
Agenda Objectives
Meta-Update In a Nutshell • with no need for API or programming skills • with no staging forms, workflow, customizations, or • server changes
Time and effort savings • Sample CSV CI Import Meta-Update In a Nutshell Lists of Login IDs need to build CI Associations. Needs 2ndCSV to get Class, CTI. A UsedBy and OwnedBy column contain lists and need to generate appropriate associations. BMC_Disk “Size” attribute is a decimal. Needs normalization. Class dependent attributes.
Time and effort savings • Sample CSV CI Import Meta-Update In a Nutshell Done in two hours for a live WWRUG Presentation • Adequate skills in required areas assumed. • Management overhead can fluctuate wildly and is not considered. • Columns marked #N/A exceed staging forms and do not provide CSV handling required. Assumptions
Meta-Update In a Nutshell • Time and effort savings • Sample CSV CI Import Done in two hours for a live WWRUG Presentation
How Meta-Update Helps • Migrations • Corrections • Extracts • Integrations • Validations • Imports • ITSM releases, Legacy apps • Change, merge, adjust data at will • Save and create files of any kind • On-boarding, foundation data, CMDB data • .
Features & Benefits Features
Features & Benefits Features
Features & Benefits Features
Features & Benefits Benefits
Agenda Customer Case Studies
Case Studies Reference: LogicaUK
Case Studies Reference: LogicaUK
Case Studies Reference: LogicaUK
Case Studies Reference: Dataport
Case Studies Reference: Dataport
Case Studies Reference: Met Office
Case Studies Reference: Met Office
Case Studies Reference: Cassidian / EADS
Software Tool House Services Fixed Price ITSM Migrations
More Details • Links • These links include more slides. You will return here. More Information More about ARS Pain Points More about Meta-Update
More Information Next Steps www.SoftwareToolHouse.com • Check out the web site • Pick up a trial license with our Live Install and Scripting 101 presentation • Download the Scripting 101 presentation and the Meta-Update User’s Guide • Look at the samples in the Script Library • Contact Us at www.softwaretoolhouse.com We Thank You for Your Time Ben Chernys +49 171 380 2329 + 1 403 240 4377 Software Tool House is a BMC Partner
ARS / ITSM Data Pain Points ARS Data Pain Points • All ARS Applications represent “Requests” by trees of data records. • Records in different forms are connected by referencing data in those records. Three different keys for a single table. Request Id Change Number Instance Id Change Work Log Work Log Approvers Approvers Approvers Approvals Dependent tables have their own set of different keys and various combinations of their parent’s keys. Request Id Instance Id Change Request Id Change Number Change Instance Id
1,800 Forms • 25,000 Active Links • 8,000 Filters • 500 Join Forms Data is represented by a complex web of differently related records and tables. ARS / ITSM Data Pain Points ITSM Data Pain Points • The ITSM 7 Suite contains: Reference fields, and tables, are undocumented.
Request IDs (field 1) are used as references. ARS / ITSM Data Pain Points ITSM Data Pain Points • The ITSM 7 Suite contains: Reference fields, and tables, are undocumented.
On import, the symbolic name is looked up and the new ID reference is assigned. ARS / ITSM Data Pain Points ITSM Data Pain Points • The ITSM 7 Suite contains: Reference fields, and tables, are undocumented.
How Meta-Update Helps What is Meta-Update? • Meta-Update is an ARS API Data Scripting Tool. With Meta-Update, one develops proven, repeatable scripts that can be used over and over again. With Meta-Update, an ARS developer - not a programmer - can harness the power of the ARS API in record time!
Meta-Update is a new way to harness the power of the ARS API: with no programming at all! How Meta-Update Helps What is Meta-Update? • Meta-Update is an ARS API Data Scripting Tool. With Meta-Update, one develops proven, repeatable scripts that can be used over and over again.
How Meta-Update Helps References • ARS: $ Field $ • Meta-Update:$ Tag, Field $ A Field is an ARS field’s database name or id, a field defined in a file or SQL query, a program argument, an environment variable, assigned string variable name, regular expression extract, server process. 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 extends the concept of a reference by specifying a record with a field. This allows multiple records’ field values to be referenced.
How Meta-Update Helps References • ARS: $ Field $ • Meta-Update:$ Tag, Field $ A Tag is a reference to an ARS record, file record, SQL row, a named variable set, a diary entry, program arguments, the environment.
How Meta-Update Helps References • ARS: $ Field $ • Meta-Update:$ Tag, Field $ A Field is an ARS field’s database name or id, a field defined in a file or SQL query, a program argument, an environment variable, assigned string variable name, regular expression extract, server or client process.
How Meta-Update Helps References • ARS: $ Field $ • Meta-Update:$ Tag, Field $ A Field is an ARS field’s database name or id, a field defined in a file or SQL query, a program argument, an environment variable, assigned string variable name, regular expression extract, server process. A Tag is a reference to an ARS record, file record, SQL row, a named variable set, a diary entry, program arguments, the environment. With a few simple words, query results and files are iterated, records are looked up, references are made and used, and with all these Tags in memory at the same time, updates are made and files are output.
Meta-Update in a Nutshell What is Meta-Update?
Scripts Assignments What is Meta-Update?
Scripts Iteration What is Meta-Update?
Scripts Output What is Meta-Update?
Scripts Launch What is Meta-Update?
Scripts Assignments What is Meta-Update?