Create request from Business Rule

[alhicks]

We're trying to create a request when a user is Terminated and the user is the Assigned To on any Active computers.   I'm having trouble query active computers and assigning the requested for as the actual terminated user.   I only want the business rule to open a request if the user was terminated and have active ci's assigned to them.  

Business Rule on sys_user table.

After Update

Conditions: current.u_status.changesTo('T')

Script:

var user = current.sys_id;

var compRec = new GlideRecord("cmdb_ci_computer");

compRec.addQuery('assigned_to',user);

compRec.addQuery('install_status', '!=', 7);

compRec.query();

if(compRec.next()) {

}

CartFunction();

function CartFunction() {

    gs.include('Cart');

    var cart = new Cart();

    var item = cart.addItem('440f9f7c0a0a3c4900a93fcfd4d82084');

        cart.setVariable(item,'contact_type',"Automation");

    cart.update();

    var cartGR = cart.getCart();

    cartGR.requested_for = current.user.setDisplayValue();

    cartGR.update();

    var rc = cart.placeOrder();

  }

[sr82]

Thanks for reverting back Chris, I have got a custom Business rule that looks for insert of user in sys_user table and at which point opens a catalog Request. The script I pasted earlier is doing what I have just mentioned, since I am going through sc_cart I notice that on the checkout page there is requested date field which I would like to move to the u_requested_date on the REQ. I have created a new u_request_date field on the sc_cart table but even then the requested_date is not getting copied to the REQ.

Checkout page:

sc_cart page:

Request:

[Ivano B]

Hi Andrea

A Couple of questions.

Do you have problem with the actual code ?

Do you want to create a requested item for each active CI ?

Cheers

Robo

[alhicks]

Hello,

Christopher's script worked.   We're actually going to create one request per user.

Thank you so much for the reply...