SDU - User contributions [en]

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:46:43Z

Ribru02:

SPELL - Cancel and Add events based on the scheduling time in CO in ServiceDesk Manager R12.5

This code add 2 events to CO one that fires at 50% of the scheduled time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

'''STEP1'''

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/mods/majic with the following code, and restart the service desk:

<source lang=" text">
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};
</source>

'''STEP2'''

SPELL code create a z_my_event_sched_end_date.spl and put at $NX_ROOT/site/mods/majic with the following code and kill the process spel_srv or restart the servicedesk:

<source lang="javascript">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
//UPDATE YOUR EVENTS HERE
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:31:39Z

Ribru02:

SPELL - Cancel and Add events based on the scheduling time in CO in ServiceDesk Manager R12.5

This code add 2 events to CO one that fires at 50% of the scheduled time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

'''STEP1'''

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/majic with the following code, and restart the service desk:

<source lang=" text">
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};
</source>

'''STEP2'''

SPELL code create a z_my_event_sched_end_date.spl and put at $NX_ROOT/site/majic with the following code and kill the process spel_srv or restart the servicedesk:

<source lang="javascript">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
//UPDATE YOUR EVENTS HERE
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:30:35Z

Ribru02:

SPELL - Cancel and Add events based on the scheduling time in CO in ServiceDesk Manager R12.5

This code add 2 events to CO one at 50% of the time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

'''STEP1'''

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/majic with the following code, and restart the service desk:

<source lang=" text">
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};
</source>

'''STEP2'''

SPELL code create a z_my_event_sched_end_date.spl and put at $NX_ROOT/site/majic with the following code and kill the process spel_srv or restart the servicedesk:

<source lang="javascript">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
//UPDATE YOUR EVENTS HERE
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:28:28Z

Ribru02:

SPELL - Cancel and Add events based on the scheduling time in CO in ServiceDesk Manager R12.5

This code add 2 events to CO one at 50% of the time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

'''STEP1'''

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/majic with the following code, and restart the service desk:

<source lang=" text">
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};
</source>

'''STEP2'''

SPELL code create a z_my_event_sched_end_date.spl and put at $NX_ROOT/site/majic with the following code and kill the precess spel_srv or restart the servicedesk:

<source lang="javascript">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
//UPDATE YOUR EVENTS HERE
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:27:06Z

Ribru02:

SPELL - Cancel and Add events based on the scheduling time in CO

This code add 2 events to CO one at 50% of the time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

'''STEP1'''

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/majic with the following code, and restart the service desk:

<source lang=" text">
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};
</source>

'''STEP2'''

SPELL code create a z_my_event_sched_end_date.spl and put at $NX_ROOT/site/majic with the following code and kill the precess spel_srv or restart the servicedesk:

<source lang="javascript">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:24:53Z

Ribru02:

== SPELL - Cancel and Add events based on the scheduling time in CO ==

This code add 2 events to CO one at 50% of the time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/majic with the following code, and restart the service desk:

<source lang=" text">
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};
</source lang>

<source lang="javascript">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:22:45Z

Ribru02:

OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};

<source lang="SPELL">
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 2

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:7649776";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:7649777";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (DEBUG == 2) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_nuu
m, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_50,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG == 2) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date
%s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_new);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG == 2) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

</source>

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:13:38Z

Ribru02:

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:12:05Z

Ribru02:

