Robust Transformer adding entires to cmdb_ci_comper and hardware_asset.

EricG
Kilo Sage

Has anyone successfully used the Robust Transformer for Asset Management.

 

I'm having difficulty getting the hardware_asset table to populate 

State (install_status)
Substatus

PO Number
Cost

Warranty End Date 

 

I can get my Asset to populate (cmdb_ci_computer) just fine.

The hareware asset record will populate the First couple of field, but not any further details.

Computer

EricG_0-1719001488688.png

 

 

Hardware Asset

EricG_1-1719001547653.png

As you see, the top part is fine.  But where's the stockroom, State = In stock, etc....

I've checked the logs, no errors.

EricG_2-1719001808440.png

 

My Transform is set up as follows:

EricG_3-1719001841080.pngEricG_4-1719001875850.pngEricG_5-1719001895323.png

Any thoughts how to get my hardware_asset details to populate?

The only issue i can possible see is my attempt to add 3 years to the Shipping date.

Which i'm not seeing in the logs.

 (function(batch, output) {
  // add your code here.
       for (var i = 0; i < batch.length; i++) {
 
         //step1: access the input variables
         var a = batch[i].input; //Value of the source field. 
 
         var b = new GlideDate(a);
		 b.addYears(3);

		 varNewDate = b;
 
         //step3: set the output for each elements
         output[i] = b;
		 gs.info('The new date is '+b+' from input '+a);
     }
 
 })(batch, output);

Not sure this is correct, and the Warranty End Date in the asset table is a date not a datetime field.

 

 

0 REPLIES 0