Getting Data In
Provide Splunk Cloud feedback in this confidential UX survey by June 17
for a chance to win a $200 Amazon gift card!

extract fields from Nested multivalue JSON

agoyal
Builder

Hello,

we have complex Json having mutli level with multivalue fields.
In below example

topologyMetrics has 4 subnode and also each subnode have 3 subnode itself(boltMetrics).

I am trying to get table with two fields "name.boldID" and "emitted" and it should display 12 lines for 1 event. when I am trying to mxexpand its showing only 4 lines as name field has 4 entries.

| spath "mtr.gauges.streaming_metrics.topologyMetrics{}.name"
| rename mtr.gauges.streaming_metrics.topologyMetrics{}.name as name
| spath "mtr.gauges.streaming_metrics.topologyMetrics{}.id"
| rename mtr.gauges.streaming_metrics.topologyMetrics{}.id as id
| spath "mtr.gauges.streaming_metrics.topologyMetrics{}.boltMetrics{}.boltID"
| rename mtr.gauges.streaming_metrics.topologyMetrics{}.boltMetrics{}.boltID as boltID
| spath "mtr.gauges.streaming_metrics.topologyMetrics{}.boltMetrics{}.emitted"
| rename mtr.gauges.streaming_metrics.topologyMetrics{}.boltMetrics{}.emitted as emitted
| table name id boltID emitted
| eval x=mvzip(boltID,name)
| mvexpand x

alt text

alt text

raw

