Maintenance Rules - CI in Change Window default rule does not update Install Status

[Stacey Shapiro]

Out of the box, when running the  maintenance rule "CI in Change Window", the cmdb_ci status of matching CIs is not changed. However, matching CIs are flagged in the em_impact_maint_ci table by this rule and this status is considered for impact and alert calculations. My question is - has anyone made any customizations that would actually change the install status of the CI from "in use" to "in maintenance"? I know the impact tree indicates a CI is in maintenance but it seems like it would be logical to display it on the CI also? Looking for feedback. 

Thanks in advance!
Stacey

[Rahul Priyadars · Accepted solution]

This is how OOTB

Maintenance rule "CI in change window" will Populate the "em_impact_maint_ci" table only if all the following Conditions match.

1. Change request is Approved.
2. Change request is one of the following states(Scheduled, Implement, Open, Work In progress), we specifically query for the state values(state in (-2 ,-1 ,1, 2), 
3. The change request window is active

-If the Choice list for state (Scheduled, Implemented, Open, work in Progress) is mapped to any of the other values other than (-2,-1,1,2), maintenance rule will ignore it and CI will not be updated in the em_impact_maint_ci table.

-Maintenance rule "CI in change window" will not change the operational status of the CI to maintenance. It will only create an entry in the CI in the em_impact_maint_ci table.

I have not done Customization for this but - I think a BR on Insert of record in Table em_impact_maint_ci 

can achieve what you are looking for.

See if this helps you

https://community.servicenow.com/community?id=community_question&sys_id=780fc235db1514d05ed4a851ca96195b

Regards

RP