Save a Database View to an Update Set

db_view_2_update_set.js

/*
Database View[sys_db_view]
Field Name[name]

View Tables [sys_db_view_table]
View [view] -> Database View

View Fields [sys_db_view_table_field]
View Table [view_table] -> View Table
*/
//***  Add view Name Here:
var view_name = 'sn_vul_nvd_di_and_cmdb';
//***  
var dbv_q = 'name=' + view_name;
var vt_q = 'view=';
var vf_q = 'view_table=';
var dbv = new GlideRecord('sys_db_view');
var vt = new GlideRecord('sys_db_view_table');
var vf = new GlideRecord('sys_db_view_table_field');
var um = new GlideUpdateManager2();
//Database View
dbv.addEncodedQuery(dbv_q);
dbv.query();
while(dbv.next()){
   // gs.info("CCCC DBV: " + dbv.name + " " + dbv.sys_id);//Works dbv
    um.saveRecord(dbv);
    //View table
    vt.addEncodedQuery(vt_q + dbv.sys_id);
    vt.query();
    while(vt.next()){
        //gs.info("CCCC vt: " + vt.view.getDisplayValue() + " " + vt.sys_id);//Works vt
        um.saveRecord(vt);
        //View Fields
        vf.addEncodedQuery(vf_q + vt.sys_id);
        vf.query();
        while(vf.next()){
            //gs.info("CCCC vf: " + vf.view_table.getDisplayValue() + vf.sys_id);//Works vf
            um.saveRecord(vf);
        }
    }
}
gs.info("CCCC finised saving Database View " + dbv.name + " to update set");