Validate vCenter (vmware) Data in ServiceNow CMDB

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 storedvar classArray = [];var outputString = 'Data is available for below classes ' ;for (var k in classNameHash) { // use hasOwnProperty to filter out keys from the Object.prototypeif (classNameHash.hasOwnProperty(k)) {outputString += k; classArray.push(k + "");}

}

//Compare with expected list of classesvar 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 = '';

//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_serverORchild.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;

}

"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vmware_template"];

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

}

// show the values storedvar classArray = [];var outputString = 'Data is available for below CI relationships ' ;for (var k in classNameHash) { // use hasOwnProperty to filter out keys from the Object.prototypeif (classNameHash.hasOwnProperty(k)) {outputString += k + ","; classArray.push(k + "");}

}

"cmdb_ci_vcenter_datacenter|Contains::Contained by|cmdb_ci_vmware_template"];

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

Labels: