alerts for one server are not showing in SOI

Products

• CA Service Operations Insight (SOI)

Issue/Introduction

alerts for one server are not showing in SOI

Resolution

verify Cis data from SOI database with below sql

 

/* Get CIs */

select * from CIStaging where CINamespaceMapID = 'device_name';

select * from ca_ssa_ci_detail where c_mdrelementid = 'device_name';

select * from ca_ssa_notebooks where sheetid = from above output

select * from Alerts where ModelElementID = 'device_name'

select * from ca_ssa_ci_detail where c_mdrelementid = '<MDRAlarmID from above output>'

select * from ca_ssa_alert where c_alertedmdrelementid = 'device_name'

 

Delete Cis(device_name) and related data from SOI database using below sql query.

 

/* delete placeholder Cis and Cis for device_name*/

delete from Alerts where ModelElementID = 'device_name'

delete from ca_ssa_ci_detail where c_mdrelementid = '<MDRAlarmID from <select MDRAlarmID from Alerts where ModelElementID = 'MyMachinePlace'> >'

delete from ca_ssa_alert where c_alertedmdrelementid = 'device_name'

delete from ca_ssa_notebooks where sheetid = <sheetid from <select * from ca_ssa_ci_detail where c_mdrelementid = 'MyMachinePlace';>>

delete from ca_ssa_ci_detail where c_mdrelementid = 'device_name';

delete from CIStaging where CINamespaceMapID = 'device_name';

 

 

After cleanup above data from database. Please recycle SOI services as per recommended steps