Validate vCenter (vmware) Data in ServiceNow CMDB

VaranAwesomenow · ‎05-21-2021

Tables

Relationships

Script to verify if data present in your environment has data in all the classes mentioned above.

/*List of Classes
"cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datacenter",
"cmdb_ci_vmware_template",
"cmdb_ci_vcenter_network",
"cmdb_ci_vcenter_datastore",
"cmdb_ci_vcenter_cluster",
"cmdb_ci_vcenter",
"cmdb_ci_drs_vm_config",
"cmdb_ci_vcenter_vm_group",
"cmdb_ci_vcenter_host_group",
"cmdb_ci_vcenter_cluster_drs_rule",
"cmdb_ci_vcenter_dv_port_group",
"cmdb_ci_vcenter_object",
"cmdb_ci_vcenter_dvs",
"cmdb_ci_vcenter_folder",
"cmdb_ci_esx_resource_pool",
"cmdb_ci_cluster_vm_host_rule",
"cmdb_ci_cluster_vm_affinity_rule",
"cmdb_ci_storage_volume",
"cmdb_ci_network_adapter",
"cmdb_ci_esx_resource_pool",
"cmdb_ci_esx_server",
"cmdb_ci_virtualization_server",
"cmdb_serial_number",// not included as its not a child class of cmdb_ci
"cmdb_ci_disk"
*/
var classNameHash = {};
var className = '';
//var query = 'sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_storage_volume,cmdb_ci_network_adapter';

var query = 'sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_storage_volume,cmdb_ci_network_adapter,cmdb_ci_esx_resource_pool,cmdb_ci_esx_server,cmdb_ci_virtualization_server,cmdb_ci_disk';

var grCI = new GlideRecord('cmdb_ci');
grCI.addEncodedQuery(query);
grCI.query();
while(grCI.next()) {
className = grCI.sys_class_name + '';
classNameHash[className] = 1;
}

// show the values stored
var classArray = [];
var outputString = 'Data is available for below classes ' ;
for (var k in classNameHash) {

// use hasOwnProperty to filter out keys from the Object.prototype
if (classNameHash.hasOwnProperty(k)) {
outputString += k;
classArray.push(k + "");
}
}

//Compare with expected list of classes
var expectedClassList = ["cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datacenter",
"cmdb_ci_vmware_template",
"cmdb_ci_vcenter_network",
"cmdb_ci_vcenter_datastore",
"cmdb_ci_vcenter_cluster",
"cmdb_ci_vcenter",
"cmdb_ci_drs_vm_config",
"cmdb_ci_vcenter_vm_group",
"cmdb_ci_vcenter_host_group",
"cmdb_ci_vcenter_cluster_drs_rule",
"cmdb_ci_vcenter_dv_port_group",
"cmdb_ci_vcenter_object",
"cmdb_ci_vcenter_dvs",
"cmdb_ci_vcenter_folder",
"cmdb_ci_esx_resource_pool",
"cmdb_ci_cluster_vm_host_rule",
"cmdb_ci_cluster_vm_affinity_rule",
"cmdb_ci_storage_volume",
"cmdb_ci_network_adapter",
"cmdb_ci_esx_resource_pool",
"cmdb_ci_esx_server",
"cmdb_ci_virtualization_server",
"cmdb_ci_disk"];

var arrayUtil = new ArrayUtil();
//var a1 = new Array("a", "b", "c");
//var a2 = new Array("c", "d", "e");
var a1 = expectedClassList;
var a2 = classArray;
gs.print("Data is expected to be available for " + a1.length + " classes" + " but data is available only for " + a2.length + " classes");
gs.print(outputString);
gs.print("Data is missing for below classes " + arrayUtil.diff(a1, a2));

Sample output

*** Script: Data is expected to be available for 24 classes but data is available only for 7 classes
*** Script: Data is available for below classes cmdb_ci_storage_volume,cmdb_ci_disk,cmdb_ci_vmware_instance,cmdb_ci_network_adapter,cmdb_ci_esx_server,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter
*** Script: Data is missing for below classes cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_esx_resource_pool,cmdb_ci_virtualization_server

Compare existing relationships with expected relationships

/*List of relationships
"cmdb_ci_computer|Virtualized by::Virtualizes|cmdb_ci_esx_server",
"cmdb_ci_computer|Instantiates::Instantiated by|cmdb_ci_vmware_instance",
"cmdb_ci_vmware_instance|Registered on::Has registered|cmdb_ci_esx_server",
"cmdb_ci_vmware_instance|Connected by::Connects|cmdb_ci_vcenter_network",
"cmdb_ci_vmware_template|Connected by::Connects|cmdb_ci_vcenter_network",
"cmdb_ci_vcenter_network|Provided by::Provides|cmdb_ci_esx_server",
"cmdb_ci_vcenter_datastore|Provides storage for::Stored on|cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datastore|Used by::Uses|cmdb_ci_esx_server",
"cmdb_ci_vcenter_datastore|Provides storage for::Stored on|cmdb_ci_vmware_template",
"cmdb_ci_vcenter_cluster|Members::Member of|cmdb_ci_esx_server",
"cmdb_ci_esx_resource_pool|Defines resources for::Get resources from|cmdb_ci_vcenter_cluster",
"cmdb_ci_esx_resource_pool|Defines resources for::Get resources from|cmdb_ci_esx_server",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vcenter_datastore",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vcenter_folder",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vmware_template",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_network",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_esx_server",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_datastore",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_folder",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_cluster",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vmware_template",
*/
var classNameHash = {};
var className = '';
//var query = 'sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_storage_volume,cmdb_ci_network_adapter';

