ServiceInstance content.about.instanceUuid content.about.osType content.about.build content.about.version HostSystem hardware.systemInfo.uuid hardware.cpuPkg hardware.cpuInfo.numCpuPackages hardware.cpuInfo.numCpuCores hardware.cpuInfo.hz hardware.systemInfo.model hardware.systemInfo.vendor hardware.cpuFeature config.hyperThread.available config.hyperThread.active config.product.name config.product.fullName config.product.version config.option config.storageDevice.scsiLun.length configIssue hardware.memorySize hardware.biosInfo.biosVersion runtime.inMaintenanceMode runtime.inQuarantineMode runtime.connectionState summary.quickStats.uptime summary.config.product.build isStandalone parent summary.runtime.networkRuntimeInfo.networkResourceRuntime.pnicResourceInfo summary.runtime.inMaintenanceMode summary.hardware.numCpuThreads config.network.ipV6Enabled summary.config.vmotionEnabled summary.config.faultToleranceEnabled summary.runtime.bootTime summary.runtime.powerState summary.runtime.standbyMode summary.runtime.cryptoState config.wakeOnLanCapable summary.hardware.numNics config.ipmi.login config.ipmi.bmcMacAddress config.ipmi.bmcIpAddress summary.runtime.connectionState summary.quickStats.overallMemoryUsage summary.hardware.numCpuCores summary.runtime.dasHostState.state summary.hardware.cpuMhz summary.quickStats.overallCpuUsage summary.config.product.fullName runtime.dasHostState.state summary.runtime.healthSystemRuntime.systemHealthInfo.numericSensorInfo.length summary.config.product.osType summary.config.product.fullname config.graphicsInfo.length datastore.length permission.length triggeredAlarmState.length vm.length config.lockdownMode hardware.systemInfo.serialNumber HostTelemetryManager telemetryData whiteList blackList whiteList EQUAL activeDumpPartitionSizeInMiB bootbankUsageInMiB activeDumpFileSizeInMiB netdumpEnabled freeSpaceOnInstallDiskInMiB loadEsxSupported tpmTxtEnabled coredumpPartitionEnabled coredumpFileEnabled systemMemReservation systemCpuReservation powerPolicy tpmFamily totalRDMADevices scratchPartitionUsageInMiB pmemCapacityInMB userCpuReservation pmemReservationInMB numNumaNodes bootDevicePartTableFormat firmwareType bootDeviceMedium tpmVendor bootDeviceFormatType userMemReservation vibs Extension key description.summary lastHeartbeatTime version type eventList VmwareDistributedVirtualSwitch uuid summary.host ClusterComputeResource datastore.length network.length rps.length configuration.dasConfig.enabled configuration.drsConfig.enabled summary.currentEVCModeKey summary.numVmotions migrationHistory.length summary.usageSummary.totalCpuCapacityMhz summary.usageSummary.totalMemCapacityMB storageTotalB summary.numEffectiveHosts configurationEx.dpmConfigInfo.enabled summary.usageSummary.cpuReservationMhz configurationEx.dpmConfigInfo.defaultDpmBehavior summary.overallStatus summary.numHosts configuration.dasConfig.failoverLevel configuration.dasConfig.option summary.usageSummary.poweredOffVmCount summary.usageSummary.cpuEntitledMhz configuration.drsConfig.enableVmBehaviorOverrides summary.currentBalance summary.usageSummary.cpuDemandMhz summary.usageSummary.memReservationMB configuration.drsConfig.defaultVmBehavior summary.usageSummary.poweredOffMemReservationMB configuration.drsConfig.vmotionRate configuration.dasConfig.admissionControlEnabled summary.usageSummary.memEntitledMB configurationEx.dpmConfigInfo.hostPowerActionRate summary.numCpuCores configuration.dasConfig.admissionControlPolicy.failoverLevel configuration.dasConfig.admissionControlPolicy.resourceReductionToToleratePercent configuration.dasConfig.admissionControlPolicy.slotPolicy.cpu configuration.dasConfig.admissionControlPolicy.slotPolicy.memory summary.usageSummary.memDemandMB summary.targetBalance configurationEx.dasConfig.admissionControlPolicy.failoverLevel configurationEx.dasConfig.defaultVmSettings.vmComponentProtectionSettings.vmStorageProtectionForAPD configurationEx.dasConfig.enabled summary.currentFailoverLevel configurationEx.dasConfig.admissionControlEnabled configurationEx.dasConfig.defaultVmSettings.vmComponentProtectionSettings.vmReactionOnAPDCleared configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.maxFailures configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.vmMonitoring configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.maxFailureWindow configurationEx.dasConfig.vmMonitoring configurationEx.dasConfig.defaultVmSettings.vmComponentProtectionSettings.vmTerminateDelayForAPDSec configurationEx.dasConfig.metroHASettings.enabled configurationEx.dasConfig.hBDatastoreCandidatePolicy configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.failureInterval summary.totalCpu configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.clusterSettings configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.minUpTime summary.usageSummary.poweredOffCpuReservationMhz summary.usageSummary.statsGenNumber summary.usageSummary.totalVmCount configurationEx.dasConfig.defaultVmSettings.vmComponentProtectionSettings.vmStorageProtectionForPDL configurationEx.dasConfig.defaultVmSettings.vmToolsMonitoringSettings.enabled configurationEx.dasConfig.defaultVmSettings.vmComponentProtectionSettings.enableAPDTimeoutForHosts summary.dasData.compatListVersion configurationEx.dasConfig.failoverLevel configurationEx.dasConfig.vmComponentProtecting configurationEx.dasConfig.admissionControlPolicy.cpuFailoverResourcesPercent configurationEx.dasConfig.hostMonitoring summary.dasData.hostListVersion configurationEx.dasConfig.heartbeatDatastore.length name summary.totalMemory configurationEx.dasConfig.defaultVmSettings.restartPriority summary.effectiveMemory configurationEx.dasConfig.admissionControlPolicy.memoryFailoverResourcesPercent configurationEx.dasConfig.admissionControlPolicy.failoverHosts.length configurationEx.dasConfig.admissionControlPolicy configurationEx.dasConfig.defaultVmSettings.isolationResponse summary.dasData.clusterConfigVersion summary.effectiveCpu permission.length configurationEx.drsConfig.option configurationEx.proactiveDrsConfig.enabled configurationEx.infraUpdateHaConfig.enabled configurationEx.infraUpdateHaConfig.behavior configurationEx.infraUpdateHaConfig.moderateRemediation configurationEx.infraUpdateHaConfig.severeRemediation configurationEx.rule configurationEx.drsVmConfig HostSystem hardware.systemInfo.uuid config.network.pnic hardware.pciDevice config.storageDevice.hostBusAdapter Datastore summary summary.url summary.name summary.capacity summary.freeSpace summary.maintenanceMode iormConfiguration.congestionThreshold summary.uncommitted iormConfiguration.statsAggregationDisabled summary.type iormConfiguration.reservationEnabled summary.accessible summary.datastore host iormConfiguration.enabled summary.multipleHostAccess iormConfiguration.percentOfPeakThroughput iormConfiguration.statsCollectionEnabled iormConfiguration.congestionThresholdMode info.maxVirtualDiskCapacity capability.seSparseSupported capability.nativeSnapshotSupported info.vvolDS.type info.vvolDS.capacity info.vvolDS.scId info.vvolDS.storageArray info.vvolDS.vasaProviderInfo info.vvolDS.hostPE vm.length info.vmfs.unmapGranularity info.vmfs.extent.length AlarmActionTriggeredEvent key createdTime entity.entity source.entity alarm.name GeneralHostWarningEvent key message createdTime host.host Extension key eventList HostSystem hardware.systemInfo.uuid config.storageDevice.scsiLun VmwareDistributedVirtualSwitch uuid summary.productinfo.version config.networkResourceManagementEnabled config.infrastructureTrafficResourceConfig config.lacpApiVersion config.lacpGroupConfig config.maxMtu VirtualMachine config.instanceUuid config.hardware.memoryMB config.hardware.numCPU guest.toolsVersionStatus2 summary.quickStats.swappedMemory config.template config.version config.hardware.numCoresPerSocket virtualDisks.length config.guestFullName config.alternateGuestName guest.toolsRunningStatus isNormalVMOrPrimaryFTVM isSecondaryVM runtime.host runtime.powerState summary.quickStats.uptimeSeconds summary.quickStats.privateMemory summary.quickStats.sharedMemory summary.quickStats.balloonedMemory summary.quickStats.compressedMemory summary.quickStats.guestMemoryUsage summary.quickStats.consumedOverheadMemory summary.quickStats.hostMemoryUsage summary.quickStats.overallCpuDemand summary.quickStats.overallCpuUsage config.vFlashCacheReservation config.cpuAllocation.limit config.cpuAllocation.shares.level config.memoryAllocation.reservation config.memoryAllocation.limit config.memoryAllocation.shares.shares summary.config.memoryReservation summary.config.cpuReservation config.cpuAllocation.shares.shares config.cpuAllocation.reservation summary.config.numEthernetCards config.latencySensitivity.sensitivity config.tools.afterPowerOn config.flags.faultToleranceType config.nestedHVEnabled config.tools.afterResume config.tools.toolsVersion config.tools.toolsInstallType config.tools.beforeGuestReboot capability.nestedHVSupported config.tools.beforeGuestStandby capability.vPMCSupported config.hardware.device config.hardware.virtualICH7MPresent config.hardware.virtualSMCPresent config.tools.beforeGuestShutdown config.memoryAllocation.overheadLimit config.tools.syncTimeWithHost config.defaultPowerOps.standbyAction capability.toolsAutoUpdateSupported config.defaultPowerOps.defaultPowerOffType guest.screen.height config.defaultPowerOps.defaultSuspendType config.defaultPowerOps.powerOffType config.defaultPowerOps.resetType config.tools.toolsUpgradePolicy capability.guestAutoLockSupported config.defaultPowerOps.suspendType guest.screen.width config.guestId config.defaultPowerOps.defaultResetType capability.toolsSyncTimeSupported capability.quiescedSnapshotsSupported config.datastoreUrl summary.config.name datastore.length summary.runtime.memoryOverhead config.latencySensitivity.level config.memoryAllocation.shares.level config.files.snapshotDirectory config.files.vmPathName config.files.logDirectory config.memoryAllocation.expandableReservation summary.runtime.connectionState summary.runtime.maxMemoryUsage config.files.ftMetadataDirectory config.files.suspendDirectory summary.runtime.maxCpuUsage summary.runtime.faultToleranceState name summary.config.instanceUuid summary.vm summary.config.guestFullName runtime.connectionState runtime.dasVmProtection.dasProtected summary.runtime.onlineStandby runtime.maxMemoryUsage runtime.onlineStandby summary.runtime.dasVmProtection.dasProtected guest.appState config.swapPlacement resourcePool runtime.maxCpuUsage summary.config.numCpu summary.runtime.powerState guest.guestState guestHeartbeatStatus summary.config.memorySizeMB guest.appHeartbeatStatus config.managedBy.extensionKey permission.length rootSnapshot snapshot.currentSnapshot summary.storage.committed summary.storage.uncommitted config.ftInfo.role runtime.faultToleranceState config.keyId config.migrateEncryption config.extraConfig config.flags.vbsEnabled runtime.instantCloneFrozen StoragePod podStorageDrsEntry.storageDrsConfig.podConfig.loadBalanceInterval podStorageDrsEntry.storageDrsConfig.podConfig.ioLoadBalanceConfig.ioLoadImbalanceThreshold podStorageDrsEntry.storageDrsConfig.podConfig.ioLoadBalanceConfig.reservablePercentThreshold podStorageDrsEntry.storageDrsConfig.podConfig.ioLoadBalanceEnabled podStorageDrsEntry.storageDrsConfig.podConfig.ioLoadBalanceConfig.ioLatencyThreshold podStorageDrsEntry.storageDrsConfig.podConfig.spaceLoadBalanceConfig.spaceUtilizationThreshold podStorageDrsEntry.storageDrsConfig.podConfig.spaceLoadBalanceConfig.freeSpaceThresholdGB podStorageDrsEntry.storageDrsConfig.podConfig.ioLoadBalanceConfig.reservableThresholdMode podStorageDrsEntry.storageDrsConfig.podConfig.spaceLoadBalanceConfig.minSpaceUtilizationDifference podStorageDrsEntry.storageDrsConfig.podConfig.enabled podStorageDrsEntry.storageDrsConfig.podConfig.spaceLoadBalanceConfig.spaceThresholdMode podStorageDrsEntry.storageDrsConfig.podConfig.automationOverrides.ioLoadBalanceAutomationMode podStorageDrsEntry.storageDrsConfig.podConfig.automationOverrides.policyEnforcementAutomationMode podStorageDrsEntry.storageDrsConfig.podConfig.automationOverrides.ruleEnforcementAutomationMode podStorageDrsEntry.storageDrsConfig.podConfig.automationOverrides.spaceLoadBalanceAutomationMode podStorageDrsEntry.storageDrsConfig.podConfig.automationOverrides.vmEvacuationAutomationMode podStorageDrsEntry.storageDrsConfig.podConfig.defaultVmBehavior podStorageDrsEntry.storageDrsConfig.podConfig.defaultIntraVmAffinity podStorageDrsEntry.storageDrsConfig.podConfig.rule podStorageDrsEntry.storageDrsConfig.vmConfig childEntity VirtualApp config.memoryAllocation.shares.shares config.cpuAllocation.expandableReservation config.memoryAllocation.shares.level config.cpuAllocation.limit config.cpuAllocation.shares.level config.memoryAllocation.reservation config.memoryAllocation.limit config.cpuAllocation.shares.shares config.cpuAllocation.reservation config.memoryAllocation.expandableReservation vAppConfig.entityConfig ResourcePool config.memoryAllocation.shares.shares parent permission.length config.cpuAllocation.expandableReservation config.memoryAllocation.shares.level config.cpuAllocation.limit config.cpuAllocation.shares.level config.memoryAllocation.reservation config.memoryAllocation.limit vm.length config.cpuAllocation.shares.shares config.cpuAllocation.reservation config.memoryAllocation.expandableReservation HostSystem hardware.systemInfo.uuid configManager.storageSystem VirtualMachineSnapshot config.instanceUuid config.vFlashCacheReservation config.files.snapshotDirectory config.changeTrackingEnabled config.files.vmPathName config.files.logDirectory config.flags.snapshotDisabled config.flags.snapshotLocked config.files.suspendDirectory config.hardware.device.length config.flags.diskUuidEnabled Datacenter HostSystem hardware.systemInfo.uuid config.network.vswitch config.network.portgroup config.virtualNicManagerInfo config.network.proxySwitch HostSystem hardware.systemInfo.uuid datastore VirtualMachine config.hardware.device config.instanceUuid config.template HostStorageSystem fileSystemVolumeInfo.mountInfo fileSystemVolumeInfo.volumeTypeList VirtualMachine config.instanceUuid config.template virtualDisks HostSystem hardware.systemInfo.uuid config.graphicsInfo DistributedVirtualPortgroup name config.defaultPortConfig.inShapingPolicy config.defaultPortConfig.outShapingPolicy config.defaultPortConfig.vlan VmwareDistributedVirtualSwitch uuid portgroup DistributedVirtualPortgroup vm Network name vm.length permission.length VirtualMachine config.instanceUuid config.datastoreUrl config.template HostProfile name complianceStatus entity Folder permission.length LicenseUtilization license.info license.info.restrictions usage Asset info.instanceId info.properties info.costUnitUsage info.product.family.name info.product.family.version info.version info.featuresInUse info.license.info.restrictions VasaProviderInfo uid providerId namespace version retainVasaProviderCertificate arrayIndependentProvider type relatedStorageArray CustomFaultDomainInfo id providerUid storageArrayId children StorageContainer uuid providerId maxVvolSizeInMB CapabilityObjectSchema namespaceInfo.namespace lineOfService.lineOfService vendorInfo.vendorUuid namespaceInfo.version capabilityMetadataPerCategory CapabilityBasedProfile profileId.uniqueId constraints profileCategory DefaultProfileInfo defaultProfile.profileId.uniqueId datastores RollupComplianceResult result entity.key QueryReplicationGroupResult object.key object.objectType object.serverUuid replicationGroupId.deviceGroupId.id replicationGroupId.faultDomainId.id com.vmware.content.Library id name type version creationTime lastModifiedTime lastSyncTime serverGuid optimizationInfo.optimizeRemotePublishing publishInfo publishInfo.published publishInfo.publishUrl publishInfo.persistJsonEnabled subscriptionInfo subscriptionInfo.onDemand subscriptionInfo.subscriptionUrl storageBackings com.vmware.content.library.Item id libraryId sourceId contentVersion metadataVersion version name cached size type creationTime lastModifiedTime lastSyncTime OptionManager setting AuthorizationManager roleList privilegeList m_retrieveAllPermissions DeploymentInfo hostName pscNodes UserLogoutSessionEvent key createdTime userAgent loginTime userName callCount VmPoweredOnEvent key createdTime vm.vm host.host VmPoweredOffEvent key createdTime vm.vm host.host VmSuspendedEvent key createdTime vm.vm host.host VmDeployedEvent key createdTime vm.vm host.host EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.CreateLibraryEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.CreateLibraryFailEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.CreateLibraryItemEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.CreateLibraryItemFailEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.SyncLibraryEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.SyncLibraryFailEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.SyncLibraryItemEvent EventEx key objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.cl.SyncLibraryItemFailEvent EventEx key eventTypeId objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.ovfs.DeployEvent EventEx key eventTypeId objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.ovfs.DeployFailEvent EventEx key eventTypeId objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.ovfs.ExportEvent EventEx key eventTypeId objectId objectType objectName severity createdTime userName arguments eventTypeId EQUAL com.vmware.ovfs.ExportFailEvent VmCreatedEvent key createdTime vm.vm host.host VmRemovedEvent key createdTime vm.vm host.host VmBeingHotMigratedEvent key createdTime vm.vm host.host datacenter.datacenter destHost.host destDatacenter.datacenter VmBeingMigratedEvent key createdTime vm.vm host.host datacenter.datacenter destHost.host destDatacenter.datacenter VmMigratedEvent key createdTime vm.vm sourceHost.host sourceDatacenter.datacenter host.host datacenter.datacenter DrsVmMigratedEvent key createdTime vm.vm sourceHost.host sourceDatacenter.datacenter host.host datacenter.datacenter DrsVmPoweredOnEvent key createdTime vm.vm host.host DrsRuleViolationEvent key createdTime vm.vm host.host DrsRuleComplianceEvent key createdTime vm.vm host.host DrsSoftRuleViolationEvent key createdTime vm.vm host.host VmReconfiguredEvent key createdTime vm.vm host.host configSpec.vPMCEnabled VmBeingCreatedEvent key createdTime vm.vm host.host configSpec.vPMCEnabled TaskTimeoutEvent key host.host info.name EventEx key eventTypeId objectId objectType objectName createdTime userName eventTypeId EQUAL com.vmware.vc.VmBeginInstantCloneEvent EventEx key eventTypeId objectId objectType objectName createdTime userName eventTypeId EQUAL com.vmware.vc.VmInstantClonedEvent EventEx key eventTypeId objectId objectType objectName createdTime userName eventTypeId EQUAL com.vmware.vc.VmInstantCloneFailedEvent EventEx key eventTypeId createdTime vm.vm host.host datacenter.datacenter arguments userName eventTypeId EQUAL com.vmware.vc.crypto.Operation EnteringMaintenanceModeEvent key createdTime host.host chainId EnteredMaintenanceModeEvent key createdTime host.host chainId ExitMaintenanceModeEvent key createdTime host.host chainId EventEx key eventTypeId createdTime vm.vm host.host datacenter.datacenter ds.datastore dvs.dvs net.network userName severity EQUAL error VStorageObject config config.id.id config.capacityInMB config.backing.datastore CustomVStorageObjectSnapshotInfo fcdId snapshots ComplianceResult profile.uniqueId complianceStatus entity.key EventEx key eventTypeId objectId objectType objectName createdTime userName arguments eventTypeId EQUAL com.vmware.vc.infraUpdateHa.PostGreenHealthUpdateEvent EventEx key eventTypeId objectId objectType objectName createdTime userName arguments eventTypeId EQUAL com.vmware.vc.infraUpdateHa.PostYellowHealthUpdateEvent EventEx key eventTypeId objectId objectType objectName createdTime userName arguments eventTypeId EQUAL com.vmware.vc.infraUpdateHa.PostRedHealthUpdateEvent EventEx key eventTypeId objectId objectType objectName createdTime userName arguments eventTypeId EQUAL com.vmware.vc.infraUpdateHa.GreenHealthEvent EventEx key eventTypeId objectId objectType objectName createdTime userName arguments eventTypeId EQUAL com.vmware.vc.infraUpdateHa.YellowHealthEvent EventEx key eventTypeId objectId objectType objectName createdTime userName arguments eventTypeId EQUAL com.vmware.vc.infraUpdateHa.RedHealthEvent EventEx key objectId objectType host.host createdTime eventTypeId EQUAL com.vmware.vc.VmDiskFailedToConsolidateEvent EventEx key objectId objectType host.host createdTime eventTypeId EQUAL com.vmware.vc.VmDiskConsolidationNeeded Alarm info.systemName info.action HostSystem hardware.systemInfo.uuid config.storageDevice.multipathInfo.lun PerformanceManager historicalInterval vir:VCenter ServiceInstance vc_instance $content-about-instanceUuid.toUpperCase() OSTYPE content-about-osType BUILD content-about-build VERSION content-about-version collection__fk $global-collectionId ServiceInstance crd_product_instance $moref-serverGuid.toUpperCase() name vCenter Server$!GLOBAL-EMPTY version content-about-version vir:DataStore Datastore DATASTORE #set($len=$summary-url.toString().length() - 1)$moref-serverGuid.toUpperCase()|$summary-url.toString().substring(19, $len) NAME $GLOBAL-DigestUtils.sha256Hex($summary-name) TYPE summary-type SIZE summary-capacity USAGE #set($tmp=$summary-capacity - $summary-freeSpace)$tmp UUID#set($len=$summary-url.toString().length() - 1)$summary-url.toString().substring(19, $len) MO_ID$moref-value FREESPACE summary-freeSpace IORM_CFG_CONGESTION_THRESHOLD_MODE iormConfiguration-congestionThresholdMode IORM_CFG_PERCENT_OF_PEAK_THROUGHPUT iormConfiguration-percentOfPeakThroughput IORM_CFG_ENABLED iormConfiguration-enabled IORM_CFG_RESERVATION_ENABLED iormConfiguration-reservationEnabled IORM_CFG_CONGESTION_THRESHOLD iormConfiguration-congestionThreshold IORM_CFG_STATS_COLLECTION_ENABLED iormConfiguration-statsCollectionEnabled IORM_CFG_STATS_AGGREGATION_DISABLED iormConfiguration-statsAggregationDisabled ACCESSIBLE summary-accessible MULTIPLE_HOST_ACCESS summary-multipleHostAccess UNCOMMITTED summary-uncommitted MAINTENANCE_MODE summary-maintenanceMode NATIVE_SNAPSHOT_SUPPORTED capability-nativeSnapshotSupported CAPABILITY_SESPARSE_SUPPORTED capability-seSparseSupported MAX_VIRTUAL_DISK_CAPACITY info-maxVirtualDiskCapacity VM_COUNT vm-length VMFS_UNMAP_GRANULARITY $!info-vmfs-unmapGranularity VMFS_EXTENT_COUNT $!info-vmfs-extent-length VC__FK $moref-serverGuid.toUpperCase() Datastore vvol_sc $moref-serverGuid.toUpperCase()|$info-vvolDS-scId max_size_bytes info-vvolDS-capacity type info-vvolDS-type sc_uuid info-vvolDS-scId datastore_mo_id $moref-value datastore_uuid #set($len=$summary-url.toString().length() - 1)$summary-url.toString().substring(19, $len) VC__FK $moref-serverGuid.toUpperCase() datastore__FK #set($len=$summary-url.toString().length() - 1)$moref-serverGuid.toUpperCase()|$summary-url.toString().substring(19, $len) Datastore vvol_array__ARRAY $moref-serverGuid.toUpperCase()|$info-vvolDS-scId|vvol_array vvol_array__ARRAY [#foreach($item1 in $info-vvolDS-storageArray) { "id": "$moref-serverGuid.toUpperCase()|$item1.uuid", "uuid": "$item1.uuid", "vendor_id": "$item1.vendorId", "model_id": "$item1.modelId" }#if($foreach.hasNext),#end#end] VC__FK $moref-serverGuid.toUpperCase() Datastore vvol_sc_to_vvol_array__ARRAY $moref-serverGuid.toUpperCase()|$info-vvolDS-scId|vvol_sc_to_vvol_array vvol_sc_to_vvol_array__ARRAY [#foreach($item in $info-vvolDS-storageArray) { "id": "$moref-serverGuid.toUpperCase()|$info-vvolDS-scId|$item.uuid", "sc_uuid": "$info-vvolDS-scId", "array_uuid": "$item.uuid", "vvol_array__FK": "$moref-serverGuid.toUpperCase()|$item.uuid" }#if($foreach.hasNext),#end#end] VC__FK $moref-serverGuid.toUpperCase() vvol_sc__FK $moref-serverGuid.toUpperCase()|$info-vvolDS-scId Datastore vvol_vp__ARRAY $moref-serverGuid.toUpperCase()|$info-vvolDS-scId|vvol_vp vvol_vp__ARRAY [#foreach($item in $info-vvolDS-vasaProviderInfo) { "id": "$moref-serverGuid.toUpperCase()|$GLOBAL-DigestUtils.sha256Hex($item.provider.url)", "url": "$GLOBAL-DigestUtils.sha256Hex($item.provider.url)", "use_vmca": #if($item.provider.selfSignedCertificate)true#{else}false#end }#if($foreach.hasNext),#end#end] VC__FK $moref-serverGuid.toUpperCase() Datastore vvol_sc_to_vvol_vp__ARRAY $moref-serverGuid.toUpperCase()|$info-vvolDS-scId|vvol_sc_to_vvol_vp vvol_sc_to_vvol_vp__ARRAY [#foreach($item in $info-vvolDS-vasaProviderInfo) { "id": "$moref-serverGuid.toUpperCase()|$info-vvolDS-scId|$GLOBAL-DigestUtils.sha256Hex($item.provider.url)", "sc_uuid": "$info-vvolDS-scId", "vp_url": "$GLOBAL-DigestUtils.sha256Hex($item.provider.url)", "vvol_vp__FK": "$moref-serverGuid.toUpperCase()|$GLOBAL-DigestUtils.sha256Hex($item.provider.url)" }#if($foreach.hasNext),#end#end] VC__FK $moref-serverGuid.toUpperCase() vvol_sc__FK $moref-serverGuid.toUpperCase()|$info-vvolDS-scId Datastore vvol_vp_to_vvol_array__ARRAY $moref-serverGuid.toUpperCase()|$info-vvolDS-scId|vvol_vp_to_vvol_array vvol_vp_to_vvol_array__ARRAY [#foreach($item in $info-vvolDS-vasaProviderInfo) #foreach($item1 in $item.arrayState) { "id": "$moref-serverGuid.toUpperCase()|$GLOBAL-DigestUtils.sha256Hex($item.provider.url)|$item1.arrayId", "array_uuid": "$item1.arrayId", "is_active": "$item1.active", "priority": "$item1.priority", "url": "$GLOBAL-DigestUtils.sha256Hex($item.provider.url)", "vvol_array__FK": "$moref-serverGuid.toUpperCase()|$item1.arrayId", "vvol_vp__FK": "$moref-serverGuid.toUpperCase()|$GLOBAL-DigestUtils.sha256Hex($item.provider.url)" } #if($foreach.hasNext),#end #end##foreach on item1 #if($foreach.hasNext),#end#end] VC__FK $moref-serverGuid.toUpperCase() Datastore vvol_pe__ARRAY $moref-serverGuid.toUpperCase()|$info-vvolDS-scId|vvol_pe vvol_pe__ARRAY [#foreach($item in $info-vvolDS-hostPE) #foreach($item1 in $item.protocolEndpoint) { "id": "$moref-serverGuid.toUpperCase()|$info-vvolDS-scId|$item.key.value|$item1.uuid", "sc_uuid": "$info-vvolDS-scId", "esx_mo_id": "$item.key.value", "type": "$item1.type", "array_uuid": "$item1.storageArray", "uuid": "$item1.uuid", #if($item1.type =="scsi")"device_id": "$item1.deviceId"#end #if($item1.nfsServerAuthType)"nfsv4_auth_type": "$item1.nfsServerAuthType",#end #if($item1.type == "nfs")"nfs_version": "nfs3"#elseif($item1.type == "nfs4x")"NFS4.1"#end } #if($foreach.hasNext),#end #end##foreach on item1 #if($foreach.hasNext),#end#end] vvol_sc__FK $moref-serverGuid.toUpperCase()|$info-vvolDS-scId VC__FK $moref-serverGuid.toUpperCase() vir:ESX_TO_DATASTORE HostSystem ESX_TO_DATASTORE__ARRAY $moref-serverGuid.toUpperCase()|$hardware-systemInfo-uuid.toUpperCase().replace("-", "")|ESX_TO_DATASTORE ESX_TO_DATASTORE__ARRAY [#foreach($item in $datastore) { "ID": "$moref-serverGuid.toUpperCase()|$hardware-systemInfo-uuid.toUpperCase().replace("-", "")|$item.value", "DATASTORE_MO_ID": "$item.value" }#if($foreach.hasNext),#end#end] ESX__FK$hardware-systemInfo-uuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() vir:SCSI_LUN HostSystem SCSI_LUN__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|SCSI_LUN SCSI_LUN__ARRAY [#foreach($item in $config-storageDevice-scsiLun) { "ID": "$hardware-systemInfo-uuid.toUpperCase().replace("-", "")|$item.canonicalName", #if($item.vendor)"VENDOR": "$item.vendor.trim()",#end "NAME": "$item.canonicalName", "UUID": "$item.uuid" }#if($foreach.hasNext),#end#end] ESX__FK $hardware-systemInfo-uuid.toUpperCase().replace("-", "") host_multipath_info_path HostSystem HOST_MULTIPATH_INFO_PATH__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|host_multipath_info_path HOST_MULTIPATH_INFO_PATH__ARRAY [#foreach($lun in $config-storageDevice-multipathInfo-lun) #set($scsiLunUuid=$lun.id) #foreach($path in $lun.path) { "ID": "$hardware-systemInfo-uuid.toUpperCase().replace("-", "")|$path.key", "TRANSPORT": "$!path.transport.class.name.replace("com.vmware.vim.binding.vim.host.", "")", "SCSI_LUN_UUID": "$scsiLunUuid" } #if($foreach.hasNext),#end #end #if($foreach.hasNext),#end#end] vir:DISTRIBUTED_SWITCH VmwareDistributedVirtualSwitch DISTRIBUTED_SWITCH $uuid.toString().replace(" ", "") CFG_NETWORK_RESOURCE_MANAGEMENT_ENABLED config-networkResourceManagementEnabled VERSION summary-productInfo-version TYPEvSphere Distributed Switch$!GLOBAL-EMPTY LACP_API_VERSION config-lacpApiVersion MAX_MTU config-maxMtu VC__FK $moref-serverGuid.toUpperCase() VmwareDistributedVirtualSwitch DISTRIBUTED_SWITCH_INFRASTRUCTURE_TRAFFIC_CONFIG__ARRAY $uuid.toString().replace(" ", "")|DISTRIBUTED_SWITCH_INFRASTRUCTURE_TRAFFIC_CONFIG DISTRIBUTED_SWITCH_INFRASTRUCTURE_TRAFFIC_CONFIG__ARRAY #set($switch_uuid=$uuid.toString().replace(" ", "")) [#foreach($item in $config-infrastructureTrafficResourceConfig) { "ID": "$switch_uuid|$item.key", "TRAFFIC_TYPE": "$item.key", "RESERVATION_MBPS": "$item.allocationInfo.reservation", "LIMIT_MBPS": "$item.allocationInfo.limit", "SHARES": "$item.allocationInfo.shares.shares", "SHARES_LEVEL": "$item.allocationInfo.shares.level" }#if($foreach.hasNext),#end#end] DISTRIBUTED_SWITCH__FK$uuid.toString().replace(" ", "") VC__FK$moref-serverGuid.toUpperCase() VmwareDistributedVirtualSwitch DISTRIBUTED_SWITCH_LACP_GROUP_CONFIG__ARRAY $uuid.toString().replace(" ", "")|DISTRIBUTED_SWITCH_LACP_GROUP_CONFIG DISTRIBUTED_SWITCH_LACP_GROUP_CONFIG__ARRAY #set($switch_uuid=$uuid.toString().replace(" ", "")) [#foreach($item in $config-lacpGroupConfig) { "ID": "$switch_uuid|$!item.key", "IP_FIX_ENABLED": "$!item.ipfix.ipfixEnabled", "LOAD_BALANCE_ALGORITHM": "$!item.loadbalanceAlgorithm", "MODE": "$!item.mode", "NAME": "$GLOBAL-DigestUtils.sha256Hex($!item.name)", "UPLINK_NAME_LIST": "#foreach($name in $!item.uplinkName)$GLOBAL-DigestUtils.sha256Hex($name)#if($foreach.hasNext),#end#end", "UPLINK_NUMBER": "$!item.uplinkNum", "UPLINK_PORT_KEY_LIST": "#foreach($key in $!item.uplinkPortKey)$key#if($foreach.hasNext),#end#end", "VLAN_ID_RANGE_LIST": "#foreach($range in $!item.vlan.vlanId)$range.start#[[-]]#$range.end#if($foreach.hasNext),#end#end" }#if($foreach.hasNext),#end#end] DISTRIBUTED_SWITCH__FK$uuid.toString().replace(" ", "") VC__FK$moref-serverGuid.toUpperCase() vir:VirtualMachine VirtualMachine VM #if($config-template=="false")$config-instanceUuid.toUpperCase().replace("-", "")#else$!GLOBAL-EMPTY#end NUM_VCPUS config-hardware-numCPU MEMORY_MB config-hardware-memoryMB TOOLS_VERSION_STATUS2 guest-toolsVersionStatus2 STATS_SWAPPED_MEMORY_MB summary-quickStats-swappedMemory hardware_Version config-version num_Cores_Per_Socket config-hardware-numCoresPerSocket num_Virtual_Disks $virtualDisks-length guest_Full_Name config-guestFullName alternate_Guest_Name config-alternateGuestName tools_Running_Status guest-toolsRunningStatus ft_Role config-ftInfo-role ft_State runtime-faultToleranceState ft_Is_Normal_VM_Or_Primary_FTVM isNormalVMOrPrimaryFTVM ft_Is_Secondary_VM isSecondaryVM power_state runtime-powerState uptime_Seconds summary-quickStats-uptimeSeconds stats_private_Memory_Used_Mb summary-quickStats-privateMemory stats_shared_Memory_Mb summary-quickStats-sharedMemory ESX_MO_ID $runtime-host.value MO_ID $moref-value stats_ballooned_Memory_Mb summary-quickStats-balloonedMemory stats_compressed_Memory_Mb summary-quickStats-compressedMemory stats_consumed_Overhead_Memory_Mb summary-quickStats-consumedOverheadMemory stats_guest_Memory_Usage_Mb summary-quickStats-guestMemoryUsage stats_host_Memory_Usage_Mb summary-quickStats-hostMemoryUsage stats_overall_Cpu_Demand_Mhz summary-quickStats-overallCpuDemand stats_overall_Cpu_Usage_Mhz summary-quickStats-overallCpuUsage LATENCY_SENSITIVITY_LEVEL config-latencySensitivity-level VFLASH_CACHE_RESERVATION config-vFlashCacheReservation CPU_ALLOCATION_RESERVATION config-cpuAllocation-reservation CPU_ALLOCATION_LIMIT config-cpuAllocation-limit CPU_ALLOCATION_SHARES_SHARES config-cpuAllocation-shares-shares CPU_ALLOCATION_SHARES_LEVEL config-cpuAllocation-shares-level MEM_ALLOC_RESERVATION config-memoryAllocation-reservation MEM_ALLOC_LIMIT config-memoryAllocation-limit MEM_ALLOC_SHARES_SHARES config-memoryAllocation-shares-shares MEM_ALLOC_SHARES_LEVEL config-memoryAllocation-shares-level MEM_ALLOC_OVERHEAD_LIMIT config-memoryAllocation-overheadLimit MEM_RESERVATION summary-config-memoryReservation NUM_ETHERNET_CARDS summary-config-numEthernetCards CPU_RESERVATION summary-config-cpuReservation DEVICE_COUNT $config-hardware-device.size() VPMC_SUPPORTED capability-vPMCSupported NESTED_HVS_SUPPORTED capability-nestedHVSupported NESTED_HVS_ENABLED config-nestedHVEnabled VIRTUAL_ICH7MP_PRESENT config-hardware-virtualICH7MPresent VIRTUAL_SMC_PRESENT config-hardware-virtualSMCPresent LATENCY_SENSITIVITY_SENSITIVITY config-latencySensitivity-sensitivity FLAGS_FT_TYPE config-flags-faultToleranceType TOOLS_BEFORE_GUEST_STANDBY config-tools-beforeGuestStandby TOOLS_BEFORE_GUEST_REBOOT config-tools-beforeGuestReboot TOOLS_BEFORE_GUEST_SHUTDOWN config-tools-beforeGuestShutdown TOOLS_AFTER_RESUME config-tools-afterResume TOOLS_AFTER_POWERON config-tools-afterPowerOn TOOLS_VERSION config-tools-toolsVersion tools_install_type config-tools-toolsInstallType QUIESCED_SNAPSHOTS_SUPPORTED capability-quiescedSnapshotsSupported GUEST_AUTO_LOCKS_SUPPORTED capability-guestAutoLockSupported TOOLS_SYNC_TIMES_SUPPORTED capability-toolsSyncTimeSupported TOOLS_AUTO_UPDATE_SUPPORTED capability-toolsAutoUpdateSupported GUEST_ID config-guestId TOOLS_UPGRADE_POLICY config-tools-toolsUpgradePolicy TOOLS_SYNC_TIME_WITH_HOST config-tools-syncTimeWithHost DFT_POWER_OPS_DEFAULT_SUSPEND_TYPE config-defaultPowerOps-defaultSuspendType DFT_POWER_OPS_SUSPEND_TYPE config-defaultPowerOps-suspendType DFT_POWER_OPS_STANDBY_ACTION config-defaultPowerOps-standbyAction DFT_POWER_OPS_DEFAULT_POWER_OFF_TYPE config-defaultPowerOps-defaultPowerOffType DFT_POWER_OPS_RESET_TYPE config-defaultPowerOps-resetType DFT_POWER_OPS_POWER_OFF_TYPE config-defaultPowerOps-powerOffType GUEST_SCREEN_WIDTH guest-screen-width GUEST_SCREEN_HEIGHT guest-screen-height ANONYMIZED_VM_PATH_NAME $GLOBAL-DigestUtils.sha256Hex($config-files-vmPathName) ANONYMIZED_FILES_SNAPSHOT_DIRECTORY $GLOBAL-DigestUtils.sha256Hex($config-files-snapshotDirectory) ANONYMIZED_FILES_SUSPEND_DIRECTORY $GLOBAL-DigestUtils.sha256Hex($config-files-suspendDirectory) ANONYMIZED_FILE_LOG_DIRECTORY $GLOBAL-DigestUtils.sha256Hex($config-files-logDirectory) CHANGE_TRACKING_ENABLED config-changeTrackingEnabled FLAGS_SNAPSHOT_LOCKED config-flags-snapshotLocked FLAGS_DISK_UUID_ENABLED config-flags-diskUuidEnabled FLAGS_SNAPSHOT_DISABLED config-flags-snapshotDisabled DATASTORE_COUNT $datastore-length RT_CONSOLIDATION_NEEDED runtime-consolidationNeeded SNAPSHOT_CURRENT_SNAPSHOT $!snapshot-currentSnapshot.value SNAPSHOT_ROOT_SNAPSHOT_LIST_QUIESCED snapshot-rootSnapshotList-quiesced SNAPSHOT_ROOT_SNAPSHOT_LIST_DESCRIPTION snapshot-rootSnapshotList-description SNAPSHOT_ROOT_SNAPSHOT_LIST_REPLAY_SUPPORTED snapshot-rootSnapshotList-replaySupported SNAPSHOT_ROOT_SNAPSHOT_LIST_VM snapshot-rootSnapshotList-vm SNAPSHOT_ROOT_SNAPSHOT_LIST_CREATE_TIME snapshot-rootSnapshotList-createTime SNAPSHOT_ROOT_SNAPSHOT_LIST_STATE snapshot-rootSnapshotList-state SNAPSHOT_ROOT_SNAPSHOT_LIST_SNAPSHOT snapshot-rootSnapshotList-snapshot SNAPSHOT_ROOT_SNAPSHOT_LIST_ID snapshot-rootSnapshotList-id SNAPSHOT_ROOT_SNAPSHOT_LIST_NAME snapshot-rootSnapshotList-name FILES_FT_METADATA_DIRECTORY config-files-ftMetadataDiretory DATASTORE_URL $config-datastoreUrl.get(0).url ANONYMIZED_DATASTORE_NAME $GLOBAL-DigestUtils.sha256Hex($config-datastoreUrl.get(0).name) ANONYMIZED_NAME $GLOBAL-DigestUtils.sha256Hex($name) RT_MAX_MEMORY_USAGE summary-runtime-maxMemoryUsage RT_MEMORY_OVERHEAD summary-runtime-memoryOverhead RT_MAX_CPU_USAGE summary-runtime-maxCpuUsage INSTANCE_UUID summary-config-instanceUuid GUEST_HEART_BEAT_STATUS guestHeartbeatStatus APP_HEARTBEAT_STATUS guest-appHeartbeatStatus APP_STATE guest-appState GUEST_STATE guest-guestState RESOURCE_POOL $moref-serverGuid.toUpperCase()|$resourcePool.value RT_CONNECTION_STATE summary-runtime-connectionState RT_DASVMPROTECTION_DASPROTECTED summary-runtime-dasVmProtection-dasProtected RT_ONLINE_STANDBY summary-runtime-onlineStandby SWAP_PLACEMENT config-swapPlacement extension_manager config-managedBy-extensionKey number_of_nics summary-config-numEthernetCards permission_count $permission-length type_of_vm_nics #foreach($dev in $config-hardware-device)#if($dev.key==4000)$dev.getClass().getName().substring(44)#end#end used_Space summary-storage-committed provisioned_Space #set($storage_provisioned = $summary-storage-committed + $summary-storage-uncommitted)$storage_provisioned is_crypto_key_configured #if($config-keyId)true#{else}false#end crypto_key_provider_anonymized $GLOBAL-DigestUtils.sha256Hex($config-keyId.providerId.id) migration_encryption config-migrateEncryption allow_guest_host_info #foreach($option in $!config-extraConfig)#if("tools.guestlib.enableHostInfo"==$option.key)#if($!option.value == "TRUE")TRUE#elseif($!option.value != "")FALSE#end#break#end#end## FLAGS_VBS_ENABLED config-flags-vbsEnabled VTPM_DEVICE_CONFIGURED #set($vtpmConfigured = "false")#foreach($device in $!config-hardware-device)#if($device.class.name.contains("VirtualTPM"))#set($vtpmConfigured = "true")#break#end#end$vtpmConfigured INSTANT_CLONE_FROZEN runtime-instantCloneFrozen VC__FK $moref-serverGuid.toUpperCase() VirtualMachine VIRTUAL_CONTROLLER__ARRAY #if($config-template=="false")$config-instanceUuid.toUpperCase().replace("-", "")|VIRTUAL_CONTROLLER#else$!GLOBAL-EMPTY#end VIRTUAL_CONTROLLER__ARRAY ## #set($virtualControllers=[]) #foreach($item in $config-hardware-device)#if($config-template=="false" and $item.class.name.contains("Controller")) #set($void=$virtualControllers.add($item)) #end#end## [#foreach($item in $virtualControllers) { "id": "$moref-serverGuid.toUpperCase()|$moref-value|$item.key", "vm_mo_id": "$moref-value", #set($controller_type_start_index=$item.class.name.lastIndexOf(".") + 1) #set($controller_type_end_index=$item.class.name.indexOf("Controller")) "controller_type" : "$item.class.name.substring($controller_type_start_index, $controller_type_end_index)" }#if($foreach.hasNext),#end#end] VM__FK $config-instanceUuid.toUpperCase().replace("-", "") VC__FK $moref-serverGuid.toUpperCase() VirtualMachine vc_template #if($config-template=="true")$config-instanceUuid.toUpperCase().replace("-", "")#else$!GLOBAL-EMPTY#end NUM_VCPUS config-hardware-numCPU TOOLS_VERSION_STATUS2 guest-toolsVersionStatus2 MEMORY_MB config-hardware-memoryMB hardware_Version config-version num_Cores_Per_Socket config-hardware-numCoresPerSocket num_Virtual_Disks $virtualDisks-length used_Space summary-storage-committed provisioned_Space #set($storage_provisioned = $summary-storage-committed + $summary-storage-uncommitted)$storage_provisioned VC__FK$moref-serverGuid.toUpperCase() VirtualMachine VM_APPLICATION_INFO__ARRAY #if($config-template=="false")$config-instanceUuid.toUpperCase().replace("-", "")|VM_APPLICATION_INFO#else$!GLOBAL-EMPTY#end VM_APPLICATION_INFO__ARRAY ## #set($lin_pattern = '([^"]*"[^"]*){4}')## #set($win_pattern = '([^"]*"[^"]*){8}')## [#foreach($option in $!config-extraConfig)## #* *##if("guestinfo.appInfo" == $option.key)## #* *##if($!option.value != "")## #* *##set($info_array_start_index = $option.value.indexOf(":[") + 2)## #* *##set($info_array_end_index = $option.value.indexOf("]}"))## #* *##set($info_array_string = $option.value.substring($info_array_start_index, $info_array_end_index))## #* *##set($info_array = $info_array_string.split("\n"))## #* *##foreach($info_row in $info_array)## #* *##if(!$info_row.isEmpty())## #* *#{ #* *##set($app_name = "")## #* *##set($app_version = "")## #* *##if($info_row.matches($lin_pattern))## #* *##set($app_name = $info_row.substring(12, $info_row.lastIndexOf('"')))## #* *##elseif($info_row.matches($win_pattern))## #* *##set($app_name = $info_row.substring(6, $info_row.indexOf('"', 6)))## #* *##set($version_start_index = $info_row.indexOf('"v"') + 5)## #* *##set($app_version = $info_row.substring($version_start_index, $info_row.lastIndexOf('"')))## #* *##end #* *##if(!$app_version.isEmpty())## #* *#"application_version": "$app_version", #* *##end## #* *#"application_name": "$app_name", #* *#"id": "$config-instanceUuid.toUpperCase().replace("-", "")|$app_name|$app_version|$foreach.count" #* *#}## #* *##if($foreach.hasNext),#end #* *##end #* *##end## #* *##end## #* *##break #* *##end #end]## VM__FK $config-instanceUuid.toUpperCase().replace("-", "") VC__FK $moref-serverGuid.toUpperCase() VirtualMachine VM_CONTAINER_INFO__ARRAY #if($config-template=="false")$config-instanceUuid.toUpperCase().replace("-", "")|VM_CONTAINER_INFO#else$!GLOBAL-EMPTY#end VM_CONTAINER_INFO__ARRAY ## [#foreach($option in $!config-extraConfig)## #* *##if("guestinfo.vmtools.containerinfo" == $option.key)## #* *##if($!option.value != "")## #* *##set($info_array_start_index = $option.value.indexOf(": [") + 3)## #* *##set($info_array_end_index = $option.value.indexOf("]}"))## #* *##set($info_array_string = $option.value.substring($info_array_start_index, $info_array_end_index))## #* *##set($info_array = $info_array_string.split(","))## #* *##foreach($info_row in $info_array)## #* *##if(!$info_row.isEmpty())## #* *#{ #* *##set($container_name = "")## #* *##set($container_name = $info_row.substring(6, $info_row.indexOf('"', 6)))## #* *#"container_name": "$container_name", #* *#"id": "$config-instanceUuid.toUpperCase().replace("-", "")|$container_name|$foreach.count" #* *#}## #* *##if($foreach.hasNext),#end #* *##end #* *##end## #* *##end## #* *##break #* *##end #end]## VM__FK $config-instanceUuid.toUpperCase().replace("-", "") VC__FK $moref-serverGuid.toUpperCase() vir:VIRTUAL_MACHINE_VIDEO_CARD VirtualMachine VIRTUAL_MACHINE_VIDEO_CARD__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|VIRTUAL_MACHINE_VIDEO_CARD VIRTUAL_MACHINE_VIDEO_CARD__ARRAY ##This is done since we want to skip the final ',' which breaks the json validity #set($VirtualVideoCard="VirtualVideoCard") #set($VirtualPCIPassthrough="VirtualPCIPassthrough") #set($validItems=[]) #foreach($item in $config-hardware-device)#if($config-template=="false")#if($item.class.name.contains($VirtualVideoCard)|| $item.class.name.contains($VirtualPCIPassthrough)) #set($void=$validItems.add($item)) #end#end#end [#foreach($item in $validItems) { "ID": "$moref-serverGuid.toUpperCase()|$moref-value|$item.key", "VM_MO_ID": "$moref-value", #if($item.connectable) "connectable_allow_guest_control": "$item.connectable.allowGuestControl", "connectable_connected": "$item.connectable.connected", "connectable_start_connected": "$item.connectable.startConnected", #if($item.connectable.status)"connectable_status": "$item.connectable.status",#end #end #if($item.class.name.contains($VirtualPCIPassthrough)) #if($!item.backing.class.name.contains("VmiopBackingInfo")) "device_type" : "$VirtualPCIPassthrough", "vgpu" : "$!item.backing.vgpu" #end #elseif($item.class.name.contains($VirtualVideoCard)) "device_type" : "$VirtualVideoCard", "enable3d_support": "$item.enable3DSupport", "graphics_memory_size_in_kb": "$item.graphicsMemorySizeInKB", "num_displays": "$item.numDisplays", #if($item.use3dRenderer)"use3d_renderer": "$item.use3dRenderer",#end "use_auto_detect": "$item.useAutoDetect", "video_ram_size_in_kb": "$item.videoRamSizeInKB" #end }#if($foreach.hasNext),#end#end] VM__FK$config-instanceUuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() vir:ESX HostSystem ESX $hardware-systemInfo-uuid.toUpperCase().replace("-", "")## #macro( getOptionValue $key $options )## #foreach( $option in $options )## #if($option.key==$key)$option.value#break## #end#end#end cpu_vendor $hardware-cpuPkg.get(0).vendor numSockets hardware-cpuInfo-numCpuPackages numCores hardware-cpuInfo-numCpuCores cpuSpeed hardware-cpuInfo-hz busSpeed $hardware-cpuPkg.get(0).busHz hardware_model hardware-systemInfo-model vendorName hardware-systemInfo-vendor HYPERTHREADINGSUPPORTED config-hyperThread-available HYPERTHREADINGACTIVE config-hyperThread-active PRODUCT_NAME config-product-name PRODUCT_FULLNAME config-product-fullName version config-product-version allow_guest_host_info #getOptionValue( "Misc.GuestLibAllowHostInfo" $config-option ) iommu_interrupt_remapping_disabled #getOptionValue( "VMkernel.Boot.iovDisableIR" $config-option ) lro_for_vmxnet3_enabled #getOptionValue( "Net.Vmxnet3HwLRO" $config-option ) lro_for_vmxnet2_enabled #getOptionValue( "Net.Vmxnet2HwLRO" $config-option ) tcpip_def_lro_enabled #getOptionValue( "Net.TcpipDefLROEnabled" $config-option ) use_hardware_tso_enabled #getOptionValue( "Net.UseHwTSO" $config-option ) use_hardware_tso6_enabled #getOptionValue( "Net.UseHwTSO6" $config-option ) blue_screen_timeout #getOptionValue( "Misc.BlueScreenTimeout" $config-option ) netqueue_enabled #getOptionValue( "VMkernel.Boot.netNetqueueEnabled" $config-option ) storage_max_devices #getOptionValue( "VMkernel.Boot.storageMaxDevices" $config-option ) no_redundant_management_network ## #set($result=false)## #foreach( $item in $configIssue )#if($item.class.name.contains("HostNoRedundantManagementNetworkEvent"))#set($result=true)#break#end#end## $result## anonymized_global_logdir $GLOBAL-DigestUtils.sha256Hex("#getOptionValue( 'Syslog.global.logDir' $config-option )") anonymized_global_logdir_datastore_name ## #set($option_value = "#getOptionValue( 'Syslog.global.logDir' $config-option )")## #set($datastore_start_index = $option_value.indexOf("[") + 1)## #set($datastore_end_index = $option_value.indexOf("]"))## #set($logdir_datastore_name = $option_value.substring($datastore_start_index, $datastore_end_index))## #if($!logdir_datastore_name != "")$GLOBAL-DigestUtils.sha256Hex($logdir_datastore_name)## #else$!GLOBAL-EMPTY#end## anonymized_current_scratch_location $GLOBAL-DigestUtils.sha256Hex("#getOptionValue( 'ScratchConfig.CurrentScratchLocation' $config-option )") is_current_scratch_location_vsan_datastore ## #set($option_value="#getOptionValue( 'ScratchConfig.CurrentScratchLocation' $config-option )")## #if($option_value.contains("/vmfs/volumes/vsan:"))true#{else}false#end## hyperthreading_mitigation #getOptionValue( "VMkernel.Boot.hyperthreadingMitigation" $config-option ) configured_scratch_location ## #set($option_value = "#getOptionValue( 'ScratchConfig.ConfiguredScratchLocation' $config-option )")## #set($datastore_dir = "/vmfs/volumes/")## #set($datastore_dir_index = $option_value.indexOf($datastore_dir))## #if($datastore_dir_index != -1)## #set($url_start_index = $datastore_dir_index + $datastore_dir.length())## #set($url_end_index = $option_value.indexOf("/", $url_start_index))## #if($url_end_index == -1)$option_value.substring($datastore_dir_index)## #else#set($url_end_index = $url_end_index + 1)## $option_value.substring(0, $url_end_index)...#end#end## PHYSICALMEMORYINBYTES hardware-memorySize BIOS_VERSION hardware-biosInfo-biosVersion MO_ID $moref-value build summary-config-product-build connection_State runtime-connectionState in_Maintenance_Mode runtime-inMaintenanceMode in_Quarantine_Mode runtime-inQuarantineMode is_Standalone isStandalone uptime summary-quickStats-uptime WAKE_ON_LAN_CAPABLE config-wakeOnLanCapable IP_V6_ENABLED config-network-ipV6Enabled NUM_CPU_THREADS summary-hardware-numCpuThreads NUM_NICS summary-hardware-numNics PNIC_AVAILABLE_BANDWIDTH_FOR_VM_TRAFFIC $summary-runtime-networkRuntimeInfo-networkResourceRuntime-pnicResourceInfo.get(0).availableBandwidthForVMTraffic BOOT_TIME $summary-runtime-bootTime.getTime().getTime() POWER_STATE summary-runtime-powerState RT_STANDBY_MODE summary-runtime-standbyMode CRYPTO_STATE summary-runtime-cryptoState FT_ENABLED summary-config-faultToleranceEnabled VMOTION_ENABLED summary-config-vmotionEnabled ANONYMIZED_IPMI_BMC_MAC_ADDRESS $GLOBAL-DigestUtils.sha256Hex($config-ipmi-bmcMacAddress) ANONYMIZED_IPMI_LOGIN $GLOBAL-DigestUtils.sha256Hex($config-ipmi-login) ANONYMIZED_IPMI_BMC_IP_ADDRESS $GLOBAL-DigestUtils.sha256Hex($config-ipmi-bmcIpAddress) RT_DAS_HOST_STATE runtime-dasHostState-state MEM_USAGE summary-quickStats-overallMemoryUsage CPU_USAGE summary-quickStats-overallCpuUsage OS_TYPE summary-config-product-osType DATASTORE_COUNT $datastore-length GRAPHICS_INFO_COUNT $config-graphicsInfo-length NUMERIC_SENSOR_INFO_COUNT $summary-runtime-healthSystemRuntime-systemHealthInfo-numericSensorInfo-length VM_COUNT $vm-length scsi_lun_count $!config-storageDevice-scsiLun-length cpu_model $hardware-cpuPkg.get(0).description numberOfAlarms $triggeredAlarmState-length permission_count $permission-length cpu_feature_level1_eax #foreach($cpuId in $hardware-cpuFeature)## #if($cpuId.level == 1)$cpuId.eax#break#end#end## lockdown_mode config-lockdownMode serialNumber hardware-systemInfo-serialNumber VC__FK $moref-serverGuid.toUpperCase() VC_CLUSTER__FK #if($parent.type=="ClusterComputeResource")$parent.serverGuid.toUpperCase()|$parent.value#else$!GLOBAL-EMPTY#end vir:HostTelemetryManager TelemetryManager ESX_TELEMETRY__ARRAY ## #set($uri=$resultItem-resourceObject-uri.toString().toUpperCase())## #set($separator_index=$uri.indexOf(":") + 1)## #set($host_system_uuid=$uri.substring($separator_index).replace("-", ""))## $host_system_uuid|ESX_TELEMETRY## ESX_TELEMETRY__ARRAY ## [{## "ID": "$host_system_uuid",## #foreach($entry in $telemetryData.data)## #if($entry.value.class.name.startsWith("[Ljava.lang"))## when the entry value is a list of primitives "$entry.key": "[#foreach($val in $entry.value)\"$val\"#if($foreach.hasNext),#end#end]"## #else## "$entry.key": "$entry.value"## #end#if($foreach.hasNext),#end#end## }] VC__FK ${global-vcId.toUpperCase()} ESX__FK $host_system_uuid vsst:StoragePod StoragePod STORAGE_POD $moref-serverGuid.toUpperCase()|$moref-value IO_LOAD_BALANCE_ENABLED podStorageDrsEntry-storageDrsConfig-podConfig-ioLoadBalanceEnabled IO_LATENCY_THRESHOLD podStorageDrsEntry-storageDrsConfig-podConfig-ioLoadBalanceConfig-ioLatencyThreshold IO_LOAD_IMBALANCE_THRESHOLD podStorageDrsEntry-storageDrsConfig-podConfig-ioLoadBalanceConfig-ioLoadImbalanceThreshold RESERVABLE_PERCENT_THRESHOLD podStorageDrsEntry-storageDrsConfig-podConfig-ioLoadBalanceConfig-reservablePercentThreshold RESERVABLE_THRESHOLD_MODE podStorageDrsEntry-storageDrsConfig-podConfig-ioLoadBalanceConfig-reservableThresholdMode POD_CONFIG_ENABLED podStorageDrsEntry-storageDrsConfig-podConfig-enabled LOAD_BALANCE_INTERVAL podStorageDrsEntry-storageDrsConfig-podConfig-loadBalanceInterval DFT_VM_BEHAVIOR podStorageDrsEntry-storageDrsConfig-podConfig-defaultVmBehavior DFT_INTRA_VM_AFFINITY podStorageDrsEntry-storageDrsConfig-podConfig-defaultIntraVmAffinity SPACE_THRESHOLD_MODE podStorageDrsEntry-storageDrsConfig-podConfig-spaceLoadBalanceConfig-spaceThresholdMode FREE_SPACE_THRESHOLD_GB podStorageDrsEntry-storageDrsConfig-podConfig-spaceLoadBalanceConfig-freeSpaceThresholdGB MIN_SPACE_UTILIZATION_DIFFERENCE podStorageDrsEntry-storageDrsConfig-podConfig-spaceLoadBalanceConfig-minSpaceUtilizationDifference SPACE_UTILIZATION_THRESHOLD podStorageDrsEntry-storageDrsConfig-podConfig-spaceLoadBalanceConfig-spaceUtilizationThreshold IO_LOAD_BALANCE_MODE podStorageDrsEntry-storageDrsConfig-podConfig-automationOverrides-ioLoadBalanceAutomationMode POLICY_ENFORCEMENT_AUTOMATION_MODE podStorageDrsEntry-storageDrsConfig-podConfig-automationOverrides-policyEnforcementAutomationMode RULE_ENFORCEMENT_AUTOMATION_MODE podStorageDrsEntry-storageDrsConfig-podConfig-automationOverrides-ruleEnforcementAutomationMode SPACE_LOAD_BALANCE_AUTOMATION_MODE podStorageDrsEntry-storageDrsConfig-podConfig-automationOverrides-spaceLoadBalanceAutomationMode VM_EVALUATION_AUTOMATION_MODE podStorageDrsEntry-storageDrsConfig-podConfig-automationOverrides-vmEvacuationAutomationMode NUM_VMDK_AFFINITY_RULES $num_affinity NUM_VMDK_ANTIAFFINITY_RULES ## #set($num_antiaffinity = 0)## #foreach($item in $!podStorageDrsEntry-storageDrsConfig-vmConfig)## #if($item.intraVmAntiAffinity)## #set($num_antiaffinity = $num_antiaffinity + 1)## #end#end## $num_antiaffinity NUM_INTER_VM_ANTIAFFINITY_RULES ## #set($num_inter_vm_antiaffinity = 0)## #foreach($item in $!podStorageDrsEntry-storageDrsConfig-podConfig-rule)## #if($item.class.name.contains("AntiAffinityRuleSpec"))## #set($num_inter_vm_antiaffinity = $num_inter_vm_antiaffinity + 1)## #end#end## $num_inter_vm_antiaffinity VC__FK$moref-serverGuid.toUpperCase() StoragePod STORAGE_POD_TO_DATASTORE__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|STORAGE_POD_TO_DATASTORE STORAGE_POD_TO_DATASTORE__ARRAY [#foreach($item in $!childEntity) { "ID": "$moref-serverGuid.toUpperCase()|$moref-value|$item.value", "DATASTORE_MO_ID": "$item.value" }#if($foreach.hasNext),#end#end] STORAGE_POD__FK$moref-serverGuid.toUpperCase()|$moref-value VC__FK$moref-serverGuid.toUpperCase() vsst:VirtualApp VirtualApp VIRTUAL_APP $moref-serverGuid.toUpperCase()|$moref-value CPU_ALLOC_RESERVATION config-cpuAllocation-reservation CPU_ALLOC_LIMIT config-cpuAllocation-limit CPU_ALLOC_SHARES_SHARES config-cpuAllocation-shares-shares CPU_ALLOC_SHARES_LEVEL config-cpuAllocation-shares-level CPU_ALLOC_EXPANDABLE_RESERVATION config-cpuAllocation-expandableReservation MEM_ALLOC_RESERVATION config-memoryAllocation-reservation MEM_ALLOC_LIMIT config-memoryAllocation-limit MEM_ALLOC_SHARES_SHARES config-memoryAllocation-shares-shares MEM_ALLOC_SHARES_LEVEL config-memoryAllocation-shares-level MEM_ALLOC_EXPANDABLE_RESERVATION config-memoryAllocation-expandableReservation MO_ID $moref-value VC__FK$moref-serverGuid.toUpperCase() VirtualApp VIRTUAL_APP_ENTITY_CONFIG_INFO__ARRAY moref-serverGuid.toUpperCase()|$moref-value|virtual_app_entity_config_info VIRTUAL_APP_ENTITY_CONFIG_INFO__ARRAY [#foreach($item in $vAppConfig-entityConfig)## {#set($entity_type = "#if( $item.key )$item.key.type#end")## "ID": "$moref-serverGuid.toUpperCase()|$moref-value|$!item.key.value", "ENTITY_MO_ID": "$!item.key.value", "ENTITY_TYPE": "#if($entity_type == "VirtualApp")VIRTUAL_APP#elseif($entity_type == "VirtualMachine")VM#else$entity_type#end", "START_ORDER": "$!item.startOrder", "START_DELAY_SECONDS": "$!item.startDelay", "START_ACTION": "$!item.startAction", "STOP_DELAY_SECONDS": "$!item.stopDelay", "STOP_ACTION": "$!item.stopAction", "WAITING_FOR_GUEST": "$!item.waitingForGuest" }#if($foreach.hasNext),#end#end] VC__FK$moref-serverGuid.toUpperCase() VIRTUAL_APP__FK$moref-serverGuid.toUpperCase()|$moref-value vsst:ResourcePool ResourcePool RESOURCE_POOL $moref-serverGuid.toUpperCase()|$moref-value CPU_ALLOC_RESERVATION config-cpuAllocation-reservation CPU_ALLOC_LIMIT config-cpuAllocation-limit CPU_ALLOC_SHARES_SHARES config-cpuAllocation-shares-shares CPU_ALLOC_SHARES_LEVEL config-cpuAllocation-shares-level CPU_ALLOC_EXPANDABLE_RESERVATION config-cpuAllocation-expandableReservation MEM_ALLOC_RESERVATION config-memoryAllocation-reservation MEM_ALLOC_LIMIT config-memoryAllocation-limit MEM_ALLOC_SHARES_SHARES config-memoryAllocation-shares-shares MEM_ALLOC_SHARES_LEVEL config-memoryAllocation-shares-level MEM_ALLOC_EXPANDABLE_RESERVATION config-memoryAllocation-expandableReservation VM_COUNT $vm-length parent $moref-serverGuid.toUpperCase()|$parent.value permission_count $permission-length VC__FK$moref-serverGuid.toUpperCase() vsst:HostStorageSystem HostStorageSystem ESX_SUPPORTED_VOLUME_TYPES $moref-serverGuid.toUpperCase()|$moref-value VOLUME_TYPE_LIST #foreach($type in $fileSystemVolumeInfo-volumeTypeList) $type#if($foreach.hasNext),#end#end VC__FK$moref-serverGuid.toUpperCase() ESX_TO_ESX_STORAGE_SYSTEM HostSystem ESX_TO_ESX_SUPPORTED_VOLUME_TYPES $moref-serverGuid.toUpperCase()|$hardware-systemInfo-uuid.toUpperCase().replace("-", "")|$configManager-storageSystem.value ESX__FK$hardware-systemInfo-uuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() ESX_SUPPORTED_VOLUME_TYPES__FK$moref-serverGuid.toUpperCase()|$configManager-storageSystem.value vsst:VirtualMachineSnapshot VirtualMachineSnapshot VM_SNAPSHOT $moref-serverGuid.toUpperCase()|$moref-value ANONYMIZED_VM_PATH_NAME $GLOBAL-DigestUtils.sha256Hex($config-files-vmPathName) ANONYMIZED_SNAPSHOT_DIRECTORY $GLOBAL-DigestUtils.sha256Hex($config-files-snapshotDirectory) ANONYMIZED_SUSPEND_DIRECTORY $GLOBAL-DigestUtils.sha256Hex($config-files-suspendDirectory) ANONYMIZED_LOG_DIRECTORY $GLOBAL-DigestUtils.sha256Hex($config-files-logDirectory) HARDWARE_DEVICE_COUNT $config-hardware-device-length VFLASH_CACHE_RESERVATION config-vFlashCacheReservation CHANGE_TRACKING_ENABLED config-changeTrackingEnabled SNAPSHOT_LOCKED config-flags-snapshotLocked DISK_UUID_ENABLED config-flags-diskUuidEnabled SNAPSHOT_DISABLED config-flags-snapshotDisabled vm_uuid config-instanceUuid VC__FK$moref-serverGuid.toUpperCase() vcenter-datacenter-count vc_datacenter_count $global-vcId.toUpperCase() num_datacenters totalMatchedObjectCount vc_instance__fk $global-vcId.toUpperCase() collection__fk $global-collectionId vcenter-cluster-statistics ClusterComputeResource vc_cluster $moref-serverGuid.toUpperCase()|$moref-value num_datastores $datastore-length num_networks $network-length num_resource_pools $rps-length ha_enabledconfiguration-dasConfig-enabled drs_enabledconfiguration-drsConfig-enabled evc_mode#foreach($evcMode in $SI-Capability.supportedEVCMode)#if($evcMode.key.equals($summary-currentEVCModeKey))$evcMode.label#break#end#end num_vmotionssummary-numVmotions num_vmotions_drs_triggered $migrationHistory-length total_cpu_mhzsummary-usageSummary-totalCpuCapacityMhz total_memory_mbsummary-usageSummary-totalMemCapacityMB total_storage_bstorageTotalB DFT_DPM_BEHAVIOR configurationEx-dpmConfigInfo-defaultDpmBehavior HOST_POWER_ACTION_RATE configurationEx-dpmConfigInfo-hostPowerActionRate DPM_CFG_INFO_ENABLED configurationEx-dpmConfigInfo-enabled DFT_VM_BEHAVIOR configuration-drsConfig-defaultVmBehavior DRS_CFG_VMOTION_RATE configuration-drsConfig-vmotionRate DRS_CFG_ENABLE_VM_BEHAVIOR_OVERRIDES configuration-drsConfig-enableVmBehaviorOverrides DAS_CFG_ADMISSION_CONTROL_POLICY_FAILOVER_LEVEL configuration-dasConfig-admissionControlPolicy-failoverLevel DAS_CFG_ADMISSION_CONTROL_POLICY_FAILOVER_RESOURCE_REDUCTION_TOLERATE_PERCENT configuration-dasConfig-admissionControlPolicy-resourceReductionToToleratePercent DAS_CFG_ADMISSION_CONTROL_POLICY_FAILOVER_SLOT_POLICY_CPU_MHZ configuration-dasConfig-admissionControlPolicy-slotPolicy-cpu DAS_CFG_ADMISSION_CONTROL_POLICY_FAILOVER_SLOT_POLICY_MEMORY_MB configuration-dasConfig-admissionControlPolicy-slotPolicy-memory DAS_IGNORE_REDUNDANT_NET_WARNING ## #set($result=false)## #foreach($option in $!configuration-dasConfig-option)#if("das.ignoreRedundantNetWarning"==$option.key)#set($result=$!option.value)#break#end#end## $result## POWER_OFF_VM_COUNT summary-usageSummary-poweredOffVmCount POWER_OFF_MEM_RESERVATION_MB summary-usageSummary-poweredOffMemReservationMB TOTAL_MEM_CAPACITY_MB summary-usageSummary-totalMemCapacityMB MEM_DEMAND_MB summary-usageSummary-memDemandMB MEM_ENTITLE_MB summary-usageSummary-memEntitledMB POWER_OFF_CPU_RESERVATION_MB summary-usageSummary-poweredOffCpuReservationMhz TOTAL_VM_COUNT summary-usageSummary-totalVmCount CPU_RESERVATION_MHZ summary-usageSummary-cpuReservationMhz TOTAL_CPU_CAPACITY_MHZ summary-usageSummary-totalCpuCapacityMhz CPU_DEMAND_MHZ summary-usageSummary-cpuDemandMhz TARGET_BALANCE summary-targetBalance NUM_CPU_CORES summary-numCpuCores CURRENT_BALANCE summary-currentBalance OVERALL_STATUS summary-overallStatus NUM_EFFECTIVE_HOSTS summary-numEffectiveHosts DAS_VM_CFG_HOST_MONITORING configurationEx-dasConfig-hostMonitoring DAS_CFG_HEARTBEAT_DATASTORE_COUNT $configurationEx-dasConfig-heartbeatDatastore-length DAS_VM_CFG_VM_MONITORING configurationEx-dasConfig-vmMonitoring DAS_VM_CFG_CPU_FAILOVER_CPU_RESOURCES_PERCENT configurationEx-dasConfig-admissionControlPolicy-cpuFailoverResourcesPercent DAS_VM_CFG_FAILOVER_MEM_RESOURCES_PERCENT configurationEx-dasConfig-admissionControlPolicy-memoryFailoverResourcesPercent DAS_VM_CFG_FAILOVER_LEVEL configurationEx-dasConfig-admissionControlPolicy-failoverLevel DAS_CFG_ADMISSION_CONTROL_POLICY_FAILOVER_HOSTS_LENGTH $configurationEx-dasConfig-admissionControlPolicy-failoverHosts-length DAS_CFG_ADMISSION_CONTROL_POLICY_TYPE #set($policyClass=$configurationEx-dasConfig-admissionControlPolicy.getClass().getName())#if($policyClass and not $policyClass.isEmpty())#set( $lastDot = $policyClass.lastIndexOf("."))#set( $lastDotPlusOne = $lastDot + 1)$policyClass.substring($lastDotPlusOne)#else$!GLOBAL-EMPTY#end DAS_VM_CFG_ENABLED configurationEx-dasConfig-enabled DAS_CFG_DFT_VM_SETTINGS_CLUSTER_SETTINGS configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-clusterSettings DAS_CFG_DFT_VM_SETTINGS_VM_MONITORING configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-vmMonitoring DAS_CFG_DFT_VM_SETTINGS_VM_TOOL_MONITOR_SETTINGS_ENABLED configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-enabled DAS_CFG_DFT_VM_SETTINGS_VM_TOOL_MONITOR_SETTINGS_MIN_UPTIME configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-minUpTime DAS_CFG_DFT_VM_SETTINGS_VM_TOOL_MONITOR_SETTINGS_FAILURE_INTERVAL configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-failureInterval DAS_CFG_DFT_VM_SETTINGS_VM_TOOL_MONITOR_SETTINGS_MAX_FAILURE_WINDOW configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-maxFailureWindow DAS_CFG_DFT_VM_SETTINGS_VM_TOOL_MONITOR_SETTINGS_MAX_FAILURES configurationEx-dasConfig-defaultVmSettings-vmToolsMonitoringSettings-maxFailures DAS_CFG_DFT_VM_SETTINGS_ISOLATION_RESPONSE configurationEx-dasConfig-defaultVmSettings-isolationResponse DAS_CFG_DFT_VM_SETTINGS_RESTART_PRIORITY configurationEx-dasConfig-defaultVmSettings-restartPriority DAS_CFG_DFT_VM_SETTINGS_VM_REACTION_ON_APD_CLEARED configurationEx-dasConfig-defaultVmSettings-vmComponentProtectionSettings-vmReactionOnAPDCleared DAS_CFG_DFT_VM_SETTINGS_VM_STORAGE_PROTECTION_FOR_PDL configurationEx-dasConfig-defaultVmSettings-vmComponentProtectionSettings-vmStorageProtectionForPDL DAS_CFG_DFT_VM_SETTINGS_VM_TERMINATION_DELAY_FOR_APD_SEC configurationEx-dasConfig-defaultVmSettings-vmComponentProtectionSettings-vmTerminateDelayForAPDSec DAS_CFG_DFT_VM_SETTINGS_VM_STORAGE_PROTECTION_FOR_APD configurationEx-dasConfig-defaultVmSettings-vmComponentProtectionSettings-vmStorageProtectionForAPD DAS_CFG_DFT_VM_SETTINGS_ENABLE_APD_TIMEOUT_FOR_HOSTS configurationEx-dasConfig-defaultVmSettings-vmComponentProtectionSettings-enableAPDTimeoutForHosts DAS_CFG_FAILOVER_LEVEL configurationEx-dasConfig-failoverLevel DAS_CFG_ADMISSION_CONTROL_ENABLED configurationEx-dasConfig-admissionControlEnabled DAS_CFG_HEARTBEAT_DATASTORE_CANDIDATE_POLICY configurationEx-dasConfig-hBDatastoreCandidatePolicy DAS_CFG_METRO_HA_SETTINGS_ENABLED configurationEx-dasConfig-metroHASettings-enabled DAS_CFG_VM_COMPONENT_PROTECTING configurationEx-dasConfig-vmComponentProtecting ANONYMIZED_NAME $GLOBAL-DigestUtils.sha256Hex($name) NUM_HOSTS summary-numHosts TOTAL_MEMORY summary-totalMemory MEM_RESERVATION_MB summary-usageSummary-memReservationMB CPU_ENTITLED_MHZ summary-usageSummary-cpuEntitledMhz STATS_GEN_NUM summary-usageSummary-statsGenNumber CURRENT_FAILOVER_LEVEL summary-currentFailoverLevel DAS_DATA_HOST_LIST_VERSION summary-dasData-hostListVersion DAS_DATA_CLUSTER_CONFIG_VERSION summary-dasData-clusterConfigVersion DAS_DATA_COMPAT_LIST_VERSION summary-dasData-compatListVersion TOTAL_CPU summary-totalCpu EFFECTIVE_MEM summary-effectiveMemory EFFECTIVE_CPU summary-effectiveCpu permissions_count $permission-length proactive_drs_enabled configurationEx-proactiveDrsConfig-enabled proactive_drs_lookahead_interval_secs = 0 && $option_value.compareTo('43200') <= 0)## $option.value#break## #else## -1#break## #end## #end## #end## #end## #end## #end##]]> INFRA_UPDATE_HA_ENABLED configurationEx-infraUpdateHaConfig-enabled INFRA_UPDATE_HA_BEHAVIOR configurationEx-infraUpdateHaConfig-behavior INFRA_UPDATE_HA_MODERATE_REMEDIATION configurationEx-infraUpdateHaConfig-moderateRemediation INFRA_UPDATE_HA_SEVERE_REMEDIATION configurationEx-infraUpdateHaConfig-severeRemediation VC__FK $moref-serverGuid.toUpperCase() ClusterComputeResource CLUSTER_DRS_ADVANCED_OPTIONS__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|CLUSTER_DRS_ADVANCED_OPTIONS CLUSTER_DRS_ADVANCED_OPTIONS__ARRAY [#foreach($option in $configurationEx-drsConfig-option) { "id": "$moref-serverGuid.toUpperCase()|$moref-value|$option.key", "option_key": "$option.key", "option_value": "$option.value" }#if($foreach.hasNext),#end#end] VC_CLUSTER__FK $moref-serverGuid.toUpperCase()|$moref-value ClusterComputeResource CLUSTER_RULE__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|CLUSTER_RULE CLUSTER_RULE__ARRAY ## #if($configurationEx-rule)## [#foreach($rule in $configurationEx-rule) { "id": "$moref-serverGuid.toUpperCase()|$moref-value|$!rule.ruleUuid", "key": "$!rule.key", "status": "$!rule.status", "enabled": "$!rule.enabled", #if($rule.name)"name": "$GLOBAL-DigestUtils.sha256Hex($rule.name)", #end "mandatory": "$!rule.mandatory", "user_created": "$!rule.userCreated", "in_compliance": "$!rule.inCompliance", "rule_uuid": "$!rule.ruleUuid", #if($rule.class.name.contains("VmHostRuleInfo"))## #if($rule.affineHostGroupName)"affine_host_group_name": "$GLOBAL-DigestUtils.sha256Hex($rule.affineHostGroupName)", #end #if($rule.antiAffineHostGroupName)"anti_affine_host_group_name": "$GLOBAL-DigestUtils.sha256Hex($rule.antiAffineHostGroupName)", #end #if($rule.vmGroupName)"vm_group_name": "$GLOBAL-DigestUtils.sha256Hex($rule.vmGroupName)", #end #end #set($rule_class_simple_name_index=$rule.getClass().getName().lastIndexOf(".") + 1) "rule_type": "$rule.getClass().getName().substring($rule_class_simple_name_index)" }#if($foreach.hasNext),#end#end]#end VC_CLUSTER__FK $moref-serverGuid.toUpperCase()|$moref-value ClusterComputeResource CLUSTER_RULE_VM__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|CLUSTER_RULE_VM CLUSTER_RULE_VM__ARRAY ## ##due to filtering in the foreach loops the standard way for generating commas between json array elements doesn't work in this query ##we need to put comma before each json array element except the first one #set($is_first_element=true)## #if($configurationEx-rule)## [#foreach($rule in $configurationEx-rule) ## The following "if" catches both AffinityRuleSpec and AntiAffinityRuleSpec #if($rule.class.name.contains("AffinityRuleSpec")) #foreach($vm in $rule.vm) #if(not $is_first_element),#end { "id": "$moref-serverGuid.toUpperCase()|$moref-value|$!rule.ruleUuid|$vm.value", "vm_moid": "$vm.value", "CLUSTER_RULE__FK": "$moref-serverGuid.toUpperCase()|$moref-value|$!rule.ruleUuid" }#set($is_first_element=false)## #end#end#end]#end## ## VC_CLUSTER__FK $moref-serverGuid.toUpperCase()|$moref-value ClusterComputeResource CLUSTER_DRS_VM_CONFIG_INFO__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|CLUSTER_DRS_VM_CONFIG_INFO CLUSTER_DRS_VM_CONFIG_INFO__ARRAY ## #if($configurationEx-drsVmConfig)## [#foreach($vm_override in $configurationEx-drsVmConfig) { "id": "$moref-serverGuid.toUpperCase()|$moref-value|$vm_override.key.value", "vm_mo_id": "$vm_override.key.value", "enabled": "$!vm_override.enabled", "behaviour": "$!vm_override.behavior" }#if($foreach.hasNext),#end#end]#end VC_CLUSTER__FK $moref-serverGuid.toUpperCase()|$moref-value vir:ESX_NETWORK_COMPONENTS HostSystem VIRTUAL_SWITCH__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|VIRTUAL_SWITCH VIRTUAL_SWITCH__ARRAY #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) [#foreach($item in $config-network-vswitch) { #set($hashed_name=$GLOBAL-DigestUtils.sha256Hex($item.name)) "ID": "$esx_id|$hashed_name", "NAME": "$hashed_name", #if($item.spec.bridge and $item.spec.bridge.nicDevice)"UPLINKS": "#foreach($nic in $item.spec.bridge.nicDevice) $nic#if($foreach.hasNext),#end#end",#end #if($item.spec.bridge and $item.spec.bridge.nicDevice)"NUMBER_UPLINKS": $item.spec.bridge.nicDevice.size(),#end #if($item.numPorts)"TOTAL_PORTS": $item.numPorts,#end #if($item.spec.numPorts)"CONFIGURED_PORTS": $item.spec.numPorts,#end #set($used=$item.numPorts - $item.numPortsAvailable) #if($used)"USED_PORTS": $used,#end #if($item.mtu)"MTU": $item.mtu,#end #if($item.spec.policy.nicTeaming.policy)"TEAMING_POLICY": #set($policy=$item.spec.policy.nicTeaming.policy) #if($policy=="loadbalance_ip") #set($policy="lb_ip") #elseif($policy=="loadbalance_srcmac") #set($policy="lb_srcmac") #elseif($policy=="loadbalance_srcid") #set($policy="lb_srcid") #elseif($policy=="failover_explicit") #set($policy="fo_explicit") #end "$policy",#end #if("$!item.spec.policy.security.allowPromiscuous" != "")"ALLOW_PROMISCUOUS_MODE": $item.spec.policy.security.allowPromiscuous,#end #if("$!item.spec.policy.security.macChanges" != "")"ALLOW_MAC_ADDRESS_CHANGE": $item.spec.policy.security.macChanges,#end #if("$!item.spec.policy.security.forgedTransmits" != "")"ALLOW_FORGED_TRANSMITS": $item.spec.policy.security.forgedTransmits,#end #if("$!item.spec.policy.shapingPolicy.enabled" != "")"SHAPING_POLICY_ENABLED": "$item.spec.policy.shapingPolicy.enabled",#end #if("$!item.spec.policy.shapingPolicy.averageBandwidth" != "")"SHAPING_POLICY_AVERAGE_BANDWIDTH_BPS": "$item.spec.policy.shapingPolicy.averageBandwidth",#end #if("$!item.spec.policy.shapingPolicy.peakBandwidth" != "")"SHAPING_POLICY_PEAK_BANDWIDTH_BPS": "$item.spec.policy.shapingPolicy.peakBandwidth",#end #if("$!item.spec.policy.shapingPolicy.burstSize" != "")"SHAPING_POLICY_BURST_SIZE_BYTES": "$item.spec.policy.shapingPolicy.burstSize",#end "TYPE": "vSphere Standard Switch"$!GLOBAL-EMPTY }#if($foreach.hasNext),#end#end] ESX__FK $hardware-systemInfo-uuid.toUpperCase().replace("-", "") HostSystem PORT_GROUP__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|PORT_GROUP PORT_GROUP__ARRAY #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) [#foreach($item in $config-network-portgroup) { #set($vswitch_name=$GLOBAL-DigestUtils.sha256Hex($item.spec.vswitchName)) "ID": "$esx_id|$vswitch_name|$GLOBAL-DigestUtils.sha256Hex($item.spec.name)", "NAME_ANONYMIZED": "$GLOBAL-DigestUtils.sha256Hex($item.spec.name)", "VIRTUAL_SWITCH_NAME": "$vswitch_name", #if($item.spec.vlanId)"VLAN_ID": "$item.spec.vlanId",#end #if($item.computedPolicy.nicTeaming.policy) "TEAMING_POLICY": #set($policy=$item.computedPolicy.nicTeaming.policy) #if($policy=="loadbalance_ip") #set($policy="lb_ip") #elseif($policy=="loadbalance_srcmac") #set($policy="lb_srcmac") #elseif($policy=="loadbalance_srcid") #set($policy="lb_srcid") #elseif($policy=="failover_explicit") #set($policy="fo_explicit") #end "$policy",#end #if("$!item.computedPolicy.security.allowPromiscuous" != "")"ALLOW_PROMISCUOUS_MODE": $item.computedPolicy.security.allowPromiscuous,#end #if("$!item.computedPolicy.security.macChanges" != "")"ALLOW_MAC_ADDRESS_CHANGE": $item.computedPolicy.security.macChanges,#end #if("$!item.computedPolicy.security.forgedTransmits" != "")"ALLOW_FORGED_TRANSMITS": $item.computedPolicy.security.forgedTransmits,#end #if("$item.spec.policy.shapingPolicy")## #if("$!item.spec.policy.shapingPolicy.enabled" != "")"SHAPING_POLICY_ENABLED": "$item.spec.policy.shapingPolicy.enabled",#end #if("$!item.spec.policy.shapingPolicy.averageBandwidth" != "")"SHAPING_POLICY_AVERAGE_BANDWIDTH_BPS": "$item.spec.policy.shapingPolicy.averageBandwidth",#end #if("$!item.spec.policy.shapingPolicy.peakBandwidth" != "")"SHAPING_POLICY_PEAK_BANDWIDTH_BPS": "$item.spec.policy.shapingPolicy.peakBandwidth",#end #if("$!item.spec.policy.shapingPolicy.burstSize" != "")"SHAPING_POLICY_BURST_SIZE_BYTES": "$item.spec.policy.shapingPolicy.burstSize",#end #end## "VIRTUAL_SWITCH__FK": "$esx_id|$vswitch_name" }#if($foreach.hasNext),#end#end] ESX__FK $hardware-systemInfo-uuid.toUpperCase().replace("-", "") HostSystem ESX_VIRTUAL_NIC_USAGE__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|VIRTUAL_NIC ESX_VIRTUAL_NIC_USAGE__ARRAY ##due to filtering in the foreach loops the standard way for generating commas between json array elements doesn't work in this query ##we need to put comma before each json array element except the first one #set($is_first_element=true) #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) [#foreach($netConfig in $config-virtualNicManagerInfo.netConfig) #foreach($vnic in $netConfig.candidateVnic) #if($netConfig.selectedVnic) #if($netConfig.selectedVnic.contains($vnic.key)) #if(not $is_first_element),#end { "ID": "$esx_id|$vnic.key", "KEY": "$vnic.key", "NIC_TYPE": "$netConfig.nicType", #if($vnic.spec.mtu)"MTU": "$vnic.spec.mtu",#end #if($vnic.spec.portgroup)"PORTGROUP_NAME_ANONYMIZED":"$GLOBAL-DigestUtils.sha256Hex($vnic.spec.portgroup)",#end #if($vnic.spec.distributedVirtualPort)"DISTRIBUTED_PORT_GROUP_MO_ID":"$vnic.spec.distributedVirtualPort.portgroupKey",#end #if($vnic.spec.distributedVirtualPort)"DISTRIBUTED_SWITCH__FK":"$vnic.spec.distributedVirtualPort.switchUuid.replace(" ", "")",#end #if($vnic.spec.pinnedPnic)"PINNED_PNIC":"$vnic.spec.pinnedPnic",#end #if($vnic.spec.netStackInstanceKey)"NET_STACK_INSTANCE_KEY":"$vnic.spec.netStackInstanceKey",#end "DEVICE": "$vnic.device" }#set($is_first_element=false) #end #end #end#end] ESX__FK$hardware-systemInfo-uuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() HostSystem ESX_TO_DISTRIBUTED_SWITCH_UPLINKS__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|DISTRIBUTED_SWITCH_UPLINKS DISTRIBUTED_SWITCH_UPLINKS__ARRAY [#foreach($item in $config-network-proxySwitch) { #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) #set($switch_id=$item.dvsUuid.toString().replace(" ", "")) "ID": "$esx_id|$switch_id", "ESX_MO_ID": "$moref-value", #if($item.spec.backing.pnicSpec)"UPLINKS": "#foreach($pnicSpec in $item.spec.backing.pnicSpec) $pnicSpec.pnicDevice#if($foreach.hasNext),#end#end",#end #if($item.spec.backing.pnicSpec)"NUMBER_UPLINKS": $item.spec.backing.pnicSpec.size(),#end "DISTRIBUTED_SWITCH__FK": "$switch_id" }#if($foreach.hasNext),#end#end] ESX__FK$hardware-systemInfo-uuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() PCI_DEVICES HostSystem ESX_PHYSICAL_NIC__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|ESX_PHYSICAL_NIC ESX_PHYSICAL_NIC__ARRAY #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) [#foreach($item in $config-network-pnic) { "ID": "$esx_id|$item.device", #if($item.driver)"DRIVER": "$item.driver",#end #if("$item.wakeOnLanSupported" != "")"IS_WAKE_ON_LAN_SUPPORTED": $item.wakeOnLanSupported,#end #if($item.linkSpeed) "IS_LINK_UP": true, "ACTUAL_SPEED_MBPS": $item.linkSpeed.speedMb, #{else}"IS_LINK_UP": false,#end #foreach($spec in $item.validLinkSpecification) #if(!$foreach.hasNext)"SPEED_MODE": "$spec.speedMb/#if($spec.duplex)full#{else}half#end",#end #end "CONFIGURED_SPEED_MBPS": #if($item.spec.linkSpeed)$item.spec.linkSpeed.speedMb#{else}0#end, #foreach($pci_dev in $hardware-pciDevice) #if($pci_dev.id==$item.pci)## #set($device_name = $pci_dev.deviceName.replace('"', '\"'))## "DEVICE_NAME": "$device_name", "VENDOR": "$pci_dev.vendorName", #end#end "NAME": "$item.device" }#if($foreach.hasNext),#end#end] ESX__FK$hardware-systemInfo-uuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() HostSystem ESX_PCI_DEVICE__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|ESX_PCI_DEVICE ESX_PCI_DEVICE__ARRAY #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) #set($String='') #set($driver_map={}) #foreach($item in $config-storageDevice-hostBusAdapter)#set($dummy=$driver_map.put($item.pci,$item.driver))#end #foreach($item in $config-network-pnic)#set($dummy=$driver_map.put($item.pci,$item.driver))#end [#foreach($item in $hardware-pciDevice) #set($device_name = $item.deviceName.replace('"', '\"'))## { "ID": "$esx_id|0x$String.format("%04x", $item.deviceId)|0x$String.format("%04x", $item.subDeviceId)|$item.id", #if($driver_map.get($item.id))"DRIVER": "$driver_map.get($item.id)",#end "VENDOR_ID": $item.vendorId, "SUB_VENDOR_ID": $item.subVendorId, "VENDOR": "$item.vendorName", "SUB_DEVICE_ID": $item.subDeviceId, "DEVICE_NAME": "$device_name", "DEVICE_CLASS_ID": $item.classId, #set($dev_class_name="") #if($item.classId==0)#set($dev_class_name = "Non-VGA unclassified device") #elseif($item.classId==255)#set($dev_class_name="Unclassified device") #elseif($item.classId==256)#set($dev_class_name="SCSI storage controller") #elseif($item.classId==257)#set($dev_class_name="IDE interface") #elseif($item.classId==260)#set($dev_class_name="RAID bus controller") #elseif($item.classId==262)#set($dev_class_name="SATA controller") #elseif($item.classId==263)#set($dev_class_name="Serial Attached SCSI controller") #elseif($item.classId==264)#set($dev_class_name="Non-Volatile memory controller") #elseif($item.classId==384)#set($dev_class_name="Mass storage controller") #elseif($item.classId==512)#set($dev_class_name="Ethernet controller") #elseif($item.classId==516)#set($dev_class_name="ISDN controller") #elseif($item.classId==640)#set($dev_class_name="Network controller") #elseif($item.classId==768)#set($dev_class_name="VGA compatible controller") #elseif($item.classId==770)#set($dev_class_name="3D controller") #elseif($item.classId==896)#set($dev_class_name="Display controller") #elseif($item.classId==1024)#set($dev_class_name="Multimedia video controller") #elseif($item.classId==1025)#set($dev_class_name="Multimedia audio controller") #elseif($item.classId==1027)#set($dev_class_name="Audio device") #elseif($item.classId==1152)#set($dev_class_name="Multimedia controller") #elseif($item.classId==1280)#set($dev_class_name="RAM memory") #elseif($item.classId==1281)#set($dev_class_name="FLASH memory") #elseif($item.classId==1408)#set($dev_class_name="Memory controller") #elseif($item.classId==1536)#set($dev_class_name="Host bridge") #elseif($item.classId==1537)#set($dev_class_name="ISA bridge") #elseif($item.classId==1540)#set($dev_class_name="PCI bridge") #elseif($item.classId==1664)#set($dev_class_name="Bridge") #elseif($item.classId==1792)#set($dev_class_name="Serial controller") #elseif($item.classId==1793)#set($dev_class_name="Parallel controller") #elseif($item.classId==1920)#set($dev_class_name="Communication controller") #elseif($item.classId==2048)#set($dev_class_name="PIC") #elseif($item.classId==2053)#set($dev_class_name="SD Host controller") #elseif($item.classId==2054)#set($dev_class_name="IOMMU") #elseif($item.classId==2176)#set($dev_class_name="System peripheral") #elseif($item.classId==2880)#set($dev_class_name="Co-processor") #elseif($item.classId==3072)#set($dev_class_name="FireWire (IEEE 1394)") #elseif($item.classId==3075)#set($dev_class_name="USB controller") #elseif($item.classId==3076)#set($dev_class_name="Fibre Channel") #elseif($item.classId==3077)#set($dev_class_name="SMBus") #elseif($item.classId==3078)#set($dev_class_name="InfiniBand") #elseif($item.classId==3079)#set($dev_class_name="IPMI SMIC interface") #elseif($item.classId==3345)#set($dev_class_name="Bluetooth") #elseif($item.classId==3584)#set($dev_class_name="I2O") #elseif($item.classId==4224)#set($dev_class_name="Encryption controller") #elseif($item.classId==4353)#set($dev_class_name="Performance counters") #elseif($item.classId==4384)#set($dev_class_name="Signal processing management") #elseif($item.classId==4480)#set($dev_class_name="Signal processing controller") #elseif($item.classId==65280)#set($dev_class_name="Unassigned class") #elseif($item.classId==65535)#set($dev_class_name="Uassigned class") #end "DEVICE_CLASS_NAME": "$dev_class_name", "DEVICE_ID": $item.deviceId }#if($foreach.hasNext),#end#end] ESX__FK$hardware-systemInfo-uuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() vsst:VM_VIRTUAL_DISK VirtualMachine VIRTUAL_DISK__ARRAY #if($config-template=="false")$config-instanceUuid.toUpperCase().replace("-","")|VIRTUAL_DISK__ARRAY#else$!GLOBAL-EMPTY#end VIRTUAL_DISK__ARRAY #set($vm_id=$config-instanceUuid.toUpperCase().replace("-", "")) [#foreach($item in $virtualDisks) { "ID": "$vm_id|$item.diskObjectId", #if($item.controllerKey)"CONTROLLER_KEY": $item.controllerKey,#end #if($!item.backing.datastore)"DATASTORE_MO_ID": "$item.backing.datastore.value",#end #if($item.backing.class.name.contains("FlatVer2BackingInfo")) #if($!item.backing.deltaDiskFormat)"DELTA_DISK_FORMAT": "$item.backing.deltaDiskFormat",#end #if("$!item.backing.digestEnabled" != "")"DIGEST_ENABLED": $item.backing.digestEnabled,#end #if("$!item.backing.eagerlyScrub" != "")"EAGERLY_SCRUB": $item.backing.eagerlyScrub,#end #if("$!item.backing.thinProvisioned" != "")"THIN_PROVISIONED": $item.backing.thinProvisioned,#end #elseif($item.backing.class.name.contains("SeSparseBackingInfo")) #if($!item.backing.deltaDiskFormat)"DELTA_DISK_FORMAT": "$item.backing.deltaDiskFormat",#end #if("$!item.backing.digestEnabled" != "")"DIGEST_ENABLED": $item.backing.digestEnabled,#end#end #if(!$item.backing.class.name.contains("RawDiskMappingVer1BackingInfo")) #if("$!item.backing.writeThrough" != "")"WRITE_THROUGH": $item.backing.writeThrough,#end#end #if($!item.backing.diskMode)"DISK_MODE": "$item.backing.diskMode",#end #if($item.vFlashCacheConfigInfo) #if($item.vFlashCacheConfigInfo.blockSizeInKB)"VFLASH_CACHE_BLOCK_SIZE_KB": $item.vFlashCacheConfigInfo.blockSizeInKB,#end #if($item.vFlashCacheConfigInfo.cacheConsistencyType)"VFLASH_CACHE_CONSISTENCY_TYPE": "$item.vFlashCacheConfigInfo.cacheConsistencyType",#end #if($item.vFlashCacheConfigInfo.cacheMode)"VFLASH_CACHE_MODE": "$item.vFlashCacheConfigInfo.cacheMode",#end #if($item.vFlashCacheConfigInfo.reservationInMB)"VFLASH_CACHE_RESERVATION_MB": $item.vFlashCacheConfigInfo.reservationInMB,#end#end #if($!item.backing.keyId) "is_crypto_key_configured": true, "crypto_key_provider_anonymized": "$GLOBAL-DigestUtils.sha256Hex($item.backing.keyId.providerId.id)", #else "is_crypto_key_configured": false, #end "CAPACITY_BYTES": $item.capacityInBytes }#if($foreach.hasNext),#end#end] VM__FK $config-instanceUuid.toUpperCase().replace("-", "") vsst:HOST_GRAPHICS HostSystem ESX_GRAPHICS__ARRAY $hardware-systemInfo-uuid.toUpperCase().replace("-", "")|ESX_GRAPHICS ESX_GRAPHICS__ARRAY #set($esx_id=$hardware-systemInfo-uuid.toUpperCase().replace("-", "")) [#foreach($item in $config-graphicsInfo) { "ID": "$esx_id|HOST_GRAPHICS|$foreach.count", "DEVICE_NAME": "$item.deviceName", "GRAPHICS_TYPE": "$item.graphicsType", "MEMORY_SIZE_KB": $item.memorySizeInKB, "VENDOR_NAME": "$item.vendorName" }#if($foreach.hasNext),#end#end] ESX__FK $hardware-systemInfo-uuid.toUpperCase().replace("-", "") vir:DISTRIBUTED_PORT_GROUP DistributedVirtualPortgroup DISTRIBUTED_PORT_GROUP $moref-serverGuid.toUpperCase()|$moref-value MO_ID$moref-value NAME_ANONYMIZED $GLOBAL-DigestUtils.sha256Hex($name) IN_SHAPING_POLICY_ENABLED $config-defaultPortConfig-inShapingPolicy.enabled.value IN_SHAPING_POLICY_AVERAGE_BANDWIDTH_BPS $config-defaultPortConfig-inShapingPolicy.averageBandwidth.value IN_SHAPING_POLICY_PEAK_BANDWIDTH_BPS $config-defaultPortConfig-inShapingPolicy.peakBandwidth.value IN_SHAPING_POLICY_BURST_SIZE_BYTES $config-defaultPortConfig-inShapingPolicy.burstSize.value OUT_SHAPING_POLICY_ENABLED $config-defaultPortConfig-outShapingPolicy.enabled.value OUT_SHAPING_POLICY_AVERAGE_BANDWIDTH_BPS $config-defaultPortConfig-outShapingPolicy.averageBandwidth.value OUT_SHAPING_POLICY_PEAK_BANDWIDTH_BPS $config-defaultPortConfig-outShapingPolicy.peakBandwidth.value OUT_SHAPING_POLICY_BURST_SIZE_BYTES $config-defaultPortConfig-outShapingPolicy.burstSize.value VLAN_ID ## #if($!config-defaultPortConfig-vlan.class.name.contains("VlanIdSpec"))## #set($vlan_id=$!config-defaultPortConfig-vlan.vlanId)## $vlan_id## #elseif($!config-defaultPortConfig-vlan.class.name.contains("PvlanSpec"))## #set($pvlan_id=$!config-defaultPortConfig-vlan.pvlanId)## $pvlan_id## #elseif($!config-defaultPortConfig-vlan.class.name.contains("TrunkVlanSpec"))## #foreach($range in $!config-defaultPortConfig-vlan.vlanId)$range.start#[[-]]#$range.end#if($foreach.hasNext),#end#end## #end## VLAN_TYPE $!config-defaultPortConfig-vlan.class.name.replace("com.vmware.vim.binding.vim.dvs.VmwareDistributedVirtualSwitch$", "").replace("Spec", "") VC__FK $moref-serverGuid.toUpperCase() vir:DISTRIBUTED_SWITCH_TO_ESX VmwareDistributedVirtualSwitch DISTRIBUTED_SWITCH_TO_ESX__ARRAY $moref-serverGuid.toUpperCase()|$uuid.toString().replace(" ", "")|DISTRIBUTED_SWITCH_TO_ESX DISTRIBUTED_SWITCH_TO_ESX__ARRAY [#foreach($item in $summary-host) { "ID": "$moref-serverGuid.toUpperCase()|$uuid.toString().replace(" ", "")|$item.value", "ESX_MO_ID": "$item.value" }#if($foreach.hasNext),#end#end] DISTRIBUTED_SWITCH__FK$uuid.toString().replace(" ", "") VC__FK$moref-serverGuid.toUpperCase() vir:DISTRIBUTED_SWITCH_TO_DISTRIBUTED_PORT_GROUP VmwareDistributedVirtualSwitch DISTRIBUTED_SWITCH_TO_DISTRIBUTED_PORT_GROUP__ARRAY $moref-serverGuid.toUpperCase()|$uuid.toString().replace(" ", "")|DISTRIBUTED_SWITCH_TO_DISTRIBUTED_PORT_GROUP DISTRIBUTED_SWITCH_TO_DISTRIBUTED_PORT_GROUP__ARRAY [#foreach($item in $portgroup) { "ID": "$moref-serverGuid.toUpperCase()|$uuid.toString().replace(" ", "")|$item.value", "DISTRIBUTED_PORT_GROUP_MO_ID": "$item.value" }#if($foreach.hasNext),#end#end] DISTRIBUTED_SWITCH__FK$uuid.toString().replace(" ", "") VC__FK$moref-serverGuid.toUpperCase() vir:DISTRIBUTED_PORT_GROUP_TO_VM DistributedVirtualPortgroup DISTRIBUTED_PORT_GROUP_TO_VM__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|DISTRIBUTED_PORT_GROUP_TO_VM DISTRIBUTED_PORT_GROUP_TO_VM__ARRAY [#foreach($item in $vm) { "ID": "$moref-serverGuid.toUpperCase()|$moref-value|$item.value", "VM_MO_ID": "$item.value" }#if($foreach.hasNext),#end#end] DISTRIBUTED_PORT_GROUP__FK$moref-serverGuid.toUpperCase()|$moref-value VC__FK$moref-serverGuid.toUpperCase() vir:Network Network vc_network $moref-serverGuid.toUpperCase()|$GLOBAL-DigestUtils.sha256Hex($name) network_name $GLOBAL-DigestUtils.sha256Hex($name) vm_count $vm-length permission_count $permission-length VC__FK $moref-serverGuid.toUpperCase() vir:VM_TO_DATASTORE VirtualMachine VM_TO_DATASTORE__ARRAY #if($config-template=="false")$moref-serverGuid.toUpperCase()|$config-instanceUuid.toUpperCase().replace("-", "")|VM_TO_DATASTORE#else$!GLOBAL-EMPTY#end VM_TO_DATASTORE__ARRAY [#foreach($item in $config-datastoreUrl) { "ID": "$moref-serverGuid.toUpperCase()|$config-instanceUuid.toUpperCase().replace("-", "")|$GLOBAL-DigestUtils.sha256Hex($item.name)", "ANONYMIZED_DATASTORE_NAME": "$GLOBAL-DigestUtils.sha256Hex($item.name)" }#if($foreach.hasNext),#end#end] VM__FK$config-instanceUuid.toUpperCase().replace("-", "") VC__FK$moref-serverGuid.toUpperCase() vir:HostProfile HostProfile HOST_PROFILE $moref-serverGuid.toUpperCase()|$moref-value name $GLOBAL-DigestUtils.sha256Hex($name) compliance_status complianceStatus VC__FK $moref-serverGuid.toUpperCase() HostProfile HOST_PROFILE_TO_ESX__ARRAY $moref-serverGuid.toUpperCase()|$moref-value|associated_hosts HOST_PROFILE_TO_ESX__ARRAY [#foreach($esx in $entity) { "ID": "$moref-serverGuid.toUpperCase()|$moref-value|$esx.value", "ESX_MO_ID": "$esx.value" }#if($foreach.hasNext),#end#end] VC__FK $moref-serverGuid.toUpperCase() HOST_PROFILE__FK $moref-serverGuid.toUpperCase()|$moref-value vir:Folders Folder VC_FOLDER $moref-serverGuid.toUpperCase()|$moref-value permission_count $permission-length VC__FK $moref-serverGuid.toUpperCase() vir:license LicenseUtilization license $license-info.getSerialKeys()[0] capacity $license-info-restrictions[0].getCostUnitsLimit()[0].getValue() edition $license-info-restrictions[0].getProduct().getName() edition_key $license-info-restrictions[0].getProduct().getEditionKey() units_used $usage[0].getCostUnitsUsage()[0].getValue() cost_unit $license-info-restrictions[0].getCostUnitsLimit()[0].getUnit().getId() vir:asset Asset asset #set($license-key="")#set($assetVcId="")#foreach($property in $info-properties)#if($property.getKey().equals("vcId"))#set($assetVcId=$property.getValue())#elseif($property.getKey().equals("licenseKey"))#set($license-key=$property.getValue())#end#end#set($ID="${license-key}|${assetVcId}|${info-instanceId}")$ID entity_id info-instanceId has_scope #if($assetVcId)TRUE#{else}FALSE#end scope $assetVcId cost_unit $info-license-info-restrictions[0].getCostUnitsLimit()[0].getUnit().getId() units_used #set($cost-unit=$info-license-info-restrictions[0].getCostUnitsLimit()[0].getUnit().getId())#foreach($costUnitUsage in $info-costUnitUsage)#if($costUnitUsage.getUnit().getId().equals($cost-unit))$costUnitUsage.getValue()#break#end#end prod_name info-product-family-name prod_ver info-product-family-version file_ver info-version license__fk license-key pa__schema_version #set($schema-version="2")$schema-version Asset feature_usage__array #set($license-key="")#set($assetVcId="")#foreach($property in $info-properties)#if($property.getKey().equals("vcId"))#set($assetVcId=$property.getValue())#elseif($property.getKey().equals("licenseKey"))#set($license-key=$property.getValue())#end#end#set($ID="feature_usage|${license-key}|${assetVcId}|${info-instanceId}")$ID feature_usage__array [#foreach($feature in $info-featuresInUse)#set($ID_ASSET="${license-key}|${assetVcId}|${info-instanceId}"){"ID":"${ID_ASSET}|$feature.getId()","feature_name": "$feature.getId()","LICENSE__FK": "$license-key","ASSET__FK": "$ID_ASSET"}#if($foreach.hasNext),#end#end] vir:ContentLibrary urn:vapi:com.vmware.content.Library content_library $id## #macro( obfuscateUri $uri )## #if($uri)## $GLOBAL-DigestUtils.sha256Hex($uri.toString())## #else## $!GLOBAL-EMPTY## #end## #end anonymized_name $GLOBAL-DigestUtils.sha256Hex($name) type type version version last_sync_time_ts #set($timestamp=$lastSyncTime.getTime().getTime())$timestamp creation_time_ts #set($timestamp=$creationTime.getTime().getTime())$timestamp last_modified_time_ts #set($timestamp=$lastModifiedTime.getTime().getTime())$timestamp optimize_remote_publishing optimizationInfo-optimizeRemotePublishing is_published publishInfo-published publish_url #obfuscateUri($publishInfo-publishUrl) publish_authentication_method $publishInfo.getAuthenticationMethod() publish_persist_json_enabled publishInfo-persistJsonEnabled subscription_on_demand subscriptionInfo-onDemand subscription_url #obfuscateUri($subscriptionInfo-subscriptionUrl) subscription_authentication_method $subscriptionInfo.getAuthenticationMethod() datastore_id $storageBackings[0].getDatastoreId() storage_uri #obfuscateUri($storageBackings[0].getStorageUri()) VC__FK $global-vcId.toUpperCase() vir:ContentLibraryItem urn:vapi:com.vmware.content.library.Item content_library_item $id library_id libraryId source_id sourceId content_version contentVersion metadata_version metadataVersion version version anonymized_name $GLOBAL-DigestUtils.sha256Hex($name) cached cached size_in_bytes size type type creation_time_ts #set($timestamp=$creationTime.getTime().getTime())$timestamp last_modified_time_ts #set($timestamp=$lastModifiedTime.getTime().getTime())$timestamp last_sync_time_ts #set($timestamp=$lastSyncTime.getTime().getTime())$timestamp VC__FK ${global-vcId.toUpperCase()} vir:Extension Extension VC_EXTENSION $key|$global-vcId.toUpperCase() EXTKEY key LABEL description-summary VERSION version LAST_HEARTBEAT_TIME $GLOBAL-CalendarUtil.formatISO8601($lastHeartbeatTime) TYPE type VC__FK $global-vcId.toUpperCase() vir:Extention-Events Extension vc_extension_event_definition__array $key|$global-vcId.toUpperCase()|vc_extension_event_definition vc_extension_event_definition__array [#foreach($item in $eventList) { "ID": "$item.eventID|$key|$global-vcId.toUpperCase()", "EVENT_ID": "$item.eventID", "EXTENSION_KEY": "$key" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() vir:VpxSettings OptionManager vc_settings $global-vcId.toUpperCase()## #macro( getOptionValue $key $options )## #foreach( $option in $options )## #if($option.key==$key)$option.value#break## #end#end#end embedded_sso ## #set($vcFQDN_key = "VirtualCenter.FQDN")## #set($vcFQDN = "#getOptionValue($vcFQDN_key $setting)")## #set($stsUri_key = "config.vpxd.sso.sts.uri")## #set($stsUri = "#getOptionValue($stsUri_key $setting)")## $stsUri.contains($vcFQDN) anonymized_sts_uri ## #set($option_key = "config.vpxd.sso.sts.uri")## #set($option_value = "#getOptionValue($option_key $setting)")## $GLOBAL-DigestUtils.sha256Hex($option_value) db_type #getOptionValue( "config.vpxd.odbc.dbtype" $setting ) db_version #getOptionValue( "config.vpxd.odbc.dbversion" $setting ) event_max_age #getOptionValue( "event.maxAge" $setting ) event_max_age_enabled #getOptionValue( "event.maxAgeEnabled" $setting ) log_level #getOptionValue( "config.log.level" $setting ) stats_usage_level #getOptionValue( "vpxd.usageStats.level" $setting ) os_name $GLOBAL-System.getProperty("os.name") os_version $GLOBAL-System.getProperty("os.version") os_architecture $GLOBAL-System.getProperty("os.arch") vc_instance__fk $global-vcId.toUpperCase() collection__fk $global-collectionId OptionManager sddc_deployments SDDC|$global-vcId.toUpperCase()## #macro( getOptionValue $key $options )## #foreach( $option in $options )## #if($option.key==$key)$option.value#break## #end#end#end sddc_type #getOptionValue( "config.SDDC.Deployed.Type" $setting ) sddc_flavor #getOptionValue( "config.SDDC.Deployed.Flavor" $setting ) sddc_version #getOptionValue( "config.SDDC.Deployed.Version" $setting ) sddc_deployment_method #getOptionValue( "config.SDDC.Deployed.Method" $setting ) sddc_workload_domain #getOptionValue( "config.SDDC.Deployed.WorkloadDomain" $setting ) sddc_instance_id #getOptionValue( "config.SDDC.Deployed.InstanceId" $setting ) sddc_cpi #getOptionValue( "config.SDDC.cpi" $setting ) VC__FK $global-vcId.toUpperCase() vir:AuthorizationManager AuthorizationManager vc_permissions_count $global-vcId.toUpperCase() permissions_count $m_retrieveAllPermissions.size() vc_instance__fk $global-vcId.toUpperCase() collection__fk $global-collectionId AuthorizationManager vc_role__array $global-vcId.toUpperCase()|user_count vc_role__array #set($tmap={}) #foreach($r in $roleList)#if($tmap.put($r.roleId,0))#end#end #foreach($p in $m_retrieveAllPermissions)#set($v=$tmap.get($p.roleId))#set($v = $v + 1)#if($tmap.put($p.roleId,$v))#end#end [#foreach($e in $tmap.keySet()) {"id" : "$global-vcId.toUpperCase()|$e", "user_count": $tmap.get($e) }#if($foreach.hasNext),#end#end] vir:DeploymentInfo DeploymentInfo vsphere_domain ## #set($ids=[])#set($sites=[])## #foreach($node in $pscNodes)## #set($parts=$node.serviceId.split(":"))## #set($id=$parts.get(1))## #set($void = $ids.add($id))## #set($site=$parts.get(0))## #if(!$sites.contains($site))#set($void = $sites.add($site))#end## #end## $GLOBAL-Collections.sort($ids)## #set($concat_id="")## #foreach($i in $ids)#set($concat_id = $concat_id + $i)#end## ## domain_id = sha(concat(ids of all psc pscNodes))## #set( $vsphere_domain_id = $GLOBAL-DigestUtils.sha256Hex($concat_id) )## $vsphere_domain_id## vsphere_site_count $sites.size() psc_node_count $pscNodes.size() DeploymentInfo vsphere_site__array ${global-vcId.toUpperCase()}|vsphere_site__array vsphere_site__array ## ## create map with structure (site_name, list_of_psc_nodes) #set($site_name_to_psc={})## #foreach($psc in $pscNodes)## #set($site_name=$psc.serviceId.split(":").get(0))## #if(!$site_name_to_psc.containsKey($site_name))## #set($void = $site_name_to_psc.put($site_name,[]))## #end## if containsKey #set($list_of_psc_in_site=$site_name_to_psc.get($site_name))## #set($void = $list_of_psc_in_site.add($psc)) #end##foreach on psc_nods ## create site_name_to_site_id map## #set($site_name_to_site_id_map={})## #foreach($site_name in $site_name_to_psc.keySet())## #set($psc_list=$site_name_to_psc.get($site_name))## ## ## create list with the identifiers of all PSC nodes within the site #set($psc_ids=[])## #foreach($psc in $psc_list)## #set($void = $psc_ids.add($psc.serviceId.split(":").get(1)))## #end## ## ## sort the list## $GLOBAL-Collections.sort($psc_ids)## ## #set($concat_id="")## #foreach($id in $psc_ids)#set($concat_id = $concat_id + $id)#end## ## ## site_id=sha(concat($psc_ids))## #set( $site_id = $GLOBAL-DigestUtils.sha256Hex($concat_id) )## ## ## #set($void = $site_name_to_site_id_map.put($site_name, $site_id)) #end## foreach on site_name_to_psc.keySet ## ## create the result array ## [#foreach($site_name in $site_name_to_psc.keySet())## #set($psc_list=$site_name_to_psc.get($site_name))## #set($site_id = $site_name_to_site_id_map.get($site_name))## {"id": "$site_id",## "psc_node_count": $psc_list.size()}## #if($foreach.hasNext),#end## #end]## vsphere_domain__fk ## #set($ids=[])## #foreach($node in $pscNodes)## #set($parts=$node.serviceId.split(":"))## #set($id=$parts.get(1))## #set($void = $ids.add($id))## #end## $GLOBAL-Collections.sort($ids)## #set($concat_id="")## #foreach($i in $ids)#set($concat_id = $concat_id + $i)#end## #set( $vsphere_domain_id = $GLOBAL-DigestUtils.sha256Hex($concat_id) )## $vsphere_domain_id## DeploymentInfo psc_node__array ${global-vcId.toUpperCase()}|psc_node__array psc_node__array ## create map with structure (site_name, list_of_psc_nodes) #set($site_name_to_psc={})## #foreach($psc in $pscNodes)## #set($site_name=$psc.serviceId.split(":").get(0))## #if(!$site_name_to_psc.containsKey($site_name))## #set($void = $site_name_to_psc.put($site_name,[]))## #end## if containsKey #set($list_of_psc_in_site=$site_name_to_psc.get($site_name))## #set($void = $list_of_psc_in_site.add($psc)) #end##foreach on psc_nods ## create site_name_to_site_id map## #set($site_name_to_site_id_map={})## #foreach($site_name in $site_name_to_psc.keySet())## #set($psc_list=$site_name_to_psc.get($site_name))## ## ## create list with the identifiers of all PSC nodes within the site #set($psc_ids=[])## #foreach($psc in $psc_list)## #set($void = $psc_ids.add($psc.serviceId.split(":").get(1)))## #end## ## ## sort the list## $GLOBAL-Collections.sort($psc_ids)## ## #set($concat_id="")## #foreach($id in $psc_ids)#set($concat_id = $concat_id + $id)#end## ## ## site_id=sha(concat($psc_ids))## #set( $site_id = $GLOBAL-DigestUtils.sha256Hex($concat_id) )## ## ## #set($void = $site_name_to_site_id_map.put($site_name, $site_id)) #end## foreach on site_name_to_psc.keySet ## ## [#foreach($node in $pscNodes)## #set($site_name=$node.serviceId.split(":").get(0))## #set($psc_id=$node.serviceId.split(":").get(1))## #set($site_id=$site_name_to_site_id_map.get($site_name)) #set($version=$node.version) {"id": "$psc_id",## "version": "$version",## "vsphere_site__fk": "$site_id"## }## #if($foreach.hasNext),#end## #end]## vsphere_domain__fk ## #set($ids=[])## #foreach($node in $pscNodes)## #set($parts=$node.serviceId.split(":"))## #set($id=$parts.get(1))## #set($void = $ids.add($id))## #end## $GLOBAL-Collections.sort($ids)## #set($concat_id="")## #foreach($i in $ids)#set($concat_id = $concat_id + $i)#end## #set( $vsphere_domain_id = $GLOBAL-DigestUtils.sha256Hex($concat_id) )## $vsphere_domain_id## DeploymentInfo psc_node_to_vc_relation_type__array ${global-vcId.toUpperCase()}|psc_node_to_vc_relation_type__array psc_node_to_vc_relation_type__array ## [#foreach($node in $pscNodes)## #set($is_embedded = "false") #if($hostName.toLowerCase().contains($node.hostId.toLowerCase()))#set($is_embedded = "true")#end #set($psc_id=$node.serviceId.split(":").get(1))## #set($version=$node.version) {"id": "$global-vcId|$psc_id",## "is_embedded_in_related_vc": "$is_embedded",## "psc_node__fk": "$psc_id"## }## #if($foreach.hasNext),#end## #end]## VC__FK ${global-vcId.toUpperCase()} DeploymentInfo vc_to_domain $global-vcId.toUpperCase() vsphere_domain__fk ## #set($ids=[])## #foreach($node in $pscNodes)## #set($parts=$node.serviceId.split(":"))## #set($id=$parts.get(1))## #set($void = $ids.add($id))## #end## $GLOBAL-Collections.sort($ids)## #set($concat_id="")## #foreach($i in $ids)#set($concat_id = $concat_id + $i)#end## #set( $vsphere_domain_id = $GLOBAL-DigestUtils.sha256Hex($concat_id) )## $vsphere_domain_id## vc_instance__fk $global-vcId.toUpperCase() collection__fk $global-collectionId cmc:vc-user-logout-session-events UserLogoutSessionEvent vc_user_logout_session_events ${global-vcId.toUpperCase()}|${key} created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) user_agent userAgent login_time $GLOBAL-CalendarUtil.formatISO8601($loginTime) is_solution_user $userName.matches(".*[0-9a-f]{8}-[0-9a-f]{4}-[1-5][0-9a-f]{3}-[89ab][0-9a-f]{3}-[0-9a-f]{12}") call_count callCount anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_user_name_sha256 $GLOBAL-DigestUtils.sha256Hex($userName) VC__FK ${global-vcId.toUpperCase()} vc-vm-power-ons VmPoweredOnEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmPoweredOnEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-power-offs VmPoweredOffEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmPoweredOffEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-suspends VmSuspendedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmSuspendedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-deployments VmDeployedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmDeployedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-alarms-triggered AlarmActionTriggeredEvent vc_alarm_triggered_event ${global-vcId.toUpperCase()}|${key} triggered_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) entity_mo_id $entity-entity.getValue() source_entity_mo_id $source-entity.getValue() alarm_name $GLOBAL-DigestUtils.sha256Hex($alarm-name) VC__FK ${global-vcId.toUpperCase()} vc-general-host-warning-event GeneralHostWarningEvent general_host_warning_event ## #set($bootbankErrorMessage = "Error (1) saving state to /bootbank")## #if($message.contains($bootbankErrorMessage))## ${global-vcId.toUpperCase()}|${key}## #else## $!GLOBAL-EMPTY## #end## event_type GeneralHostWarningEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) esx_mo_id $host-host.getValue() message $bootbankErrorMessage VC__FK $global-vcId.toUpperCase() cl-create-library EventEx cl_create_library_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) VC__FK ${global-vcId.toUpperCase()} cl-create-library-fail EventEx cl_create_library_fail_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) VC__FK ${global-vcId.toUpperCase()} cl-create-library-item EventEx cl_create_library_item_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) library_id #getArgumentValue("libraryId", $arguments, false) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) anonymized_library_item_name #getArgumentValue("libraryItemName", $arguments, true) task_id #getArgumentValue("taskId", $arguments, false) VC__FK ${global-vcId.toUpperCase()} cl-create-library-item-fail EventEx cl_create_library_item_fail_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) library_id #getArgumentValue("libraryId", $arguments, false) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) anonymized_library_item_name #getArgumentValue("libraryItemName", $arguments, true) task_id #getArgumentValue("taskId", $arguments, false) VC__FK ${global-vcId.toUpperCase()} cl-sync-library EventEx cl_sync_library_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) library_id #getArgumentValue("libraryId", $arguments, false) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) task_id #getArgumentValue("taskId", $arguments, false) VC__FK ${global-vcId.toUpperCase()} cl-sync-library-fail EventEx cl_sync_library_fail_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) library_id #getArgumentValue("libraryId", $arguments, false) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) task_id #getArgumentValue("taskId", $arguments, false) VC__FK ${global-vcId.toUpperCase()} cl-sync-library-item EventEx cl_sync_library_item_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) library_id #getArgumentValue("libraryId", $arguments, false) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) anonymized_library_item_name #getArgumentValue("libraryItemName", $arguments, true) task_id #getArgumentValue("taskId", $arguments, false) VC__FK ${global-vcId.toUpperCase()} cl-sync-library-item-fail EventEx cl_sync_library_item_fail_events ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments $obfuscate)## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## #if($obfuscate)## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #else## $argument.getValue()## #end## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity created_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) library_id #getArgumentValue("libraryId", $arguments, false) anonymized_library_name #getArgumentValue("libraryName", $arguments, true) anonymized_library_item_name #getArgumentValue("libraryItemName", $arguments, true) task_id #getArgumentValue("taskId", $arguments, false) VC__FK ${global-vcId.toUpperCase()} cl-ovf-deploy-events EventEx cl_ovf_deploy_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_library_name #getAnonymizedArgumentValue("libraryName", $arguments) anonymized_library_item_name #getAnonymizedArgumentValue("libraryItemName", $arguments) event_type eventTypeId VC__FK ${global-vcId.toUpperCase()} cl-ovf-deploy-fail-events EventEx cl_ovf_deploy_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_library_name #getAnonymizedArgumentValue("libraryName", $arguments) anonymized_library_item_name #getAnonymizedArgumentValue("libraryItemName", $arguments) event_type eventTypeId VC__FK ${global-vcId.toUpperCase()} cl-ovf-export-events EventEx cl_ovf_export_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_entity_name #getAnonymizedArgumentValue("entityName", $arguments) anonymized_library_name #getAnonymizedArgumentValue("libraryName", $arguments) anonymized_library_item_name #getAnonymizedArgumentValue("libraryItemName", $arguments) event_type eventTypeId VC__FK ${global-vcId.toUpperCase()} cl-ovf-export-fail-events EventEx cl_ovf_export_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) severity severity event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_entity_name #getAnonymizedArgumentValue("entityName", $arguments) anonymized_library_name #getAnonymizedArgumentValue("libraryName", $arguments) anonymized_library_item_name #getAnonymizedArgumentValue("libraryItemName", $arguments) event_type eventTypeId VC__FK ${global-vcId.toUpperCase()} vc-vm-creations VmCreatedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmCreatedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-removals VmRemovedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmRemovedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-being-hot-migrated-events VmBeingHotMigratedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmBeingHotMigratedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() src_esx_mo_id $host-host.getValue() src_datacenter_mo_id $datacenter-datacenter.getValue() dest_esx_mo_id $destHost-host.getValue() dest_datacenter_mo_id $destDatacenter-datacenter.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-being-migrated-events VmBeingMigratedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmBeingMigratedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() src_esx_mo_id $host-host.getValue() src_datacenter_mo_id $datacenter-datacenter.getValue() dest_esx_mo_id $destHost-host.getValue() dest_datacenter_mo_id $destDatacenter-datacenter.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-migrated-events VmMigratedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type VmMigratedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() src_esx_mo_id $sourceHost-host.getValue() src_datacenter_mo_id $sourceDatacenter-datacenter.getValue() dest_esx_mo_id $host-host.getValue() dest_datacenter_mo_id $datacenter-datacenter.getValue() VC__FK $global-vcId.toUpperCase() vc-drs-vm-migrated-events DrsVmMigratedEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type DrsVmMigratedEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() src_esx_mo_id $sourceHost-host.getValue() src_datacenter_mo_id $sourceDatacenter-datacenter.getValue() dest_esx_mo_id $host-host.getValue() dest_datacenter_mo_id $datacenter-datacenter.getValue() VC__FK $global-vcId.toUpperCase() vc-drs-vm-power-ons DrsVmPoweredOnEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type DrsVmPoweredOnEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-drs-vm-rule-violations DrsRuleViolationEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type DrsRuleViolationEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-drs-vm-rule-compliances DrsRuleComplianceEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type DrsRuleComplianceEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-drs-vm-soft-rule-violations DrsSoftRuleViolationEvent vc_vm_event ${global-vcId.toUpperCase()}|${key} event_type DrsSoftRuleViolationEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-reconfigured-events VmReconfiguredEvent vc_vm_reconfigured_event ${global-vcId.toUpperCase()}|${key} event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vpmc_enabled configSpec-vPMCEnabled vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() vc-vm-being-created-events VmBeingCreatedEvent vc_vm_being_created_event ${global-vcId.toUpperCase()}|${key} event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vpmc_enabled configSpec-vPMCEnabled vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() VC__FK $global-vcId.toUpperCase() task-timeout-events TaskTimeoutEvent task_timeout_event ${global-vcId.toUpperCase()}|${key} esx_mo_id $host-host.getValue() task_name info-name VC__FK ${global-vcId.toUpperCase()} vc-vm-begin-instant-clone-events EventEx vc_vm_begin_instant_clone_event ${global-vcId.toUpperCase()}|${key} object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) VC__FK ${global-vcId.toUpperCase()} vc-vm-instant-cloned-events EventEx vc_vm_instant_cloned_event ${global-vcId.toUpperCase()}|${key} object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) VC__FK ${global-vcId.toUpperCase()} vc-vm-instant-clone-failed-events EventEx vc_vm_instant_clone_failed_event ${global-vcId.toUpperCase()}|${key} object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) VC__FK ${global-vcId.toUpperCase()} vc-crypto-operation-events EventEx vc_crypto_operation_event ${global-vcId.toUpperCase()}|${key} event_type eventTypeId event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() datacenter_mo_id $datacenter-datacenter.getValue() description ## #set($description="description")## #foreach($argument in $arguments)## #if($description.equals($argument.getKey()))## $argument.getValue()## #break## #end## #end## anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) VC__FK $global-vcId.toUpperCase() esx-entering-maintenance-mode EnteringMaintenanceModeEvent esx_event ${global-vcId.toUpperCase()}|${key} event_type EnteringMaintenanceModeEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) esx_mo_id $host-host.getValue() chain_id chainId VC__FK $global-vcId.toUpperCase() esx-entered-maintenance-mode EnteredMaintenanceModeEvent esx_event ${global-vcId.toUpperCase()}|${key} event_type EnteredMaintenanceModeEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) esx_mo_id $host-host.getValue() chain_id chainId VC__FK $global-vcId.toUpperCase() esx-exit-maintenance-mode ExitMaintenanceModeEvent esx_event ${global-vcId.toUpperCase()}|${key} event_type ExitMaintenanceModeEvent$!GLOBAL-EMPTY event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) esx_mo_id $host-host.getValue() chain_id chainId VC__FK $global-vcId.toUpperCase() spbm:spbm_vasaProvider VasaProviderInfo vasaprovider $global-vcId.toUpperCase()|$uid.toUpperCase() provider_id providerId uid uid default_namespace namespace provider_version version use_vmca #if($retainVasaProviderCertificate=="true")false#{else}true#end is_vaio_provider #if($type=="DATASERVICE")true#{else}false#end array_independent_provider arrayIndependentProvider vp_type type VC__FK $global-vcId.toUpperCase() VasaProviderInfo vasaProvider_StorageArray__ARRAY $global-vcId.toUpperCase()|$uid|StorageArray vasaProvider_StorageArray__ARRAY [#foreach($item in $relatedStorageArray) { "id": "$global-vcId.toUpperCase()|$uid|$item.arrayId", "array_id": "$item.arrayId", "is_active": "$item.active", "is_manageable": "$item.manageable", "priority": "$item.priority", "provider_id": "$!providerId" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() vasaprovider__FK $global-vcId.toUpperCase()|$uid.toUpperCase() spbm:spbm_vasaprovider_faultdomain_info CustomFaultDomainInfo vasaprovider_faultdomain_info $global-vcId.toUpperCase()|$id.toUpperCase() faultdomain_id id provider_uid providerUid storageArrayId storageArrayId num_children ${children.size()} VC__FK $global-vcId.toUpperCase() VASAPROVIDER__FK $global-vcId.toUpperCase()|$providerUid.toUpperCase() spbm:spbm_vasaprovider_storage_container_info StorageContainer vasaprovider_storage_container_info__ARRAY $global-vcId.toUpperCase()|$uuid.toUpperCase()|vasaprovider_storage_container_info vasaprovider_storage_container_info__ARRAY [#foreach($item in $providerId) { "id": "$global-vcId.toUpperCase()|$uuid.toUpperCase()|$item", "provider_uid": "$item", "container_id": "$uuid", "max_vvol_size_in_mb": "$maxVvolSizeInMB", "vasaprovider__FK": "$global-vcId.toUpperCase()|$item.toUpperCase()" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() spbm:spbm_capability_schema CapabilityObjectSchema spbm_capability_schema $global-vcId.toUpperCase()|$namespaceInfo-namespace.toUpperCase() line_of_service lineOfService-lineOfService namespace namespaceInfo-namespace vendorUUID vendorInfo-vendorUuid version namespaceInfo-version VC__FK $global-vcId.toUpperCase() CapabilityObjectSchema spbm_capability__ARRAY $global-vcId.toUpperCase()|$namespaceInfo-namespace.toUpperCase()|spbm_capability spbm_capability__ARRAY [#foreach($item in $capabilityMetadataPerCategory) #foreach($item1 in ${item.capabilityMetadata}) { "id":"$global-vcId.toUpperCase()|$item1.id.id|$item1.id.namespace", "capability_id": "$item1.id.id", "mandatory": "#if($item1.mandatory)"$item1.mandatory"#{else}false#end", "num_properties": "$item1.propertyMetadata.size()", "namespace":"$item1.id.namespace", "is_dsp_capability":"#if($item1.id.namespace=="com.vmware.storageprofile.dataservice")true#{else}false#end", "category":"$item.subCategory" } #if($foreach.hasNext),#end #end##foreach on item1 #if($foreach.hasNext),#end#end] spbm_capability_schema__FK $global-vcId.toUpperCase()|$namespaceInfo-namespace.toUpperCase() VC__FK $global-vcId.toUpperCase() spbm:spbm_capabilityBasedProfile CapabilityBasedProfile spbm_storage_policy #if($profileCategory!="DATA_SERVICE_POLICY")$global-vcId.toUpperCase()|$profileId-uniqueId.toUpperCase()#else$!GLOBAL-EMPTY#end num_rulesets #if($constraints.class.name.contains("SubProfileCapabilityConstraints"))${constraints.subProfiles.size()}#{else}0#end policy_id profileId-uniqueId VC__FK $global-vcId.toUpperCase() CapabilityBasedProfile spbm_policy_component #if($profileCategory=="DATA_SERVICE_POLICY")$global-vcId.toUpperCase()|$profileId-uniqueId.toUpperCase()#else$!GLOBAL-EMPTY#end policy_id profileId-uniqueId namespace #if($constraints.class.name.contains("SubProfileCapabilityConstraints"))${constraints.subProfiles.get(0).capability.get(0).id.namespace}#else$!GLOBAL-EMPTY#end VC__FK $global-vcId.toUpperCase() CapabilityBasedProfile spbm_ruleset__ARRAY $global-vcId.toUpperCase()|$profileId-uniqueId|spbm_ruleset spbm_ruleset__ARRAY [#foreach($subProfile in ${constraints.subProfiles}) { "name": "$subProfile.name", "id": "$global-vcId.toUpperCase()|$profileId-uniqueId|$subProfile.name", "num_capabilities": "$subProfile.capability.size()", "policy_id": "$profileId-uniqueId" }#if($foreach.hasNext),#end#end] spbm_storage_policy__FK $global-vcId.toUpperCase()|$profileId-uniqueId VC__FK $global-vcId.toUpperCase() CapabilityBasedProfile spbm_ruleset_to_spbm_capability__ARRAY $global-vcId.toUpperCase()|$profileId-uniqueId.toUpperCase()|spbm_ruleset_to_spbm_capability spbm_ruleset_to_spbm_capability__ARRAY [#foreach($subProfile in ${constraints.subProfiles}) #foreach($capability in ${subProfile.capability}) { "id": "$global-vcId.toUpperCase()|$profileId-uniqueId|$subProfile.name|$capability.id.id|$capability.id.namespace", "ruleset_name": "$subProfile.name", "capability_id": "$capability.id.id", "namespace": "$capability.id.namespace", "policy": "$profileId-uniqueId", "spbm_ruleset__FK": "$global-vcId.toUpperCase()|$profileId-uniqueId|$subProfile.name", "spbm_capability__FK": "$global-vcId.toUpperCase()|$capability.id.id|$capability.id.namespace" } #if($foreach.hasNext),#end #end##foreach on capability #if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() CapabilityBasedProfile spbm_capability_to_spbm_constraint_property_instance__ARRAY $global-vcId.toUpperCase()|$profileId-uniqueId.toUpperCase()|spbm_capability_to_spbm_constraint_property_instance spbm_capability_to_spbm_constraint_property_instance__ARRAY [#foreach($subProfile in ${constraints.subProfiles}) #foreach($capability in ${subProfile.capability}) #foreach($constraint in ${capability.constraint}) #set($constraint_id = "$capability.id.id|$foreach.count")## #foreach($propertyInstance in ${constraint.propertyInstance}) { "id": "$global-vcId.toUpperCase()|$profileId-uniqueId|$subProfile.name|$capability.id.id|$capability.id.namespace|$propertyInstance.id", "capability_id": "$capability.id.id", "namespace": "$capability.id.namespace", "policy": "$profileId-uniqueId", "constraint_id": "$constraint_id", "property_instance_id": "$propertyInstance.id", "property_instance_operator": "$!propertyInstance.operator", "property_instance_value": "$propertyInstance.value", "spbm_ruleset__FK": "$global-vcId.toUpperCase()|$profileId-uniqueId|$subProfile.name", "spbm_capability__FK": "$global-vcId.toUpperCase()|$capability.id.id|$capability.id.namespace" } #if($foreach.hasNext),#end #end##foreach on propertyInstance #if($foreach.hasNext),#end #end##foreach on constraint #if($foreach.hasNext),#end #end##foreach on capability #if($foreach.hasNext),#end #end##foreach on subProfile ] VC__FK $global-vcId.toUpperCase() CapabilityBasedProfile spbm_ruleset_to_spbm_policy_component__ARRAY $global-vcId.toUpperCase()|$profileId-uniqueId.toUpperCase()|spbm_ruleset_to_spbm_policy_component spbm_ruleset_to_spbm_policy_component__ARRAY #set($objectsToSend={}) #foreach($subProfile in ${constraints.subProfiles}) #set($capabilities=[]) #foreach($capability in ${subProfile.capability}) #if($capability.id.namespace=="com.vmware.storageprofile.dataservice") #set($void=$capabilities.add($capability)) #end#end #if($capabilities.size()>0)#set($void=$objectsToSend.put($subProfile,$capabilities))#end#end [#foreach($subprofile in $objectsToSend.keySet()) #foreach($capability in $objectsToSend.get($subprofile)) { "id":"$global-vcId.toUpperCase()|$profileId-uniqueId|$subprofile.name|$capability.id.id", "storage_policy_id": "$profileId-uniqueId", "ruleset_name": "$subprofile.name", "policy_component_id": "$capability.id.id", "spbm_ruleset__FK" : "$global-vcId.toUpperCase()|$profileId-uniqueId|$subprofile.name", "spbm_policy_component__FK" : "$global-vcId.toUpperCase()|$capability.id.id" } #if($foreach.hasNext),#end #end##foreach on capabilities #if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() spbm:spbm_datastore_policy_association DefaultProfileInfo datastore_policy_association__ARRAY $global-vcId.toUpperCase()|$defaultProfile-profileId-uniqueId.toUpperCase()|datastore_policy_association datastore_policy_association__ARRAY [#foreach($item in $datastores) { "id": "$global-vcId.toUpperCase()|$defaultProfile-profileId-uniqueId.toUpperCase()|$item.hubId", "datastore_mo_id": "$item.hubId", "policy_id": "#if($defaultProfile-profileId-uniqueId)$defaultProfile-profileId-uniqueId#{else}""#end" }#if($foreach.hasNext),#end#end] spbm_storage_policy__FK $global-vcId.toUpperCase()|$defaultProfile-profileId-uniqueId.toUpperCase() VC__FK $global-vcId.toUpperCase() spbm:spbm_vm RollupComplianceResult spbm_vm__ARRAY #if($result)$global-vcId.toUpperCase()|$entity-key|spbm_vm#else$!GLOBAL-EMPTY#end spbm_vm__ARRAY #set($complianceResult=[]) #foreach($item in $result) #if($item.entity.objectType=="virtualMachine") #set($void=$complianceResult.add($item)) #end#end [#foreach($res in $complianceResult) { "id": "$global-vcId.toUpperCase()|$res.entity.key", "vm_mo_id" : "$res.entity.key", "storage_policy_id": "$res.profile.uniqueId", "spbm_policy_compliance": "$res.complianceStatus", "spbm_storage_policy__FK": "$global-vcId.toUpperCase()|$res.profile.uniqueId.toUpperCase()" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() RollupComplianceResult spbm_virtual_disk__ARRAY #if($result)$global-vcId.toUpperCase()|$entity-key|spbm_virtual_disk#else$!GLOBAL-EMPTY#end spbm_virtual_disk__ARRAY #set($complianceResult=[]) #foreach($item in $result) #if($item.entity.objectType=="virtualDiskId") #set($void=$complianceResult.add($item)) #end#end [#foreach($res in $complianceResult) { #set($entityId=$res.entity.key.split(":")) "id": "$global-vcId.toUpperCase()|$entityId[0]|$entityId[1]", "vm_mo_id" : "$entityId[0]", "disk_key" : "$entityId[1]", "storage_policy_id": "$res.profile.uniqueId", "spbm_policy_compliance": "$res.complianceStatus", "spbm_storage_policy__FK": "$global-vcId.toUpperCase()|$res.profile.uniqueId.toUpperCase()", "spbm_vm__FK" : "$global-vcId.toUpperCase()|$entityId[0]" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() spbm:spbm_vm_rg_association QueryReplicationGroupResult spbm_vm_rg_association #if($object-objectType=="virtualMachine")$object-serverUuid.toUpperCase()|$object-key.toUpperCase()#else$!GLOBAL-EMPTY#end faultDomainId $replicationGroupId-faultDomainId-id deviceGroupId $replicationGroupId-deviceGroupId-id vm_mo_id $object-key VC__FK $object-serverUuid.toUpperCase() spbm_vm__FK $object-serverUuid.toUpperCase()|$object-key.toUpperCase() QueryReplicationGroupResult spbm_virtual_disk_rg_association #if($object-objectType=="virtualDiskId")#set($vmMorId=$object-key.split(":"))$object-serverUuid.toUpperCase()|$vmMorId[0]|$object-key.toUpperCase()#else$!GLOBAL-EMPTY#end faultDomainId $replicationGroupId-faultDomainId-id deviceGroupId $replicationGroupId-deviceGroupId-id vm_mo_id $vmMorId[0] disk_key $vmMorId[1] spbm_virtual_disk__FK $object-serverUuid.toUpperCase()|$vmMorId[0]|$vmMorId[1] VC__FK $object-serverUuid.toUpperCase() fcd:vStorageObject VStorageObject fcd $global-vcId.toUpperCase()|$config-id-id.toUpperCase() fcd_id config-id-id capacity_mb $config-capacityInMB datastore_mo_id $config-backing-datastore.value num_consumers ${config.consumerId.size()} provisioning_type ${config.backing.provisioningType} virtual_disk_format ${config.backing.virtualDiskFormat} backing_info_type #if($config.backing.class.name.contains("DiskFileBackingInfo"))DiskFileBackingInfo#elseif($item.backing.class.name.contains("RawDiskMappingBackingInfo"))RawDiskMappingBackingInfo#elseif($item.backing.class.name.contains("FileBackingInfo"))FileBackingInfo#end compatibility_mode ${config.backing.compatibilityMode} parent_id ${config.backing.parent.id.id} VC__FK $global-vcId.toUpperCase() fcd:vStorageObjectSnapshotInfo CustomVStorageObjectSnapshotInfo fcd_snapshot__ARRAY #if($snapshots)$global-vcId.toUpperCase()|fcd_snapshot#end fcd_snapshot__ARRAY [#foreach($item in $snapshots) { "id": "$global-vcId.toUpperCase()|$!item.id.id.toUpperCase()", "fcd_id": "$fcdId.id", "snap_id": "$!item.id.id" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() fcd__FK $global-vcId.toUpperCase()|$fcdId.id.toUpperCase() spbm:spbm_fcd ComplianceResult spbm_fcd #if($complianceStatus)$global-vcId.toUpperCase()|$entity-key.toUpperCase()#else$GLOBAL-EMPTY#end storage_policy_id $!profile-uniqueId compliance complianceStatus fcd_id entity-key VC__FK $global-vcId.toUpperCase() all-error-events EventEx vc_error_event ${global-vcId.toUpperCase()}|${key} event_type_id eventTypeId event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) vm_mo_id $vm-vm.getValue() esx_mo_id $host-host.getValue() datacenter_mo_id $datacenter-datacenter.getValue() datastore_mo_id $ds-datastore.getValue() dvs_mo_id $dvs-dvs.getValue() net_mo_id $net-network.getValue() anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) VC__FK ${global-vcId.toUpperCase()} vc-ha-post-green-health-update-events EventEx vc_ha_post_green_health_update_event ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $argument.getValue()## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_provider_name $GLOBAL-DigestUtils.sha256Hex("#getArgumentValue('providerName', $arguments)") component_type #getArgumentValue("componentType", $arguments) anonymized_entity_name $GLOBAL-DigestUtils.sha256Hex("#getArgumentValue('entityName', $arguments)") VC__FK ${global-vcId.toUpperCase()} vc-ha-post-yellow-health-update-events EventEx vc_ha_post_yellow_health_update_event ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $argument.getValue()## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_provider_name $GLOBAL-DigestUtils.sha256Hex("#getArgumentValue('providerName', $arguments)") component_type #getArgumentValue("componentType", $arguments) anonymized_entity_name $GLOBAL-DigestUtils.sha256Hex("#getArgumentValue('entityName', $arguments)") VC__FK ${global-vcId.toUpperCase()} vc-ha-post-red-health-update-events EventEx vc_ha_post_red_health_update_event ${global-vcId.toUpperCase()}|${key}## #macro( getArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $argument.getValue()## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_provider_name $GLOBAL-DigestUtils.sha256Hex("#getArgumentValue('providerName', $arguments)") component_type #getArgumentValue("componentType", $arguments) anonymized_entity_name $GLOBAL-DigestUtils.sha256Hex("#getArgumentValue('entityName', $arguments)") VC__FK ${global-vcId.toUpperCase()} vc-ha-green-health-events EventEx vc_ha_green_health_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_entity_name #getAnonymizedArgumentValue("entityName", $arguments) VC__FK ${global-vcId.toUpperCase()} vc-ha-yellow-health-events EventEx vc_ha_yellow_health_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_entity_name #getAnonymizedArgumentValue("entityName", $arguments) VC__FK ${global-vcId.toUpperCase()} vc-ha-red-health-events EventEx vc_ha_red_health_event ${global-vcId.toUpperCase()}|${key}## #macro( getAnonymizedArgumentValue $key $arguments )## #foreach($argument in $arguments)## #if($key.equals($argument.getKey()))## $GLOBAL-DigestUtils.sha256Hex($argument.getValue())## #break## #end#end#end## object_id objectId object_type objectType anonymized_object_name $GLOBAL-DigestUtils.sha256Hex($objectName) event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) anonymized_user_name $GLOBAL-DigestUtils.sha256Hex($userName) anonymized_entity_name #getAnonymizedArgumentValue("entityName", $arguments) VC__FK ${global-vcId.toUpperCase()} vm-disk-failed-to-consolidate-event EventEx vm_disk_failed_to_consolidate_event ${global-vcId.toUpperCase()}|${key} object_id objectId object_type objectType esx_mo_id $host-host.getValue() event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) VC__FK ${global-vcId.toUpperCase()} vm-disk-consolidation-needed-event EventEx vm_disk_consolidation_needed_event ${global-vcId.toUpperCase()}|${key} object_id objectId object_type objectType esx_mo_id $host-host.getValue() event_time $GLOBAL-CalendarUtil.formatISO8601($createdTime) VC__FK ${global-vcId.toUpperCase()} vc-custom-alarm-actions Alarm VC_CUSTOM_ALARM_ACTION__ARRAY #if(!$info-systemName)$global-vcId.toUpperCase()|$moref-value|ALARM_ACTION#else$!GLOBAL-EMPTY#end VC_CUSTOM_ALARM_ACTION__ARRAY [#foreach($action in $info-action.action) { #set($actionClassName=$action.action.class.name) "ID":"$global-vcId.toUpperCase()|$moref-value|ALARM_ACTION|$foreach.count", "ALARM_ACTION":#if($actionClassName.contains("MethodAction"))"$action.action.name"#else"$actionClassName"#end, "ALARM_ID":"$global-vcId.toUpperCase()|$moref-value" }#if($foreach.hasNext),#end#end] VC__FK $global-vcId.toUpperCase() PERF_HISTORICAL_INTERVALS PerformanceManager PERF_HISTORICAL_INTERVAL__ARRAY $moref-serverGuid.toUpperCase() PERF_HISTORICAL_INTERVAL__ARRAY ## [#foreach($interval in $historicalInterval) { "id": "$global-vcId.toUpperCase()|$interval.key", "enabled": "$interval.enabled", "length": "$interval.length", "level": "$interval.level", "samplingPeriod": "$interval.samplingPeriod" }#if($foreach.hasNext),#end#end] vc_instance__fk $global-vcId.toUpperCase() false