Scripting Practice question

Aditya_hublikar
Giga Sage

‎04-22-2026 12:02 AM

//last 3 latest updated incident
var gr=new GlideRecord('incident');
gr.orderByDesc('sys_updated_on');
gr.setLimit(3)
gr.query();
while(gr.next())
{
    gs.print(gr.number);
}


// incident group by with assignment group
var gr=new GlideAggregate('incident');

gr.addAggregate('COUNT','assignment_group');
gr.query();
while(gr.next())
{
    gs.print(gr.getDisplayValue('assignment_group')+" - "+gr.getAggregate('COUNT','asignment_group'))
}


// incident created in last 7 days
var date=new GlideDate();
date.addDays(-7);
var date1=new GlideDate();
var gr=new GlideRecord('incident');
gr.addQuery('sys_created_on','>',date);
gr.addQuery('sys_created_on','<',date1);
gr.query();
while(gr.next())
{
    gs.print(gr.number)
}


// category=network set priority=critical
var gr=new GlideRecord('incident');
gr.addQuery('category','Network');
gr.query();
while(gr.next())
{
    try
    {
        gr.impact=1;
    gr.urgency=1;
    gr.update();
    gs.print(gr.number)
    }
    catch(e)
    {
        gs.print(e)
    }

}

// fetch unique caller ids
var gr=new GlideAggregate('incident')
gr.groupBy('caller_id');
gr.addAggregate('count')
gr.query();
while(gr.next())
{
    gs.print(gr.getAggregate('count')+" - "+gr.getDisplayValue('caller_id'))
}

// all user having admin role
var gr=new GlideAggregate('sys_user_has_role');
gr.addQuery('role.name','admin');
gr.query();
while(gr.next())
{
    gs.print(gr.user.name);
}

// fetch incident older than 5 days
var date=new GlideDate()
date.addDays(-5);
var gr=new GlideRecord('incident');
gr.addQuery('sys_created_on','<',date);
gr.query();
while(gr.next())
{
    gs.print(gr.number)
}


// encrypt and decrypt
var encrypter = new GlideEncrypter();
var plainText = "Hello123";
var encryptedText = encrypter.encrypt(plainText);
gs.print("Encrypted Value: " + encryptedText);
var decryptedText = encrypter.decrypt(encryptedText);
gs.print("Decrypted Value: " + decryptedText);

// Write script to remove all attachments from an incident.
var gr=new GlideRecord('incident');
gr.addQuery('number','INC0012633');
gr.query();
if(gr.next())
{
    var ga=new GlideRecord('sys_attachment');
    ga.addQuery('table_sys_id',gr.getUniqueValue());
    ga.query();
    while(ga.next())
    {
        ga.deleteRecord();
    }
}