Need to send the notification on 7thday of ritm created and only once.

[suuriya]

Hi,

I have created a scheduled job which runs daily, it triggers an event and sends the notification.

Background: once the request is raised for particular catalog after 7 days it will send out the remainder notification if the asset state is still pending which is working as expected but the thing is from 7th day it started sending notification on regular basics ex: same notification is getting triggered at 8th day 9th 10th and so on till the state changes. But i need this to be sent only once on the 7th day of the ritm created.

Please let me know how we can achieve this

My scheduled job script:

var asset_status;

var asset_date,cdate,dateDiff;

cdate = new GlideDate();

var ci = new GlideRecord('sc_req_item');

ci.addQuery('cat_item','47fef0cf1077a480594b72415810721e');

//ci.addQuery('sys_id','114385c8931c0690c8a5ba5d6cba104c');

ci.addActiveQuery();

ci.query();

while(ci.next())

{

    //gs.log("IDM test" + ci.variables.common_vars_requested_for.active);

    if(ci.variables.common_vars_requested_for.active !=true)

    {

        //gs.log("IDM test" + ci.variables.common_vars_requested_for.active);

    if(ci.variables.asset_status_change_date != '')

    {

        //gs.log("IDM inside if");

    asset_date = ci.variables.asset_status_change_date;

    var asset = new GlideRecord('alm_hardware');

var encodedQuery = 'model.u_sub_type!=VPC^assigned_to.nameSTARTSWITH' + ci.variables.common_vars_requested_for.name;

asset.addEncodedQuery(encodedQuery);

asset.query();

while (asset.next()) {

    if(asset.install_status =='106')

    asset_status = 'true';  

}

if(asset_status == 'true')

{

dateDiff = gs.dateDiff(asset_date,cdate);

if(dateDiff >= '7')

gs.eventQueue("notify.manager.idm.second",ci,ci.variables.common_vars_requested_for.manager);

}

    }

    }

}

[AshishKM]

Hi @suuriya , 

My suggestion is to apply this schedule job on Approver table instead of RITM table with follwoing condition and you can add catalog item filter along with other RITM variables to reterieve the data.

-Thanks,

AshishKM

[suuriya]

HI @AshishKM ,

Thanks for the reply.

But i didn't get it can you please elaborate if possible with the script.

Thanks,

Suuriya