1. As per Client system setup Definitely Last corporation record of u_node field will be empty .So we need that last corporation record of Name.

 i have ran your code but it was not giving any result

 

2. Are we increasing "repeat " value ? is that defined some where in script ? kindly help me where you defined that "repeat " increasing line.

 

------------------------------------------------------------------------------------

i have created small script to check u_node sys_id and name . but not sure it is giving wrong u_node .

var Hgr = new GlideRecord('u_corporation');
Hgr.addquery('sys_id', 'af501518071e011022f2f16c7c1ed070'); //test 1, Test1 of u_node is Test2
Hgr.query();
if (Hgr.next()) {

gs.addInfoMessage(gs.getMessage('Gate:' + Hgr.getDisplayValue('u_node') + "---" + Hgr.u_node));
}