CA Service Management

  • 1.  Transferring basic conf item data between ci_ tables

    Posted Mar 03, 2017 11:24 AM

    Is there a way to transfer "placeholder" records from one ci_ table to another?  Is say "placeholder" because most of assets' configuration item info has not been populated (ie only the uuid, creation date, and creation user is in each record).

     

    I am working on a project, cleaning up our configuration items and unfortunately, many of the ca_model_def items have inconsistently used class/family codes.  Using pdm_userload to update the class/family of models will not necessarily automatically delete the placeholder record in its old ci_ table and create a brand new one in the ci_ table to which its new class/family is.

     

    Has anyone come up with a clean process to transfer UUID, create date, create user from one ci_ table to another?



  • 2.  Re: Transferring basic conf item data between ci_ tables

    Posted Mar 06, 2017 01:08 PM

    HI scottstineman ,

     

     CI's has a group of tables, and you need to update all.

     

    For best practices you need to use GrLoader.

     

    CA SDM: GRLoader - Everthing you need to know - Loading Configuration Item 

     

    Regards



  • 3.  Re: Transferring basic conf item data between ci_ tables

    Posted Mar 06, 2017 04:43 PM

    Thanks Tiago.  I had heard about grloader.  Now I have a good reason to learn how to use it.