Welcome to Community Week 2025! Join us to learn, connect, and be recognized as we celebrate the spirit of Community and the power of AI. Get the details  

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