How to move one table of related list records into another table of related list table

[chanikya]

My request is: i would like to see software installation records under  Computers(cmdb_ci_computer)  table of related list table Software installations....

In Both tables - Related list table is same (software installation)

Condition: computer table of record name and Arrived computer of record name if it match then only move related table records from Arrived computer table related record's.. 

howcan i do it..

My script is not working....Schedule Jobs

var comp = new GlideRecord('cmdb_ci_computer');
comp.addQuery('u_computername',current.sys_id);
comp.query();
while(comp.next()){
var arc = new GlideRecord('u_arrived_computers');
arc.addQuery('name',comp.name);
arc.query();
if(arc.next()){
var soft = new GlideRecord('cmdb_sam_sw_install');
soft.addQuery('u_computername',arc.sys_id);
soft.query();
while(soft.next()){
gs.log(soft.getRowCount());
soft.u_computername= comp.sys_id;
soft.update();
}
}
}

Here , if you click on computer name it is navigated into Arrived computer table..

 

i wanna see installations record under computer record

if you wanna more information i can explain you clearly .....

please help me here, where i am going wrong here

[Michael Ritchie]

I see you have duplicated your question again from this thread:

https://community.servicenow.com/community?id=community_question&sys_id=3ec195a5db7d5700fac7f4621f96...

In the future I would suggest not duplicating questions in separate posts.  As mentioned in that thread, your u_arrived_computers table is custom and in order for people to help you need to explain the purpose of that table.

[chanikya]

Hi, Purpose of this , we are creating reports based on computer table, which computer record having how many installation records.. .for this case only we just created some specific slected name of computer records in computer table, which computer names are already available in "Arrived computer"table.

Can you help me, how to populate installation records in computer record under computer table

[chanikya]

Can I expect any updates?

[SanjivMeher]

Can you post me a full screenshot of a record in u_arrived_computers table?

Also show me the dictionary record of u_computername field. If it is a reference field to u_arrived_computers table already, you can use that field to map it to cmdv_ci_computer table.