Background Script to Retire CI's and remove relationship of CI's

[MC30]

Hi Experts,

Can anyone please help me to write a Background/Fix script: Below is the requirement. Kindlty help

1. If the "Most recent discovery" is before 3 days from present date:

2. then we have to remove the service offerings (Relationship type: Contained By) and mapped application services (Relationship type: Used By) which are related to the application server:

3. Make the "STATUS" and "OPERATIONAL STATUS" as "RETIRED":

Thanks in Advance.

[Vishal Birajdar]

Hello ,

Can you try this once.

var grRel = new GlideRecord('cmdb_rel_ci'); //relationship table
var gr = new GlideRecord('cmdb_ci'); //ci table
gr.addEncodedQuery('Your Query');
gr.query();

while (gr.next){
//add query on relationship table
grRel.addEncodedQuery('type=contained by^ORtype=usedby^parent=' + gr.parent);  //Parent or child its up to you
while(grRel.next()){
grRel.parent ='';
//or
grRel.child='';

gr.status ='retired';
gr.operational_status = 'retired';
}
}

[MC30]

Hi Vishal,

Thanks for your response. The thing is if a CI that is going to be retired is having another CI in the relationship then that CI's should also be checked wether it have any relations and then we need to retire that CI's and then we need to retire the main CI. I am really confused and seeking the help.

We need to build a script may be a schedule job as per the instrauctions given in the attached word document. The instructions given in the word document are done manually by users, now they are requesting for a script as they are getting many CI's in bulk to retire. 

Thanks in advance

[doug_schulze]

We actually do alot of this work in this post, update sets and all...