{
OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:11:30Z

Ribru02: Replacing page with 'OBJECT chg { TRIGGERS { POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && ac...'

SPELL CODE to to add event at 50% and 75% of the time between schedule start time and duration

2011-02-11T09:05:28Z

Ribru02: SPELL - Cancel and Add events based on the scheduling time in CO

SPELL - Cancel and Add events based on the scheduling time in CO

This code add 2 events to CO one at 50% of the time and another at 75%.

The 50% starts at sched_start_time and fires at sched_start_time + duration /2
The 75% starts at sched_start_time and fires at sched_start_time + duration /4*3

Whenever there is a change this code check if there are similar events and cancel them.

Trigger to add, create a z_my_event_sched_end_date.mod and put at $NX_ROOT/site/majic with the following code, and restart the service desk:

OBJECT chg {
TRIGGERS {
POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
};
};

SPELL code create a z_my_event_sched_end_date.spl and put at $NX_ROOT/site/majic with the following code and kill the precess spel_srv or restart the servicedesk:
////////////////////////////////////////////////////////////////////////////////
// Module: z_my_event_sched_end_date.spl
// Created: 10-02-2011
// Author: ribru02@ca.com
////////////////////////////////////////////////////////////////////////////////
// Description:
//
// Spel to add event when sched_duration or sched_start_date are inserted or updated
// Add and remove fixed events. Add 2 events one to advise at 50% of the elapsed time and other for 75% of the elapsed time
// Starting the event at sched_start_time delaying it duration/2 (50% between start and end sechduled time)
// Starting the event at sched_start_time and delaying it duration/4*3 (75% between start and end sechduled time)
//
//Fired with the following trigger:
//OBJECT chg {
// TRIGGERS {
// POST_VALIDATE z_my_event_sched_end_date( persistent_id, sched_start_date, sched_end_date, sched_duration) 250 FILTER( EVENT("INSERT UPDATE") && active != 0 && sched_start_date != NULL && sched_duration >0);
// };
//};
//
////////////////////////////////////////////////////////////////////////////////
//History
//v1.0 - ribru02@ca.com - First version
////////////////////////////////////////////////////////////////////////////////
#define VERSION "v1.0"

// DEBUG 0 for no debug
// DEBUG 1 for debug

#define DEBUG 1

chg::z_my_event_sched_end_date (...)
{

////////////////////////////////////////////////////////////////////////////////
//vars
////////////////////////////////////////////////////////////////////////////////
date schedule_start_date_old,schedule_start_date_new, schedule_start_date_75;
duration duration_schedule_old,duration_schedule_new, duration_50, duration_75;
string event_name_50, event_name_75, event_name_50_tmpl_persid,event_name_75_tmpl_persid;
object atev_dob, atev_list, group_leader;
string persistent_id,method;
string wc;
int atev_count, i;

method = "z_my_event_sched_end_date"+"_"+ VERSION;

persistent_id=argv[3];
schedule_start_date_old = argv[5];
schedule_start_date_new = argv[6];
duration_schedule_old = argv[11];
duration_schedule_new = argv[12];
//'''Bold text'''ADD YOUR EVENTS INFORMATION HERE'''Bold text'''
event_name_50= "Increase Priority base on scheduled time 50%";
event_name_50_tmpl_persid="evt:400001";
event_name_75= "Increase Priority base on scheduled time 75%";
event_name_75_tmpl_persid="evt:400002";

////////////////////////////////////////////////////////////////////////////////
//Previous validation
//If there is no change in one of the field there is no calculation
///////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"=========== START : %s %s:%s ===========",method,type,chg_ref_num);
if (!((schedule_start_date_old == schedule_start_date_new) && (duration_schedule_old == duration_schedule_new)))
{
//getting group leader
send_wait(0, top_object(), "get_co_group");
group_leader = msg[0];
////////////////////////////////////////////////////////////////////////////////
//calculation metrics
//fire 50% and new event fire 75% of time duration
////////////////////////////////////////////////////////////////////////////////
duration_50=(duration)((int)duration_schedule_new/2);
duration_75=(duration)((int)duration_schedule_new/4*3);

////////////////////////////////////////////////////////////////////////////////
//debug Info
////////////////////////////////////////////////////////////////////////////////

if (DEBUG) logf(SIGNIFICANT,"%s - CO nº %s - NºArgs: %s => %s = %s -> %s| %s = %s -> %s | %s = %s -> %s ", method, chg_ref_num, argv[0],argv[4], argv[5], argv[6], argv[7],argv[8], argv[9], argv[10], argv[11],argv[12]);

////////////////////////////////////////////////////////////////////////////////
//remove existing events before adding new ones
////////////////////////////////////////////////////////////////////////////////

// Identify the persids of the events to be deleted.
wc = format("(event_tmpl = '%s' OR event_tmpl = '%s') AND obj_id = '%s' AND status_flag = 2", event_name_50_tmpl_persid,event_name_75_tmpl_persid,persistent_id);
send_wait(0, top_object(), "call_attr", "atev", "sync_fetch", "STATIC", wc, -1, 0);
atev_list = msg[0];
atev_count = msg[1];
if (DEBUG) logf(SIGNIFICANT, "%s - need to cancel %s event for CO %s", method, atev_count,chg_ref_num);
if (atev_count > 0) {
for (i=0;i<atev_count;i++) {
send_wait(0, atev_list, "dob_by_index", "DEFAULT", i, i);
atev_dob = msg[0];
send_wait(0, group_leader, "checkout", atev_dob);
send_wait(0, atev_dob, "cancel_me");
send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - error cancelling event for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully canceled event for CO %s", method, chg_ref_num);
}
}
}

////////////////////////////////////////////////////////////////////////////////
// Add events 50% and 75% of the duration time
////////////////////////////////////////////////////////////////////////////////
schedule_start_date_75 = (date)((duration)schedule_start_date_new + duration_50);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_50,(duration)duration_50,(date)schedule_start_date_new,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

if (DEBUG) logf(SIGNIFICANT, "%s - Command executed in CO nº: %s to add event: %s - duration: %s - start_date %s", method, chg_ref_num,event_name_75,(duration)duration_75,(date)schedule_start_date_75);
send_wait(0,top_object(),"call_attr","evt","new_attached_event", group_leader,persistent_id,event_name_75,(duration)duration_75,(date)schedule_start_date_75,"INCPRI",0,0,"");
if (msg_error())
{
logf(ERROR, "%s - error new_attached_event failed for CO %s - %s", method, chg_ref_num, msg[0]);
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - successfully new_attached_event for CO %s - %s", method, chg_ref_num, msg[0]);
}

send_wait(0, group_leader, "checkin");
if (msg_error())
{
logf(ERROR, "%s - Add event checkin failed for CO %s - %s", method, chg_ref_num, msg[0]);
send_wait(0, group_leader, "uncheck");
}
else
{
if (DEBUG) logf(SIGNIFICANT, "%s - Add event checkin successfull CO %s - %s", method, chg_ref_num, msg[0]);
}
}
if (DEBUG) logf(SIGNIFICANT,"=========== END : %s %s:%s ===========",method,type,chg_ref_num);

}

