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
Hi Sanjiv,
i have takedn Computername:RQ-CANN, Serialnumber:3802LC2 is available in software installations, using this details i tried to create a record in computer table it is not accepted, we don't have any kind of existed records based on this serialnumber in list of Computer table
