CA Service Management

Expand all | Collapse all

Deleting Records in CMDB

Jump to Best Answer
  • 1.  Deleting Records in CMDB

    Posted 04-20-2017 07:35 AM

    How to delete records from CMDB???



  • 2.  Re: Deleting Records in CMDB

    Posted 04-20-2017 09:37 AM

    I don't think one can delete the records from ca cmdb .However I already see an idea for this CMDB cleanup utlity, remove old cmdb data which you can vote up for.



  • 3.  Re: Deleting Records in CMDB
    Best Answer

    Broadcom Employee
    Posted 04-20-2017 09:47 AM

    Manjunatha, out of box, you can create and use some archive/purge rules to archive and purge some CMDB data. For

    example, CMDB CI log, CMDB CI Inactive Transitions etc. However, if you are thinking about CIs/assets them self, it

    could be a bit tricky as those data are shared by other products so purge them is not a good idea, I think. You could use

    pdm_load to make some inactive but delete them from DBMS is not a good idea, I think.

    2cents here.

    Thanks

    Chi



  • 4.  Re: Deleting Records in CMDB

    Posted 04-20-2017 10:14 AM

    Chi is correct here - we NEVER recommend deleting any data from the MDB besides using the archive and purge rules.  The reason is because there may be other applications' data or other tables/data referencing the records that are deleted, which leaves dangling references in the database - which is technically data corruption. We would recommend that you inactivate records, but not delete them.

    Hope this helps,

    Thanks,

    Jon I.