{"v":"1.0","t":"MTR","ts":"2019-12-13T10:30:34.433+01:00","h":"mx20631vm.fr.murex.com","pid":659387,"src":{"c":"positions-management-v1","d":"positions","sd":""},"mtr":{"counters":{"process":{"cpu":{"time_cumulated_s":1458},"memory":{"gc":{"g1_old_generation":{"total_duration_ms":0},"g1_young_generation":{"total_duration_ms":6760}}}}},"gauges":{"caching_metrics":{"readsPerSecond":0.0,"writesPerSecond":0.0,"maxMemoryMB":12288,"totalHitCount":2620435,"totalMissCount":40668,"totalRegionCount":17,"totalRegionEntryCount":10932,"usedMemoryMB":3041,"clientCount":7,"locatorCount":2,"memberCount":5,"regions":[{"regionName":"CollateralBalance_INTERNAL-heartbeat","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralBalance_INTERNAL-positions-data","regionType":"PARTITION","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":4536,"entrySizeMB":1,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralBalance_INTERNAL-state","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralInterest_INTERNAL-heartbeat","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralInterest_INTERNAL-positions-data","regionType":"PARTITION","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2221,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralInterest_INTERNAL-state","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralTriparty_INTERNAL-heartbeat","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralTriparty_INTERNAL-positions-data","regionType":"PARTITION","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":594,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"CollateralTriparty_INTERNAL-state","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"Collateralbreakdown_INTERNAL-heartbeat","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"Collateralbreakdown_INTERNAL-positions-data","regionType":"PARTITION","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":3541,"entrySizeMB":1,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"Collateralbreakdown_INTERNAL-state","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":2,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"position-views","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":4,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"position-views-deployment-metrics","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":4,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"position-views-deployment-queue","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":0,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"topology-lowest-pending-id","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":8,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"regionName":"topology-spout-status","regionType":"REPLICATE","readsPerSecond":0.0,"writesPerSecond":0.0,"entryCount":8,"entrySizeMB":0,"getsPerSecond":0.0,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0}],"nodes":[{"readsPerSecond":0.0,"writesPerSecond":0.0,"maxMemoryMB":2048,"totalHitCount":0,"totalMissCount":0,"totalRegionCount":0,"totalRegionEntryCount":0,"usedMemoryMB":278,"nodeName":"positions-gf-locator-v1-2","bytesReceivedPerSecond":0.0,"bytesSentPerSecond":0.0,"cpuUsage":0.23333333,"getsPerSecond":0.0,"gcCount":41,"gcTimeMilliseconds":640,"locator":true,"server":false,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"readsPerSecond":0.0,"writesPerSecond":0.0,"maxMemoryMB":2048,"totalHitCount":0,"totalMissCount":0,"totalRegionCount":0,"totalRegionEntryCount":0,"usedMemoryMB":1155,"nodeName":"positions-gf-locator-v1-1","bytesReceivedPerSecond":0.0,"bytesSentPerSecond":0.0,"cpuUsage":0.43332613,"getsPerSecond":0.0,"gcCount":40,"gcTimeMilliseconds":961,"locator":true,"server":false,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"readsPerSecond":0.0,"writesPerSecond":0.0,"maxMemoryMB":2048,"totalHitCount":1104067,"totalMissCount":13854,"totalRegionCount":17,"totalRegionEntryCount":7402,"usedMemoryMB":117,"nodeName":"positions-gf-cacheserver-v1-3","bytesReceivedPerSecond":0.0,"bytesSentPerSecond":0.0,"cpuUsage":0.98333335,"getsPerSecond":0.0,"gcCount":76,"gcTimeMilliseconds":724,"locator":false,"server":true,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"readsPerSecond":0.0,"writesPerSecond":0.0,"maxMemoryMB":2048,"totalHitCount":534237,"totalMissCount":13588,"totalRegionCount":17,"totalRegionEntryCount":7327,"usedMemoryMB":1130,"nodeName":"positions-gf-cacheserver-v1-1","bytesReceivedPerSecond":0.0,"bytesSentPerSecond":0.0,"cpuUsage":0.88331866,"getsPerSecond":0.0,"gcCount":63,"gcTimeMilliseconds":855,"locator":false,"server":true,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0},{"readsPerSecond":0.0,"writesPerSecond":0.0,"maxMemoryMB":2048,"totalHitCount":982131,"totalMissCount":13226,"totalRegionCount":17,"totalRegionEntryCount":7223,"usedMemoryMB":285,"nodeName":"positions-gf-cacheserver-v1-2","bytesReceivedPerSecond":0.0,"bytesSentPerSecond":0.0,"cpuUsage":1.0499825,"getsPerSecond":0.0,"gcCount":76,"gcTimeMilliseconds":828,"locator":false,"server":true,"lruEvictionsPerSecond":0.0,"putsPerSecond":0.0}]},"process":{"cpu":{"percentage":0.05882517717583126},"files":{"open_files":158},"memory":{"jvm":{"heap":{"committed_kb":262144,"used_kb":195138},"nonheap":{"committed_kb":165360,"used_kb":159958}},"vsz_kb":2448464}},"streaming_metrics":{"supervisors":2,"slotsTotal":8,"slotsUsed":4,"slotsFree":4,"executorsTotal":28,"tasksTotal":28,"totalMemoryMB":6144.0,"totalCPU":800.0,"availableMemoryMB":2816.0,"availableCPU":800.0,"memoryAssignedPercentUtilization":54.2,"cpuAssignedPercentUtilization":0.0,"nimbusMetrics":[{"host":"mx20636vm.fr.murex.com","port":10011,"status":"Not a Leader","nimbusUpTimeSeconds":177235},{"host":"mx20634vm.fr.murex.com","port":10011,"status":"Leader","nimbusUpTimeSeconds":177238}],"supervisorMetrics":{"Supervisor_1":{"host":"mx20634vm.fr.murex.com","id":"2622c0a4-1d51-409d-a077-b2cfbe78bda4","uptimeSeconds":177234,"slotsTotal":4,"slotsUsed":2,"totalMemoryMB":3072.0,"totalCPU":400.0,"usedMemoryMB":1664.0,"usedCPU":0.0},"Supervisor_4":{"host":"mx20636vm.fr.murex.com","id":"85fa61bc-c546-4cec-8c58-cae0b4ddc532","uptimeSeconds":177234,"slotsTotal":4,"slotsUsed":2,"totalMemoryMB":3072.0,"totalCPU":400.0,"usedMemoryMB":1664.0,"usedCPU":0.0}},"topologyMetrics":[{"id":"CollateralInterest_INTERNAL-5-1576061147","name":"CollateralInterest_INTERNAL","status":"ACTIVE","uptime":"1d 22h 44m 47s","uptimeSeconds":168287,"tasksTotal":7,"workersTotal":1,"executorsTotal":7,"replicationCount":2,"requestedMemoryOnHeapMB":0.0,"requestedMemoryOffHeapMB":0.0,"requestedTotalMemoryMB":0.0,"requestedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"assignedTotalMemoryMB":832.0,"assignedCPUPercent":0.0,"spoutMetrics":[{"executors":1,"emitted":2120,"transferred":2120,"acked":1840,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64915,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"contribution-event-spout","completeLatency":"31.837"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64915,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"balancereset-event-spout","completeLatency":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"data-loss-spout","completeLatency":"0.000"}],"boltMetrics":[{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"balancereset-filter","executeLatency":"0.000","executed":0,"processLatency":"0.000","capacity":"0.000"},{"executors":1,"emitted":1500,"transferred":1500,"acked":1840,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"contribution-filter","executeLatency":"0.348","executed":1840,"processLatency":"0.152","capacity":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":1600,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"aggregator","executeLatency":"1.350","executed":1600,"processLatency":"1.425","capacity":"0.000"}],"workerMetrics":[{"topologyName":"CollateralInterest_INTERNAL","topologyID":"CollateralInterest_INTERNAL-5-1576061147","host":"mx20634vm.fr.murex.com","port":10012,"uptimeSeconds":64898,"executorsTotal":7,"assignedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"supervisorId":"2622c0a4-1d51-409d-a077-b2cfbe78bda4","componentTasks":[{"componentName":"contribution-event-spout","numberOfTasks":1},{"componentName":"balancereset-event-spout","numberOfTasks":1},{"componentName":"data-loss-spout","numberOfTasks":1},{"componentName":"aggregator","numberOfTasks":1},{"componentName":"balancereset-filter","numberOfTasks":1},{"componentName":"contribution-filter","numberOfTasks":1}]}],"topologyStats":[{"window":"10m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"3h 0m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"1d 0h 0m 0s","emitted":3620,"transferred":3620,"completeLatency":"31.837","acked":1840,"failed":null},{"window":"All time","emitted":3620,"transferred":3620,"completeLatency":"31.837","acked":1840,"failed":null}]},{"id":"Collateralbreakdown_INTERNAL-7-1576061152","name":"Collateralbreakdown_INTERNAL","status":"ACTIVE","uptime":"1d 22h 44m 42s","uptimeSeconds":168282,"tasksTotal":7,"workersTotal":1,"executorsTotal":7,"replicationCount":2,"requestedMemoryOnHeapMB":0.0,"requestedMemoryOffHeapMB":0.0,"requestedTotalMemoryMB":0.0,"requestedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"assignedTotalMemoryMB":832.0,"assignedCPUPercent":0.0,"spoutMetrics":[{"executors":1,"emitted":1740,"transferred":1740,"acked":1820,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64916,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"contribution-event-spout","completeLatency":"30.407"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64916,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"balancereset-event-spout","completeLatency":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"data-loss-spout","completeLatency":"0.000"}],"boltMetrics":[{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"balancereset-filter","executeLatency":"0.000","executed":0,"processLatency":"0.000","capacity":"0.000"},{"executors":1,"emitted":2120,"transferred":2120,"acked":1840,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"contribution-filter","executeLatency":"0.132","executed":1820,"processLatency":"0.087","capacity":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":1820,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"aggregator","executeLatency":"1.297","executed":1820,"processLatency":"1.747","capacity":"0.000"}],"workerMetrics":[{"topologyName":"Collateralbreakdown_INTERNAL","topologyID":"Collateralbreakdown_INTERNAL-7-1576061152","host":"mx20636vm.fr.murex.com","port":20012,"uptimeSeconds":64900,"executorsTotal":7,"assignedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"supervisorId":"85fa61bc-c546-4cec-8c58-cae0b4ddc532","componentTasks":[{"componentName":"contribution-event-spout","numberOfTasks":1},{"componentName":"balancereset-event-spout","numberOfTasks":1},{"componentName":"data-loss-spout","numberOfTasks":1},{"componentName":"aggregator","numberOfTasks":1},{"componentName":"balancereset-filter","numberOfTasks":1},{"componentName":"contribution-filter","numberOfTasks":1}]}],"topologyStats":[{"window":"10m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"3h 0m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"1d 0h 0m 0s","emitted":3860,"transferred":3860,"completeLatency":"30.407","acked":1820,"failed":null},{"window":"All time","emitted":3860,"transferred":3860,"completeLatency":"30.407","acked":1820,"failed":null}]},{"id":"CollateralTriparty_INTERNAL-8-1576061154","name":"CollateralTriparty_INTERNAL","status":"ACTIVE","uptime":"1d 22h 44m 40s","uptimeSeconds":168280,"tasksTotal":7,"workersTotal":1,"executorsTotal":7,"replicationCount":2,"requestedMemoryOnHeapMB":0.0,"requestedMemoryOffHeapMB":0.0,"requestedTotalMemoryMB":0.0,"requestedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"assignedTotalMemoryMB":832.0,"assignedCPUPercent":0.0,"spoutMetrics":[{"executors":1,"emitted":2060,"transferred":2060,"acked":1820,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64909,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"contribution-event-spout","completeLatency":"2.747"},{"executors":1,"emitted":40,"transferred":40,"acked":80,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64909,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"balancereset-event-spout","completeLatency":"20.500"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"data-loss-spout","completeLatency":"0.000"}],"boltMetrics":[{"executors":1,"emitted":80,"transferred":80,"acked":80,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"balancereset-filter","executeLatency":"0.250","executed":80,"processLatency":"0.500","capacity":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":1840,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"contribution-filter","executeLatency":"0.066","executed":1820,"processLatency":"0.065","capacity":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":80,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"aggregator","executeLatency":"3.250","executed":80,"processLatency":"5.250","capacity":"0.000"}],"workerMetrics":[{"topologyName":"CollateralTriparty_INTERNAL","topologyID":"CollateralTriparty_INTERNAL-8-1576061154","host":"mx20634vm.fr.murex.com","port":10013,"uptimeSeconds":64892,"executorsTotal":7,"assignedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"supervisorId":"2622c0a4-1d51-409d-a077-b2cfbe78bda4","componentTasks":[{"componentName":"contribution-event-spout","numberOfTasks":1},{"componentName":"balancereset-event-spout","numberOfTasks":1},{"componentName":"data-loss-spout","numberOfTasks":1},{"componentName":"aggregator","numberOfTasks":1},{"componentName":"balancereset-filter","numberOfTasks":1},{"componentName":"contribution-filter","numberOfTasks":1}]}],"topologyStats":[{"window":"10m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"3h 0m 0s","emitted":60,"transferred":60,"completeLatency":"6.500","acked":40,"failed":null},{"window":"1d 0h 0m 0s","emitted":2180,"transferred":2180,"completeLatency":"3.495","acked":1900,"failed":null},{"window":"All time","emitted":2180,"transferred":2180,"completeLatency":"3.495","acked":1900,"failed":null}]},{"id":"CollateralBalance_INTERNAL-6-1576061149","name":"CollateralBalance_INTERNAL","status":"ACTIVE","uptime":"1d 22h 44m 45s","uptimeSeconds":168285,"tasksTotal":7,"workersTotal":1,"executorsTotal":7,"replicationCount":2,"requestedMemoryOnHeapMB":0.0,"requestedMemoryOffHeapMB":0.0,"requestedTotalMemoryMB":0.0,"requestedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"assignedTotalMemoryMB":832.0,"assignedCPUPercent":0.0,"spoutMetrics":[{"executors":1,"emitted":1480,"transferred":1480,"acked":1840,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64910,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"contribution-event-spout","completeLatency":"5.739"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu","errorLapsedSecs":64910,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"balancereset-event-spout","completeLatency":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"spoutID":"data-loss-spout","completeLatency":"0.000"}],"boltMetrics":[{"executors":1,"emitted":0,"transferred":0,"acked":0,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"balancereset-filter","executeLatency":"0.000","executed":0,"processLatency":"0.000","capacity":"0.000"},{"executors":1,"emitted":420,"transferred":420,"acked":1840,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"contribution-filter","executeLatency":"0.099","executed":1820,"processLatency":"0.087","capacity":"0.000"},{"executors":1,"emitted":0,"transferred":0,"acked":500,"tasks":1,"lastError":"","errorLapsedSecs":null,"failed":0,"requestedMemoryOnHeapMB":128.0,"requestedMemoryOffHeapMB":0.0,"requestedCPUPercent":10.0,"boltID":"aggregator","executeLatency":"2.600","executed":500,"processLatency":"3.280","capacity":"0.000"}],"workerMetrics":[{"topologyName":"CollateralBalance_INTERNAL","topologyID":"CollateralBalance_INTERNAL-6-1576061149","host":"mx20636vm.fr.murex.com","port":20013,"uptimeSeconds":64894,"executorsTotal":7,"assignedCPUPercent":0.0,"assignedMemoryOnHeapMB":832.0,"assignedMemoryOffHeapMB":0.0,"supervisorId":"85fa61bc-c546-4cec-8c58-cae0b4ddc532","componentTasks":[{"componentName":"contribution-event-spout","numberOfTasks":1},{"componentName":"balancereset-event-spout","numberOfTasks":1},{"componentName":"data-loss-spout","numberOfTasks":1},{"componentName":"aggregator","numberOfTasks":1},{"componentName":"balancereset-filter","numberOfTasks":1},{"componentName":"contribution-filter","numberOfTasks":1}]}],"topologyStats":[{"window":"10m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"3h 0m 0s","emitted":0,"transferred":0,"completeLatency":"0","acked":0,"failed":null},{"window":"1d 0h 0m 0s","emitted":1900,"transferred":1900,"completeLatency":"5.739","acked":1840,"failed":null},{"window":"All time","emitted":1900,"transferred":1900,"completeLatency":"5.739","acked":1840,"failed":null}]}]}},"histograms":{},"meters":{},"timers":{"process":{"memory":{"gc":{"g1_old_generation":{"events":{"count":0,"rate_1m":0.0,"rate_5m":0.0,"rate_15m":0.0,"rate_mean":0.0},"duration_ms":{"max":0.0,"mean":0.0,"median":0.0,"min":0.0,"percentile_75":0.0,"percentile_95":0.0,"percentile_98":0.0,"percentile_99":0.0,"percentile_999":0.0,"standard_deviation":0.0}},"g1_young_generation":{"events":{"count":555,"rate_1m":2.487837344060434E-4,"rate_5m":0.0021054819007852075,"rate_15m":0.002639892616381077,"rate_mean":0.003131245713024466},"duration_ms":{"max":9.0,"mean":8.0,"median":8.0,"min":7.0,"percentile_75":9.0,"percentile_95":9.0,"percentile_98":9.0,"percentile_99":9.0,"percentile_999":9.0,"standard_deviation":1.414213562373095}}}}}}}}
0 Karma
1 Solution

kamlesh_vaghela
SplunkTrust
SplunkTrust

@agoyal

Can you please try this?

YOUR_SEARCH | spath "mtr.gauges.streaming_metrics.topologyMetrics{}" output=topologyMetrics | mvexpand topologyMetrics 
| eval _raw=topologyMetrics | extract
| rename boltMetrics{}.* as *
| fields id name boltID emitted
| eval tmp=mvzip(boltID,emitted)
| mvexpand tmp
| eval boltID=mvindex(split(tmp,","),0),emitted=mvindex(split(tmp,","),1)
| table id name boltID emitted

Sample:

| makeresults 
| eval _raw="{\"v\":\"1.0\",\"t\":\"MTR\",\"ts\":\"2019-12-13T10:30:34.433+01:00\",\"h\":\"mx20631vm.fr.murex.com\",\"pid\":659387,\"src\":{\"c\":\"positions-management-v1\",\"d\":\"positions\",\"sd\":\"\"},\"mtr\":{\"counters\":{\"process\":{\"cpu\":{\"time_cumulated_s\":1458},\"memory\":{\"gc\":{\"g1_old_generation\":{\"total_duration_ms\":0},\"g1_young_generation\":{\"total_duration_ms\":6760}}}}},\"gauges\":{\"caching_metrics\":{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":12288,\"totalHitCount\":2620435,\"totalMissCount\":40668,\"totalRegionCount\":17,\"totalRegionEntryCount\":10932,\"usedMemoryMB\":3041,\"clientCount\":7,\"locatorCount\":2,\"memberCount\":5,\"regions\":[{\"regionName\":\"CollateralBalance_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralBalance_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":4536,\"entrySizeMB\":1,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralBalance_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralInterest_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralInterest_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2221,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralInterest_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralTriparty_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralTriparty_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":594,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralTriparty_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"Collateralbreakdown_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"Collateralbreakdown_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":3541,\"entrySizeMB\":1,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"Collateralbreakdown_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"position-views\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":4,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"position-views-deployment-metrics\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":4,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"position-views-deployment-queue\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":0,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"topology-lowest-pending-id\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":8,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"topology-spout-status\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":8,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0}],\"nodes\": 
[ {\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":0,\"totalMissCount\":0,\"totalRegionCount\":0,\"totalRegionEntryCount\":0,\"usedMemoryMB\":278,\"nodeName\":\"positions-gf-locator-v1-2\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.23333333,\"getsPerSecond\":0.0,\"gcCount\":41,\"gcTimeMilliseconds\":640,\"locator\":true,\"server\":false,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":0,\"totalMissCount\":0,\"totalRegionCount\":0,\"totalRegionEntryCount\":0,\"usedMemoryMB\":1155,\"nodeName\":\"positions-gf-locator-v1-1\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.43332613,\"getsPerSecond\":0.0,\"gcCount\":40,\"gcTimeMilliseconds\":961,\"locator\":true,\"server\":false,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":1104067,\"totalMissCount\":13854,\"totalRegionCount\":17,\"totalRegionEntryCount\":7402,\"usedMemoryMB\":117,\"nodeName\":\"positions-gf-cacheserver-v1-3\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.98333335,\"getsPerSecond\":0.0,\"gcCount\":76,\"gcTimeMilliseconds\":724,\"locator\":false,\"server\":true,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":534237,\"totalMissCount\":13588,\"totalRegionCount\":17,\"totalRegionEntryCount\":7327,\"usedMemoryMB\":1130,\"nodeName\":\"positions-gf-cacheserver-v1-1\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.88331866,\"getsPerSecond\":0.0,\"gcCount\":63,\"gcTimeMilliseconds\":855,\"locator\":false,\"server\":true,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":982131,\"totalMissCount\":13226,\"totalRegionCount\":17,\"totalRegionEntryCount\":7223,\"usedMemoryMB\":285,\"nodeName\":\"positions-gf-cacheserver-v1-2\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":1.0499825,\"getsPerSecond\":0.0,\"gcCount\":76,\"gcTimeMilliseconds\":828,\"locator\":false,\"server\":true,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0}]},\"process\":{\"cpu\":{\"percentage\":0.05882517717583126},\"files\":{\"open_files\":158},\"memory\":{\"jvm\":{\"heap\":{\"committed_kb\":262144,\"used_kb\":195138},\"nonheap\":{\"committed_kb\":165360,\"used_kb\":159958}},\"vsz_kb\":2448464}},\"streaming_metrics\":{\"supervisors\":2,\"slotsTotal\":8,\"slotsUsed\":4,\"slotsFree\":4,\"executorsTotal\":28,\"tasksTotal\":28,\"totalMemoryMB\":6144.0,\"totalCPU\":800.0,\"availableMemoryMB\":2816.0,\"availableCPU\":800.0,\"memoryAssignedPercentUtilization\":54.2,\"cpuAssignedPercentUtilization\":0.0,\"nimbusMetrics\": 
[ {\"host\":\"mx20636vm.fr.murex.com\",\"port\":10011,\"status\":\"Not a Leader\",\"nimbusUpTimeSeconds\":177235},{\"host\":\"mx20634vm.fr.murex.com\",\"port\":10011,\"status\":\"Leader\",\"nimbusUpTimeSeconds\":177238}],\"supervisorMetrics\":{\"Supervisor_1\":{\"host\":\"mx20634vm.fr.murex.com\",\"id\":\"2622c0a4-1d51-409d-a077-b2cfbe78bda4\",\"uptimeSeconds\":177234,\"slotsTotal\":4,\"slotsUsed\":2,\"totalMemoryMB\":3072.0,\"totalCPU\":400.0,\"usedMemoryMB\":1664.0,\"usedCPU\":0.0},\"Supervisor_4\":{\"host\":\"mx20636vm.fr.murex.com\",\"id\":\"85fa61bc-c546-4cec-8c58-cae0b4ddc532\",\"uptimeSeconds\":177234,\"slotsTotal\":4,\"slotsUsed\":2,\"totalMemoryMB\":3072.0,\"totalCPU\":400.0,\"usedMemoryMB\":1664.0,\"usedCPU\":0.0}},\"topologyMetrics\": 
[ {\"id\":\"CollateralInterest_INTERNAL-5-1576061147\",\"name\":\"CollateralInterest_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 47s\",\"uptimeSeconds\":168287,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":2120,\"transferred\":2120,\"acked\":1840,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64915,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"31.837\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64915,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.000\",\"executed\":0,\"processLatency\":\"0.000\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":1500,\"transferred\":1500,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.348\",\"executed\":1840,\"processLatency\":\"0.152\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":1600,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"1.350\",\"executed\":1600,\"processLatency\":\"1.425\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"CollateralInterest_INTERNAL\",\"topologyID\":\"CollateralInterest_INTERNAL-5-1576061147\",\"host\":\"mx20634vm.fr.murex.com\",\"port\":10012,\"uptimeSeconds\":64898,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"2622c0a4-1d51-409d-a077-b2cfbe78bda4\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":3620,\"transferred\":3620,\"completeLatency\":\"31.837\",\"acked\":1840,\"failed\":null},{\"window\":\"All time\",\"emitted\":3620,\"transferred\":3620,\"completeLatency\":\"31.837\",\"acked\":1840,\"failed\":null}]},{\"id\":\"Collateralbreakdown_INTERNAL-7-1576061152\",\"name\":\"Collateralbreakdown_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 42s\",\"uptimeSeconds\":168282,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":1740,\"transferred\":1740,\"acked\":1820,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64916,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"30.407\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64916,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.000\",\"executed\":0,\"processLatency\":\"0.000\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":2120,\"transferred\":2120,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.132\",\"executed\":1820,\"processLatency\":\"0.087\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":1820,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"1.297\",\"executed\":1820,\"processLatency\":\"1.747\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"Collateralbreakdown_INTERNAL\",\"topologyID\":\"Collateralbreakdown_INTERNAL-7-1576061152\",\"host\":\"mx20636vm.fr.murex.com\",\"port\":20012,\"uptimeSeconds\":64900,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"85fa61bc-c546-4cec-8c58-cae0b4ddc532\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":3860,\"transferred\":3860,\"completeLatency\":\"30.407\",\"acked\":1820,\"failed\":null},{\"window\":\"All time\",\"emitted\":3860,\"transferred\":3860,\"completeLatency\":\"30.407\",\"acked\":1820,\"failed\":null}]},{\"id\":\"CollateralTriparty_INTERNAL-8-1576061154\",\"name\":\"CollateralTriparty_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 40s\",\"uptimeSeconds\":168280,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":2060,\"transferred\":2060,\"acked\":1820,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64909,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"2.747\"},{\"executors\":1,\"emitted\":40,\"transferred\":40,\"acked\":80,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64909,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"20.500\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":80,\"transferred\":80,\"acked\":80,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.250\",\"executed\":80,\"processLatency\":\"0.500\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.066\",\"executed\":1820,\"processLatency\":\"0.065\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":80,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"3.250\",\"executed\":80,\"processLatency\":\"5.250\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"CollateralTriparty_INTERNAL\",\"topologyID\":\"CollateralTriparty_INTERNAL-8-1576061154\",\"host\":\"mx20634vm.fr.murex.com\",\"port\":10013,\"uptimeSeconds\":64892,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"2622c0a4-1d51-409d-a077-b2cfbe78bda4\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":60,\"transferred\":60,\"completeLatency\":\"6.500\",\"acked\":40,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":2180,\"transferred\":2180,\"completeLatency\":\"3.495\",\"acked\":1900,\"failed\":null},{\"window\":\"All time\",\"emitted\":2180,\"transferred\":2180,\"completeLatency\":\"3.495\",\"acked\":1900,\"failed\":null}]},{\"id\":\"CollateralBalance_INTERNAL-6-1576061149\",\"name\":\"CollateralBalance_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 45s\",\"uptimeSeconds\":168285,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":1480,\"transferred\":1480,\"acked\":1840,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64910,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"5.739\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64910,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.000\",\"executed\":0,\"processLatency\":\"0.000\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":420,\"transferred\":420,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.099\",\"executed\":1820,\"processLatency\":\"0.087\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":500,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"2.600\",\"executed\":500,\"processLatency\":\"3.280\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"CollateralBalance_INTERNAL\",\"topologyID\":\"CollateralBalance_INTERNAL-6-1576061149\",\"host\":\"mx20636vm.fr.murex.com\",\"port\":20013,\"uptimeSeconds\":64894,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"85fa61bc-c546-4cec-8c58-cae0b4ddc532\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":1900,\"transferred\":1900,\"completeLatency\":\"5.739\",\"acked\":1840,\"failed\":null},{\"window\":\"All time\",\"emitted\":1900,\"transferred\":1900,\"completeLatency\":\"5.739\",\"acked\":1840,\"failed\":null}]}]}},\"histograms\":{},\"meters\":{},\"timers\":{\"process\":{\"memory\":{\"gc\":{\"g1_old_generation\":{\"events\":{\"count\":0,\"rate_1m\":0.0,\"rate_5m\":0.0,\"rate_15m\":0.0,\"rate_mean\":0.0},\"duration_ms\":{\"max\":0.0,\"mean\":0.0,\"median\":0.0,\"min\":0.0,\"percentile_75\":0.0,\"percentile_95\":0.0,\"percentile_98\":0.0,\"percentile_99\":0.0,\"percentile_999\":0.0,\"standard_deviation\":0.0}},\"g1_young_generation\":{\"events\":{\"count\":555,\"rate_1m\":2.487837344060434E-4,\"rate_5m\":0.0021054819007852075,\"rate_15m\":0.002639892616381077,\"rate_mean\":0.003131245713024466},\"duration_ms\":{\"max\":9.0,\"mean\":8.0,\"median\":8.0,\"min\":7.0,\"percentile_75\":9.0,\"percentile_95\":9.0,\"percentile_98\":9.0,\"percentile_99\":9.0,\"percentile_999\":9.0,\"standard_deviation\":1.414213562373095}}}}}}}}" 
| extract
| spath "mtr.gauges.streaming_metrics.topologyMetrics{}" output=topologyMetrics | mvexpand topologyMetrics 
| eval _raw=topologyMetrics | extract
| rename boltMetrics{}.* as *
| fields id name boltID emitted
| eval tmp=mvzip(boltID,emitted)
| mvexpand tmp
| eval boltID=mvindex(split(tmp,","),0),emitted=mvindex(split(tmp,","),1)
| table id name boltID emitted

Thanks

View solution in original post

kamlesh_vaghela
SplunkTrust
SplunkTrust

@agoyal

Can you please try this?

YOUR_SEARCH | spath "mtr.gauges.streaming_metrics.topologyMetrics{}" output=topologyMetrics | mvexpand topologyMetrics 
| eval _raw=topologyMetrics | extract
| rename boltMetrics{}.* as *
| fields id name boltID emitted
| eval tmp=mvzip(boltID,emitted)
| mvexpand tmp
| eval boltID=mvindex(split(tmp,","),0),emitted=mvindex(split(tmp,","),1)
| table id name boltID emitted

Sample:

| makeresults 
| eval _raw="{\"v\":\"1.0\",\"t\":\"MTR\",\"ts\":\"2019-12-13T10:30:34.433+01:00\",\"h\":\"mx20631vm.fr.murex.com\",\"pid\":659387,\"src\":{\"c\":\"positions-management-v1\",\"d\":\"positions\",\"sd\":\"\"},\"mtr\":{\"counters\":{\"process\":{\"cpu\":{\"time_cumulated_s\":1458},\"memory\":{\"gc\":{\"g1_old_generation\":{\"total_duration_ms\":0},\"g1_young_generation\":{\"total_duration_ms\":6760}}}}},\"gauges\":{\"caching_metrics\":{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":12288,\"totalHitCount\":2620435,\"totalMissCount\":40668,\"totalRegionCount\":17,\"totalRegionEntryCount\":10932,\"usedMemoryMB\":3041,\"clientCount\":7,\"locatorCount\":2,\"memberCount\":5,\"regions\":[{\"regionName\":\"CollateralBalance_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralBalance_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":4536,\"entrySizeMB\":1,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralBalance_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralInterest_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralInterest_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2221,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralInterest_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralTriparty_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralTriparty_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":594,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"CollateralTriparty_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"Collateralbreakdown_INTERNAL-heartbeat\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"Collateralbreakdown_INTERNAL-positions-data\",\"regionType\":\"PARTITION\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":3541,\"entrySizeMB\":1,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"Collateralbreakdown_INTERNAL-state\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":2,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"position-views\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":4,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"position-views-deployment-metrics\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":4,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"position-views-deployment-queue\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":0,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"topology-lowest-pending-id\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":8,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"regionName\":\"topology-spout-status\",\"regionType\":\"REPLICATE\",\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"entryCount\":8,\"entrySizeMB\":0,\"getsPerSecond\":0.0,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0}],\"nodes\": 
[ {\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":0,\"totalMissCount\":0,\"totalRegionCount\":0,\"totalRegionEntryCount\":0,\"usedMemoryMB\":278,\"nodeName\":\"positions-gf-locator-v1-2\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.23333333,\"getsPerSecond\":0.0,\"gcCount\":41,\"gcTimeMilliseconds\":640,\"locator\":true,\"server\":false,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":0,\"totalMissCount\":0,\"totalRegionCount\":0,\"totalRegionEntryCount\":0,\"usedMemoryMB\":1155,\"nodeName\":\"positions-gf-locator-v1-1\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.43332613,\"getsPerSecond\":0.0,\"gcCount\":40,\"gcTimeMilliseconds\":961,\"locator\":true,\"server\":false,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":1104067,\"totalMissCount\":13854,\"totalRegionCount\":17,\"totalRegionEntryCount\":7402,\"usedMemoryMB\":117,\"nodeName\":\"positions-gf-cacheserver-v1-3\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.98333335,\"getsPerSecond\":0.0,\"gcCount\":76,\"gcTimeMilliseconds\":724,\"locator\":false,\"server\":true,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":534237,\"totalMissCount\":13588,\"totalRegionCount\":17,\"totalRegionEntryCount\":7327,\"usedMemoryMB\":1130,\"nodeName\":\"positions-gf-cacheserver-v1-1\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":0.88331866,\"getsPerSecond\":0.0,\"gcCount\":63,\"gcTimeMilliseconds\":855,\"locator\":false,\"server\":true,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0},{\"readsPerSecond\":0.0,\"writesPerSecond\":0.0,\"maxMemoryMB\":2048,\"totalHitCount\":982131,\"totalMissCount\":13226,\"totalRegionCount\":17,\"totalRegionEntryCount\":7223,\"usedMemoryMB\":285,\"nodeName\":\"positions-gf-cacheserver-v1-2\",\"bytesReceivedPerSecond\":0.0,\"bytesSentPerSecond\":0.0,\"cpuUsage\":1.0499825,\"getsPerSecond\":0.0,\"gcCount\":76,\"gcTimeMilliseconds\":828,\"locator\":false,\"server\":true,\"lruEvictionsPerSecond\":0.0,\"putsPerSecond\":0.0}]},\"process\":{\"cpu\":{\"percentage\":0.05882517717583126},\"files\":{\"open_files\":158},\"memory\":{\"jvm\":{\"heap\":{\"committed_kb\":262144,\"used_kb\":195138},\"nonheap\":{\"committed_kb\":165360,\"used_kb\":159958}},\"vsz_kb\":2448464}},\"streaming_metrics\":{\"supervisors\":2,\"slotsTotal\":8,\"slotsUsed\":4,\"slotsFree\":4,\"executorsTotal\":28,\"tasksTotal\":28,\"totalMemoryMB\":6144.0,\"totalCPU\":800.0,\"availableMemoryMB\":2816.0,\"availableCPU\":800.0,\"memoryAssignedPercentUtilization\":54.2,\"cpuAssignedPercentUtilization\":0.0,\"nimbusMetrics\": 
[ {\"host\":\"mx20636vm.fr.murex.com\",\"port\":10011,\"status\":\"Not a Leader\",\"nimbusUpTimeSeconds\":177235},{\"host\":\"mx20634vm.fr.murex.com\",\"port\":10011,\"status\":\"Leader\",\"nimbusUpTimeSeconds\":177238}],\"supervisorMetrics\":{\"Supervisor_1\":{\"host\":\"mx20634vm.fr.murex.com\",\"id\":\"2622c0a4-1d51-409d-a077-b2cfbe78bda4\",\"uptimeSeconds\":177234,\"slotsTotal\":4,\"slotsUsed\":2,\"totalMemoryMB\":3072.0,\"totalCPU\":400.0,\"usedMemoryMB\":1664.0,\"usedCPU\":0.0},\"Supervisor_4\":{\"host\":\"mx20636vm.fr.murex.com\",\"id\":\"85fa61bc-c546-4cec-8c58-cae0b4ddc532\",\"uptimeSeconds\":177234,\"slotsTotal\":4,\"slotsUsed\":2,\"totalMemoryMB\":3072.0,\"totalCPU\":400.0,\"usedMemoryMB\":1664.0,\"usedCPU\":0.0}},\"topologyMetrics\": 
[ {\"id\":\"CollateralInterest_INTERNAL-5-1576061147\",\"name\":\"CollateralInterest_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 47s\",\"uptimeSeconds\":168287,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":2120,\"transferred\":2120,\"acked\":1840,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64915,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"31.837\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64915,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.000\",\"executed\":0,\"processLatency\":\"0.000\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":1500,\"transferred\":1500,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.348\",\"executed\":1840,\"processLatency\":\"0.152\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":1600,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"1.350\",\"executed\":1600,\"processLatency\":\"1.425\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"CollateralInterest_INTERNAL\",\"topologyID\":\"CollateralInterest_INTERNAL-5-1576061147\",\"host\":\"mx20634vm.fr.murex.com\",\"port\":10012,\"uptimeSeconds\":64898,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"2622c0a4-1d51-409d-a077-b2cfbe78bda4\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":3620,\"transferred\":3620,\"completeLatency\":\"31.837\",\"acked\":1840,\"failed\":null},{\"window\":\"All time\",\"emitted\":3620,\"transferred\":3620,\"completeLatency\":\"31.837\",\"acked\":1840,\"failed\":null}]},{\"id\":\"Collateralbreakdown_INTERNAL-7-1576061152\",\"name\":\"Collateralbreakdown_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 42s\",\"uptimeSeconds\":168282,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":1740,\"transferred\":1740,\"acked\":1820,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64916,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"30.407\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64916,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.000\",\"executed\":0,\"processLatency\":\"0.000\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":2120,\"transferred\":2120,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.132\",\"executed\":1820,\"processLatency\":\"0.087\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":1820,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"1.297\",\"executed\":1820,\"processLatency\":\"1.747\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"Collateralbreakdown_INTERNAL\",\"topologyID\":\"Collateralbreakdown_INTERNAL-7-1576061152\",\"host\":\"mx20636vm.fr.murex.com\",\"port\":20012,\"uptimeSeconds\":64900,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"85fa61bc-c546-4cec-8c58-cae0b4ddc532\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":3860,\"transferred\":3860,\"completeLatency\":\"30.407\",\"acked\":1820,\"failed\":null},{\"window\":\"All time\",\"emitted\":3860,\"transferred\":3860,\"completeLatency\":\"30.407\",\"acked\":1820,\"failed\":null}]},{\"id\":\"CollateralTriparty_INTERNAL-8-1576061154\",\"name\":\"CollateralTriparty_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 40s\",\"uptimeSeconds\":168280,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":2060,\"transferred\":2060,\"acked\":1820,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64909,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"2.747\"},{\"executors\":1,\"emitted\":40,\"transferred\":40,\"acked\":80,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64909,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"20.500\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":80,\"transferred\":80,\"acked\":80,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.250\",\"executed\":80,\"processLatency\":\"0.500\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.066\",\"executed\":1820,\"processLatency\":\"0.065\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":80,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"3.250\",\"executed\":80,\"processLatency\":\"5.250\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"CollateralTriparty_INTERNAL\",\"topologyID\":\"CollateralTriparty_INTERNAL-8-1576061154\",\"host\":\"mx20634vm.fr.murex.com\",\"port\":10013,\"uptimeSeconds\":64892,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"2622c0a4-1d51-409d-a077-b2cfbe78bda4\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":60,\"transferred\":60,\"completeLatency\":\"6.500\",\"acked\":40,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":2180,\"transferred\":2180,\"completeLatency\":\"3.495\",\"acked\":1900,\"failed\":null},{\"window\":\"All time\",\"emitted\":2180,\"transferred\":2180,\"completeLatency\":\"3.495\",\"acked\":1900,\"failed\":null}]},{\"id\":\"CollateralBalance_INTERNAL-6-1576061149\",\"name\":\"CollateralBalance_INTERNAL\",\"status\":\"ACTIVE\",\"uptime\":\"1d 22h 44m 45s\",\"uptimeSeconds\":168285,\"tasksTotal\":7,\"workersTotal\":1,\"executorsTotal\":7,\"replicationCount\":2,\"requestedMemoryOnHeapMB\":0.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedTotalMemoryMB\":0.0,\"requestedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"assignedTotalMemoryMB\":832.0,\"assignedCPUPercent\":0.0,\"spoutMetrics\": 
    [ {\"executors\":1,\"emitted\":1480,\"transferred\":1480,\"acked\":1840,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64910,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"contribution-event-spout\",\"completeLatency\":\"5.739\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"java.lang.RuntimeException: java.sql.SQLException: com.sybase.jdbc4.jdbc.SybSQLException: Database 'TheOne_MX_CI_525' has not been recovered yet - please wait and try again.\n\n\tat com.murex.position.qu\",\"errorLapsedSecs\":64910,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"balancereset-event-spout\",\"completeLatency\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"spoutID\":\"data-loss-spout\",\"completeLatency\":\"0.000\"}],\"boltMetrics\": 
    [ {\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":0,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"balancereset-filter\",\"executeLatency\":\"0.000\",\"executed\":0,\"processLatency\":\"0.000\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":420,\"transferred\":420,\"acked\":1840,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"contribution-filter\",\"executeLatency\":\"0.099\",\"executed\":1820,\"processLatency\":\"0.087\",\"capacity\":\"0.000\"},{\"executors\":1,\"emitted\":0,\"transferred\":0,\"acked\":500,\"tasks\":1,\"lastError\":\"\",\"errorLapsedSecs\":null,\"failed\":0,\"requestedMemoryOnHeapMB\":128.0,\"requestedMemoryOffHeapMB\":0.0,\"requestedCPUPercent\":10.0,\"boltID\":\"aggregator\",\"executeLatency\":\"2.600\",\"executed\":500,\"processLatency\":\"3.280\",\"capacity\":\"0.000\"}],\"workerMetrics\": 
    [ {\"topologyName\":\"CollateralBalance_INTERNAL\",\"topologyID\":\"CollateralBalance_INTERNAL-6-1576061149\",\"host\":\"mx20636vm.fr.murex.com\",\"port\":20013,\"uptimeSeconds\":64894,\"executorsTotal\":7,\"assignedCPUPercent\":0.0,\"assignedMemoryOnHeapMB\":832.0,\"assignedMemoryOffHeapMB\":0.0,\"supervisorId\":\"85fa61bc-c546-4cec-8c58-cae0b4ddc532\",\"componentTasks\": 
        [ {\"componentName\":\"contribution-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-event-spout\",\"numberOfTasks\":1},{\"componentName\":\"data-loss-spout\",\"numberOfTasks\":1},{\"componentName\":\"aggregator\",\"numberOfTasks\":1},{\"componentName\":\"balancereset-filter\",\"numberOfTasks\":1},{\"componentName\":\"contribution-filter\",\"numberOfTasks\":1}]}],\"topologyStats\": 
    [ {\"window\":\"10m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"3h 0m 0s\",\"emitted\":0,\"transferred\":0,\"completeLatency\":\"0\",\"acked\":0,\"failed\":null},{\"window\":\"1d 0h 0m 0s\",\"emitted\":1900,\"transferred\":1900,\"completeLatency\":\"5.739\",\"acked\":1840,\"failed\":null},{\"window\":\"All time\",\"emitted\":1900,\"transferred\":1900,\"completeLatency\":\"5.739\",\"acked\":1840,\"failed\":null}]}]}},\"histograms\":{},\"meters\":{},\"timers\":{\"process\":{\"memory\":{\"gc\":{\"g1_old_generation\":{\"events\":{\"count\":0,\"rate_1m\":0.0,\"rate_5m\":0.0,\"rate_15m\":0.0,\"rate_mean\":0.0},\"duration_ms\":{\"max\":0.0,\"mean\":0.0,\"median\":0.0,\"min\":0.0,\"percentile_75\":0.0,\"percentile_95\":0.0,\"percentile_98\":0.0,\"percentile_99\":0.0,\"percentile_999\":0.0,\"standard_deviation\":0.0}},\"g1_young_generation\":{\"events\":{\"count\":555,\"rate_1m\":2.487837344060434E-4,\"rate_5m\":0.0021054819007852075,\"rate_15m\":0.002639892616381077,\"rate_mean\":0.003131245713024466},\"duration_ms\":{\"max\":9.0,\"mean\":8.0,\"median\":8.0,\"min\":7.0,\"percentile_75\":9.0,\"percentile_95\":9.0,\"percentile_98\":9.0,\"percentile_99\":9.0,\"percentile_999\":9.0,\"standard_deviation\":1.414213562373095}}}}}}}}" 
| extract
| spath "mtr.gauges.streaming_metrics.topologyMetrics{}" output=topologyMetrics | mvexpand topologyMetrics 
| eval _raw=topologyMetrics | extract
| rename boltMetrics{}.* as *
| fields id name boltID emitted
| eval tmp=mvzip(boltID,emitted)
| mvexpand tmp
| eval boltID=mvindex(split(tmp,","),0),emitted=mvindex(split(tmp,","),1)
| table id name boltID emitted

Thanks

View solution in original post

agoyal
Builder

@kamlesh_vaghela : Thank you, worked like a charm and plus learned new commands 🙂

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

Glad to help you @agoyal

Happy Splunking

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

@agoyal

Sample event (_raw) will help us to design search or you.

0 Karma

agoyal
Builder

Added one event.. unfortunately its massive

0 Karma

kamlesh_vaghela
SplunkTrust
SplunkTrust

Thanks @agoyal for sample event. Please check my answer.

0 Karma
Take the 2021 Splunk Career Survey

Help us learn about how Splunk has
impacted your career by taking the 2021 Splunk Career Survey.

Earn $50 in Amazon cash!