CIs not in maintenance found in em_impact_maint_ci even when evt_mgmt.maintenance_rule_include_retired = falseDescriptionRetired CIs found in em_impact_maint_ci when evt_mgmt.maintenance_rule_include_retired = falseSteps to Reproduce 01. Set a CI install_status to maintenance02. Run sys_trigger job "Event Management - Maintenance Calculato"03. Find em_impact_maint_cmdb_ci_alert record for CI04. Find em_impact_maint_ci record for CI05. Disable maintenance rule "Maintenance status of CI"06. Set CI install_status to retired, or any other status such as installed07. Run sys_trigger job "Event Management - Maintenance Calculato"08. Find em_impact_maint_cmdb_ci_alert record for CI09. em_impact_maint_ci record for CI no longer found for CI (expected)10. Enable maintenance rule "Maintenance status of CI"11. Run sys_trigger job "Event Management - Maintenance Calculato"12. Check CI is found under em_impact_maint_ci even though its install_status is retired or installed.WorkaroundPerform any update on the retired CIs (manual or automatic using script) and they will be removed from the em_impact_maint_ci tableRelated Problem: PRB1402652