Hello community i hope you can help me, I'm new here...
The field "moid" for 'folder' has the same values like the field changeSet.parent.moid for 'VMs'.
I want a new column with changeSet.name from 'folder' in the 'VMs' search where changeSet.parent.moid of 'VMs' and moid of 'folder' should be used as "key" to store the folder name to the VMs.
I have tried many things ("inner join" ect.), but did not get a useful result.
Maybe you can help me with a command.
Thank you in advance!
Greetings Lars
a changeSet.name 100+ = foldername
a index 1 = vmware-inv
a moid 100+ = values
a sourcetype 1 = vmware:inv:hierarchy
a type 1 = folder
index="vmware-inv" sourcetype=vmware:inv:hierarchy
"changeSet.name"="* - *" AND "changeSet.name"!="*Failover*"
| fields changeSet.name, moid
| rename moid as folder_moid
| stats values(changeSet.name) as folder by folder_moid
| sort folder
a changeSet.config.version 7
a cluster_name 79
a hypervisor_name 100+
a hypervisor_os_version 3
a vCenter 17
a vm_name 100+
a vm_os 37
a changeSet.parent.moid
index="vmware-inv" sourcetype = vmware:inv:vm OR vmware:inv:hierarchy
| fields + _time, changeSet.summary.runtime.host.name,
changeSet.storage.perDatastoreUsage{}.committed, changeSet.config.name, vm_name, mem_capacity,
logical_cpu_count, vm_os, hypervisor_name, cluster_name, host, hypervisor_os_version,
changeSet.summary.runtime.powerState, changeSet.summary.vm.moid, changeSet.parent.moid
| rename changeSet.summary.runtime.powerState as PowerState,
changeSet.storage.perDatastoreUsage{}.committed as VM_DatastoreUsage, host as vCenter,
changeSet.summary.vm.moid as VM_moid
| mvexpand VM_DatastoreUsage
| eval VM_mem_capacityGB= round(mem_capacity/1024/1024/1024,2),
VM_DatastoreUsageGB=round(VM_DatastoreUsage/1024/1024/1024,2)
| stats latest(cluster_name) as Cluster, latest(hypervisor_name) as ESXiHost,
latest(hypervisor_os_version) as ESXiHost_os_version, latest(vm_name) as VM_Name,
latest(VM_DatastoreUsageGB) as VM_DatastoreUsageGB, latest(VM_mem_capacityGB) as VM_mem_capacityGB,
latest(logical_cpu_count) as vCPU, latest(PowerState) as PowerState,
latest(vm_os) as VM_OS, latest(_time) as _time by VM_moid, vCenter
| sort ...
| fields - ...