//disk, storage volume and network adapter are excluded from search in order to allow the query execution to complete in timely manner

var query = 'parent.sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_esx_resource_pool,cmdb_ci_esx_server,cmdb_ci_virtualization_server^ORchild.sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_,cmdb_ci_esx_resource_pool,cmdb_ci_esx_server,cmdb_ci_virtualization_server';

var grCI = new GlideRecord('cmdb_rel_ci');
grCI.addEncodedQuery(query);
grCI.query();
while(grCI.next()) {
className = grCI.parent.sys_class_name + '|' + grCI.type.name + "|" + grCI.child.sys_class_name;
classNameHash[className] = 1;
}

// show the values stored
var classArray = [];
var outputString = 'Data is available for below classes ' ;
for (var k in classNameHash) {

// use hasOwnProperty to filter out keys from the Object.prototype
if (classNameHash.hasOwnProperty(k)) {
outputString += k + ",";
classArray.push(k + "");
}
}

var arrayUtil = new ArrayUtil();
//var a1 = new Array("a", "b", "c");
//var a2 = new Array("c", "d", "e");
var a1 = expectedClassRelList;
var a2 = classArray;
gs.print("Data is expected to be available for " + a1.length + " classes" + " but data is available only for " + a2.length + " classes");
gs.print(outputString);
gs.print("Data is missing for below classes " + arrayUtil.diff(a1, a2));

Script to verify relationship data

/*List of relationships
"cmdb_ci_computer|Virtualized by::Virtualizes|cmdb_ci_esx_server",
"cmdb_ci_computer|Instantiates::Instantiated by|cmdb_ci_vmware_instance",
"cmdb_ci_vmware_instance|Registered on::Has registered|cmdb_ci_esx_server",
"cmdb_ci_vmware_instance|Connected by::Connects|cmdb_ci_vcenter_network",
"cmdb_ci_vmware_template|Connected by::Connects|cmdb_ci_vcenter_network",
"cmdb_ci_vcenter_network|Provided by::Provides|cmdb_ci_esx_server",
"cmdb_ci_vcenter_datastore|Provides storage for::Stored on|cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datastore|Used by::Uses|cmdb_ci_esx_server",
"cmdb_ci_vcenter_datastore|Provides storage for::Stored on|cmdb_ci_vmware_template",
"cmdb_ci_vcenter_cluster|Members::Member of|cmdb_ci_esx_server",
"cmdb_ci_esx_resource_pool|Defines resources for::Get resources from|cmdb_ci_vcenter_cluster",
"cmdb_ci_esx_resource_pool|Defines resources for::Get resources from|cmdb_ci_esx_server",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vcenter_datastore",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vcenter_folder",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vmware_template",
"cmdb_ci_vcenter_folder|Contains::Contained by|cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_network",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vmware_instance",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_esx_server",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_datastore",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_folder",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vcenter_cluster",
"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vmware_template",
*/
var classNameHash = {};
var className = '';
//var query = 'sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_storage_volume,cmdb_ci_network_adapter';

var query = 'parent.sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_esx_resource_pool,cmdb_ci_esx_server,cmdb_ci_virtualization_server^ORchild.sys_class_nameINcmdb_ci_vmware_instance,cmdb_ci_vcenter_datacenter,cmdb_ci_vmware_template,cmdb_ci_vcenter_network,cmdb_ci_vcenter_datastore,cmdb_ci_vcenter_cluster,cmdb_ci_vcenter,cmdb_ci_drs_vm_config,cmdb_ci_vcenter_vm_group,cmdb_ci_vcenter_host_group,cmdb_ci_vcenter_cluster_drs_rule,cmdb_ci_vcenter_dv_port_group,cmdb_ci_vcenter_object,cmdb_ci_vcenter_dvs,cmdb_ci_vcenter_folder,cmdb_ci_esx_resource_pool,cmdb_ci_cluster_vm_host_rule,cmdb_ci_cluster_vm_affinity_rule,cmdb_ci_,cmdb_ci_esx_resource_pool,cmdb_ci_esx_server,cmdb_ci_virtualization_server';

var grCI = new GlideRecord('cmdb_rel_ci');
grCI.addEncodedQuery(query);
grCI.query();
while(grCI.next()) {
className = grCI.parent.sys_class_name + '|' + grCI.type.name + "|" + grCI.child.sys_class_name;
classNameHash[className] = 1;
}

// show the values stored
var classArray = [];
var outputString = 'Data is available for below CI relationships ' ;
for (var k in classNameHash) {

// use hasOwnProperty to filter out keys from the Object.prototype
if (classNameHash.hasOwnProperty(k)) {
outputString += k + ",";
classArray.push(k + "");
}
}

var arrayUtil = new ArrayUtil();
//var a1 = new Array("a", "b", "c");
//var a2 = new Array("c", "d", "e");
var a1 = expectedClassRelList;
var a2 = classArray;
gs.print("Data is expected to be available for " + a1.length + " CI relationships" + " but data is available only for " + a2.length + " CI relationships");
gs.print(outputString);
gs.print("Data is missing for below CI relationships " + arrayUtil.diff(a1, a2));

Output

Reference : Data collected for VMware vCenter Server | ServiceNow Docs

krishnakk1 · ‎07-12-2021

Hi Anil,

I have the following requirement.

establish relationship between vcenter datastore ci and storage pool ci in cmdb

Do you have any idea?

Thanks!!

Krishna