Transform map - Source Script

[ALe1]

 

 

Hey guys.

I'm working with a transform map. I have a spreadsheet with the "IP" field. I have a form with the "Configuration item" field from the "CMDB_CI" table. When importing the spreadsheet, the "configuration item" field needs to be automatically populated with the IP. In transform map, what is the best way to create a source script to impute this data?

I need to configure it so that the "IP" field in the spreadsheet is related to the IP of the item in the cmdb_ci table through a GlideRecord.

thanks.

[Jon23]

Hi @ALe1 ,

Could you simply use the field mapping the IP to the IP Address field?  This would avoid using a script.

[AshishKM]

Hi @ALe1 , 

You can direct map the IP (source ) to Target ( IP ) column.

As per the XLS sheet you attached, the staging table should have this IP column. 

-Thanks,
AshishKM

[ALe1]

Hello AshishKMishra

There's a detail. When attaching the spreadsheet, it will check the field (IP address) in the CMDB_CI table. If the IP registered in the spreadsheet exists in the CMDB table, the IP will populate a field called "Configuration Item" in another form.

[AshishKM]

Got it, checked the screen shot, the target table is Vulnerable Item and this configuration item field on this table ( form ) and you are trying to cross check the incoming IP in cmdb_ci table before updating the Vulnerable Item table.

let me know if we are on same page.