Disable CI in CMDB

[samoliveira]

I have a corrupted CI (Central Interaction). 
When I access its record, I get a "(Record not found)" message. 
I've tried disabling it through the table, deleting it from the table, and even creating a script and running a deletion script in Fix Scripts, but the record remains active in the cmdb_ci table.

Can anyone help me with this?

[Tanushree Maiti]

Hi @samoliveira 

Run this in System Definition > Scripts - Background (or Fix Scripts):

var ciSysId = 'YOUR_CORRUPTED_CI_SYS_ID';
var gr = new GlideRecord('cmdb_ci');
if (gr.get(ciSysId))
 {
    gr.deleteRecord();     gs.print('CI Deleted: ' + ciSysId);
} else {
    gs.print('CI not found in cmdb_ci: ' + ciSysId);
}

[samoliveira]

HI, 

I ran the script you sent me, and unfortunately, CI is still listed in cmdb_ci.

Do you have any other ideas on how to disable it?

[Eliz Skogquist]

How are you "seeing" it in cmdb_ci, via a list view or otherwise?

[samoliveira]

I'm viewing CI as a list.