Need Most Recent Discovery to update in Data Source

[Saib1]

Hi ,

We have the excel file contain below data.

Created transform map to update the table based on the excel sheet and u_vm coalesce is true 

We need to update the Most Recent Discovery to be updated based on the data on the excel sheet. If there is no update , and excel sheet contain data it should get updated .  

How to implement?

[shloke04 · Accepted solution]

Hi @Shohaib 

Just saw your recent comment, what I have suggested should work for you. If not you can try with a Transform Script as below:

Write a On After Transform Script and use the script as below:

(function runTransformScript(source, map, log, target /*undefined onStart*/ ) {

	// Add your code here
	var sourceVM = source.u_vm.toString();
	var gr = new GlideRecord('Give your target Table Name here');
	gr.addQuery('name',sourceVM);
	gr.query();
	if(gr.next()){
		target.last_discovered = new GlideDateTime();
		target.update();
	}else{
		ignore=true;
	}

})(source, map, log, target);

Screenshot for reference below:

Hope this helps. Please mark the answer as correct/helpful based on impact.

Regards,
Shloke

[Saib1]

let me try the above script .

Scenario is 

[Saib1]

Thanks Shloke .

The above code worked for me.

[Saib1]

Hi Shloke,

On the below code you sent to me. I just applied it. It is working fine. And blank record is getting created after this  transform script put in my system.

var sourceVM = source.u_vm.toString();
	var gr = new GlideRecord('Give your target Table Name here');
	gr.addQuery('name',sourceVM);
	gr.query();
	if(gr.next()){
		target.last_discovered = new GlideDateTime();
		target.update();
	}else{
		ignore=true;
	}