CMDBUtil - Global

//Where current is a GlideRecord and action is the current UI action
var base = new SNC.CMDBUtil();
base.baselineProposedChangesApplyChanges(current);

//Where current is a GlideRecord and action is the current UI action
var base = new SNC.CMDBUtil();
base.baselineProposedChangesGenDIFF(current, action.get('sysparm_changeset'));

var base = new SNC.CMDBUtil();
base.createCIRelationship('<parent_ci_sys_id>', '<child_ci_sys_id>, 'Contains', 'Contained by');

//Where cmdv_ci_computer is a table.
var output = SNC.CMDBUtil.getAllChildrenOfAsCommaList('cmdb_ci_computer');
gs.print(output);

var util = new SNC.CMDBUtil(); 
var cmdbViews = util.getCMDBViews();
gs.info(cmdbViews);

// Note that the output in the example is type: java.util.ArrayList
// To convert to JS Array, use ArrayUtils (add these lines preceding gs.info):
// var arrUtil = new global.ArrayUtil();
// var arrViews = arrUtil.convertArray(cmdbViews);

[View 3, View 1, View 2, Another view]

var gr = new GlideRecord('incident');

// Querying the incident table
gr.addQuery('number','INC0000005'); 
gr.query();


if(gr.next()){
  // Find the list of parent tables for Configuration item field of this Incident
  var ciParent = SNC.CMDBUtil.getTables0(gr.cmdb_ci.sys_class_name); 
  gs.print("Parent Tables for the Configuration Item '" + gr.cmdb_ci.name + "' belonging to the CMDB Class '"+ gr.cmdb_ci.sys_class_name+ "' are: \n" + ciParent);
}

Parent Tables for the Configuration Item 'ApplicationServerPeopleSoft' belonging to the CMDB Class 'cmdb_ci_server' are: 
[cmdb_ci_server, cmdb_ci_computer, cmdb_ci_hardware, cmdb_ci, cmdb]

//Returns true if the cmdb_ci_endpoint class is defined 
//in the Business Rule Exclusion Lists table
var exclusion = SNC.CMDBUtil.isExcludedFromBR("cmdb_ci_endpoint");

//Advanced condition that prevents business rules from executing on 
//classes in the Business Rule Exclusion Lists table
(!SNC.CMDBUtil.isExcludedFromBR(current.getTableName()))

var cu = new SNC.CMDBUtil();
var parentSysID = '27d18f6fc0a8000b00ad14d4929d1b45';
var parentDesc = 'Depends on';
var childDesc = 'Used by'
 
// Get records with parent equal parentSysID
var relation = new GlideRecord('cmdb_rel_ci');
relation.addQuery('parent', parentSysID);
relation.query();
while(relation.next()){
    // Remove every relation of type: 'Depends on::Used by' for the parent
    // If the relation type does not exist, it inserts this relation type into [cmdb_rel_type].
    cu.removeCIRelationship('cmdb_rel_ci', parentSysID, relation.child.getValue('sys_id'), parentDesc, childDesc)
}

/*
  Before running the code in the background Script Make Sure 'Record For Rollback' is unchecked.

  This API CMDBUtil.reParentTable changes the parent of the table but will not allow the OOB tables to change the parent it works only in the custom table. Hence this script contains the creation of the custom table.
  API CMDBUtil.reParentTable has 3 parameters (Table, Old Parent , New Parent);
  We can make the Parent as Null as well by using this (Table, Old Parent, '');

  The code in this example shows how to create a custom table without any extension.
  Then creating a record and then again creating a record and checking in the task table after it gets extended to the task table.

  If the code returns false means the record is not present in the task table as it is not extended. It returns true only when the record is found in the task table after the table is extended.

*/

/* Run the following code to create the custom table without an extension
createCustomTable('u_custom_table','Custom Table'); // Creating a custom Table (don't create if you have one)
var CreatedRecord = CreateCustomRecord('u_custom_table'); // Creating a record in the custom table
gs.print(CheckRecord('u_custom_table'));  // Checking of the record in the task table by passing the Class Name (A.K.A your custom Table)

var getParentTables = new SNC.CMDBUtil.reParentTable('u_custom_table','','task'); // Extending the custom table to task table . This Works only when the table is extendable
var CreatedRecordAfter = CreateCustomRecord('u_custom_table'); // Creating a record in the custom table
gs.print(CheckRecord('u_custom_table'));  // Checking of the record in the task table by passing the Class Name (A.K.A your custom Table)
*/

// If the custom Table is already created, run this. (Do not run these 4 lines when creating the table)
gs.print(CheckRecord('u_custom_table')); //Checking of the record in the task table by passing the Class Name (A.K.A your custom Table)
var getParentTables = new SNC.CMDBUtil.reParentTable('u_custom_table','','task'); //Extending the custom table to task table . This Works only when the table is extendable
var CreatedRecordAfter = CreateCustomRecord('u_custom_table'); //Creating a record in the custom table
gs.print(CheckRecord('u_custom_table'));  //Checking of the record in the task table by passing the Class Name (A.K.A your custom Table)


function createCustomTable(Name, Label)
{
  var customTable = new GlideRecord('sys_db_object');
  customTable.initialize();
  customTable.name=  Name ;
  customTable.label= Label ;
  customTable.is_extendable= true;
  customTable.insert();
}

function CreateCustomRecord(customTableName)
{
  var customTable = new GlideRecord(customTableName);
  customTable.initialize();
  return customTable.insert();
}

function CheckRecord(customTableName)
{
  var task =new GlideRecord('task');
  task.addQuery('sys_class_name', customTableName);
  task.query();

  if(task.next())
  {
    return true;
  }

  return false;
}

*** Script: true
*** Script: true