CA Service Management

Expand all | Collapse all

remove entry in ca_owned_resource as well as usp_owned_Resource

  • 1.  remove entry in ca_owned_resource as well as usp_owned_Resource

    Posted Apr 25, 2016 10:24 AM

    Hi team,

     

    I want to remove some entries in ca_owned_Resource table

     

    for ex:

     

    I have a ci name called"test1234" with owned_resource_uuid=0xB1234BdfdaDqkjl1123421

     

    I have extracted the above entry --pdm_extract -vf "select * from ca_owned_resource where id=0xB1234BdfdaDqkjl1123421">test.txt

     

    and I have remove the above entry --- pdm_userload -vrf test.txt

     

    After that I checked in database that the above entry is not there in main table ca_owned_Resource which is good but still I can see the entry in usp_owned_Resource with the above uuid=0xB1234BdfdaDqkjl1123421.

     

    Pdm_extract with option -r does not remove data from main as well as extenstion table?

     

    My Question is there is a way to remove data from ca_owned_Resource and usp_owned_Resource tables at a time

     

    If yes can you provide the steps



  • 2.  Re: remove entry in ca_owned_resource as well as usp_owned_Resource

    Posted Apr 26, 2016 02:36 AM

    The text file read by pdm_load/pdm_userload can contain entries from multiple tables so you can do two extracts, one for each of the tables related to CIs, appending the results to a single text file and then remove them on one go just like you did with the single table entries.