Sample Customizations

2011-02-11T08:56:37Z

Ribru02: /* List of Customizations */

__NOTOC__
[[Category:Customization]]
{{Global Header}}
{{Global Announcement}}

== Overview ==
Customizations are regarded as changes to the system that are not supportable by CA.

== List of Customizations ==
[[image:exclaim.gif]][[SDU:SDU r12 EP1|SDU Enhancement Pack 1 for r12]]
*[[Action Macro to Log Solution and Resolve Ticket]]
*[[Add Checkbox, Date, Drop-down, Lookup, Readonly and Text Fields to Properties]]
*[[Add Contact Search to Employee/Customer Interface]]
*[[Add Custom Activity Log Action Macro]]
*[[Add Log Entry for Updates to Custom Fields]]
*[[Add Log Entry When a Property Value Changes on a Ticket]]
*[[Add Personalized Response to Manual Notification]]
*[[Add Posted By to Announcements Page]]
*[[Add Properties Count to Area/Category List]]
*[[Add Ticket and CI Links to Announcements]]
*[[Add Workflow to Employee/Customer Interface]]
*[[Attachments on Configuration Items]]
*[[Attachments on Contacts]]
*[[Auto-fill Fields Left Blank]]
*[[Automatically Attach an Asset/CI to a Change Order or Issue]]
*[[Automatically Remove Attached Events]]
*[[Automatically Set Assignee to Closing Analyst]]
*[[Automatically Set System Generated Activities to Internal]]
*[[Changing Announcements Order By]]
*[[Changing Error Alert Color and adding Error Alert Pop-ups]]
*[[Changing Requests to Incidents]]
*[[Changing Display of Contacts]]
*[[Conditional Display of Drop-Down Content]]
*[[Conditionally Attach an Event]]
*[[Control the Request Areas Displayed to the End Users]]
*[[Count Ticket Reopens]]
*[[Custom Lookup method for TextAPI]]
*[[Displaying the System and User Descriptions in the Activity Log]]
*[[Display Web Site within Service Desk]]
*[[Default Properties Tab on New Ticket Creation]]
*[[Generate Notifications Only for Employee Comments]]
*[[Increasing Default Field Size]]
*[[List Tickets ORDER BY Group]]
*[[Make a Field Conditionally Required]]
*[[Modify Action and Condition Macros via the GUI]]
*[[Only Assignee can Close]]
*[[Prevent Close of Requests/Incidents/Problems if Change Order is Active]]
*[[Prevent Update to Past Activities]]
*[[Propagate Solution to Children]]
*[[Propagate Status to Children]]
*[[Priority and Impact Default to Empty]]
*[[Refresh Customer Info Before Saving the Ticket]]
*[[Remove Second Message on Timeout]]
*[[Remove SLA Violation from Employee View]]
*[[Require a Solution in Order to Resolve]]
*[[Require Assignee to be a Member of the selected Group]]
*[[Search Requests, Incidents, and Problems Simultaneously for Ticket Number]]
*[[Send Notification at Callback Time]]
*[[Send Notification to CI's Attached Contacts]]
*[[Send Survey based on Variables]]
*[[Separate Prefixes for Requests, Incidents, and Problems]]
*[[Set Defaults on Manual Notify]]
*[[Set Priority Based on Urgency and Impact]]
*[[Set Request/Incident/Problem Status from Change Order]]
*[[Set Request/Incident/Problem Status on Dispatch Change]]
*[[Simplified Child Creation]]
*[[Single Sign-on with Cookies]]
*[[EIAM Services dont start on fresh install]]
*[[SPELL CODE to Make ACT / EVT INTERNAL]]
*[[SPELL CODE to to add event at 50% and 75% of the time between schedule_start_time and duration ]]