<- Back to Templates
VMWare
By KloudMate
The MySQL dashboard provides real-time visibility into database performance and resource utilization by leveraging OpenTelemetry (Otel) for metric collection.
Template JSON
{
"name": "VMWare Dashboard",
"description": "",
"data": {
"tz": "local",
"panels": [
{
"id": "ooqbdw64rj",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"title": "Cluster Memory Limit",
"panelType": "STATS",
"timeRange": "1d",
"statConfig": {
"format": "bytes_iec",
"suffix": "",
"decimals": 2,
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": "",
"calculation": {
"label": "Last",
"value": "last"
}
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "The available memory of the cluster",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "By",
"field": "",
"value": "vcenter_cluster_memory_limit",
"metric": "vcenter_cluster_memory_limit",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "bjodoylwp7g",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "MHz",
"decimals": 3
}
},
"title": "Cluster CPU Effective",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "number",
"suffix": "GHz",
"decimals": 0,
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": "",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": true,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "MHz",
"field": "",
"value": "vcenter_cluster_cpu_effective",
"metric": "vcenter_cluster_cpu_effective",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
},
{
"type": "expression",
"hidden": false,
"nodeId": "B",
"expression": "$A/ 1000",
"expressionType": "math"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "d9xga7bh2tf",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{hosts}",
"decimals": 3
}
},
"title": "Hosts in the Cluster",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{hosts}",
"field": "",
"value": "vcenter_cluster_host_count",
"metric": "vcenter_cluster_host_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "hse4r3vmlug",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT_DISTINCT()",
"rename": "Total VM on Cluster"
}
]
},
"title": "VMs in the Cluster",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{virtual_machines}",
"field": "",
"value": "vcenter_cluster_vm_count",
"metric": "vcenter_cluster_vm_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "itjetmaqchc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT_DISTINCT()",
"rename": "Total VM on Cluster"
}
]
},
"title": "VMs On",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "power_state",
"value": "on",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{virtual_machines}",
"field": "",
"value": "vcenter_cluster_vm_count",
"metric": "vcenter_cluster_vm_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "a1to36n6i09",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT_DISTINCT()",
"rename": "Total VM on Cluster"
}
]
},
"title": "VMs Off",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "power_state",
"value": "off",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{virtual_machines}",
"field": "",
"value": "vcenter_cluster_vm_count",
"metric": "vcenter_cluster_vm_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "gmwqyml6f84",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT_DISTINCT()",
"rename": "Total VM on Cluster"
}
]
},
"title": "VMs Susupended",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "power_state",
"value": "suspended",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{virtual_machines}",
"field": "",
"value": "vcenter_cluster_vm_count",
"metric": "vcenter_cluster_vm_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "1ur6kfo0asu",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "MHz",
"decimals": 3
}
},
"title": "Cluster CPU Limit ",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "number",
"suffix": "GHz",
"decimals": 0,
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": "",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": true,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "MHz",
"field": "",
"value": "vcenter_cluster_cpu_limit",
"metric": "vcenter_cluster_cpu_limit",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
},
{
"type": "expression",
"hidden": false,
"nodeId": "B",
"expression": "$A/ 1000",
"expressionType": "math"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "3tjad23nffw",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"title": "Cluster Memory Effective",
"panelType": "STATS",
"timeRange": "1d",
"statConfig": {
"format": "bytes_iec",
"suffix": "",
"decimals": 2,
"statView": "grid",
"baseColor": "#4CBB17",
"multiplyBy": "",
"calculation": {
"label": "Last",
"value": "last"
}
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "This value excludes memory from hosts that are either in maintenance mode or are unresponsive. It also excludes memory used by the VMware Service Console.",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "By",
"field": "",
"value": "vcenter_cluster_memory_effective",
"metric": "vcenter_cluster_memory_effective",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "3yofi2qdyk6",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "%",
"decimals": 3
}
},
"title": "VM Memory Utilization",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Mean",
"value": "mean"
}
]
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "vcenter_cluster_name",
"value": "MAP1DR09-CSCLOUD01",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "vcenter_vm_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "%",
"field": "",
"value": "vcenter_vm_memory_utilization",
"metric": "vcenter_vm_memory_utilization",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "9ixg82r255n",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "%",
"decimals": 2
}
},
"title": "VM Disk Utliization",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"unit": "%",
"field": "",
"value": "vcenter_vm_disk_utilization",
"metric": "vcenter_vm_disk_utilization",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "kd3xlocpj9r",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "MiBy",
"decimals": 3
}
},
"title": "Host Memory Usage",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "vcenter_cluster_name",
"value": "MAP1DR09-CSCLOUD01",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "vcenter_host_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "MiBy",
"field": "",
"value": "vcenter_host_memory_usage",
"metric": "vcenter_host_memory_usage",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "077sus0xs956",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machine_templates}",
"decimals": 3
}
},
"title": "VM Templates",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{virtual_machine_templates}",
"field": "",
"value": "vcenter_cluster_vm_template_count",
"metric": "vcenter_cluster_vm_template_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0o6znj59hc8b",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{clusters}",
"decimals": 3
}
},
"title": "Datacenter Clusters",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{clusters}",
"field": "",
"value": "vcenter_datacenter_cluster_count",
"metric": "vcenter_datacenter_cluster_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "ghy8dpa78ro",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{datastores}",
"decimals": 3
}
},
"title": "Datacenter Datastores",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": {
"label": "Last",
"value": "last"
}
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{datastores}",
"field": "",
"value": "vcenter_datacenter_datastore_count",
"metric": "vcenter_datacenter_datastore_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "65myk9eib0l",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"title": "Datacenter Disk Space - Used",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "bytes_iec",
"decimals": 2,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "disk_state",
"value": "used",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "By",
"field": "",
"value": "vcenter_datacenter_disk_space",
"metric": "vcenter_datacenter_disk_space",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "6opy5uoioto",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"title": "Datacenter Disk Space - Available",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "bytes_iec",
"decimals": 2,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "disk_state",
"value": "available",
"operator": "="
}
],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "By",
"field": "",
"value": "vcenter_datacenter_disk_space",
"metric": "vcenter_datacenter_disk_space",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "6r232rillkc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{hosts}",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:SUM()",
"rename": "Hosts"
},
{
"key": "status",
"rename": ""
},
{
"key": "power_state",
"rename": ""
}
]
},
"title": "Data centre Hosts",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "table",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "status"
},
{
"type": "string",
"field": "power_state"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{hosts}",
"field": "",
"value": "vcenter_datacenter_host_count",
"metric": "vcenter_datacenter_host_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "7oamua7y8w5",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{virtual_machines}",
"decimals": 3
}
},
"title": "Datacenter VMs",
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{virtual_machines}",
"field": "",
"value": "vcenter_datacenter_vm_count",
"metric": "vcenter_datacenter_vm_count",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "bp3uith3mjc",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "bytes",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:COUNT_DISTINCT()",
"rename": ""
},
{
"key": "B:SUM()",
"format": {
"format": "bytes"
},
"rename": ""
}
]
},
"title": "VM Disk Usage",
"overrides": [],
"panelType": "STATS",
"timeRange": "1h",
"statConfig": {
"format": "bytes_iec",
"decimals": 2,
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "disk_state"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "By",
"field": "",
"value": "vcenter_vm_disk_usage",
"metric": "vcenter_vm_disk_usage",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "05gj6vthe587",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "MiBy",
"decimals": 3
}
},
"title": "VM Memory Usage",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Mean",
"value": "mean"
}
]
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [
{
"type": "string",
"field": "vcenter_cluster_name",
"value": "MAP1DR09-CSCLOUD01",
"operator": "="
}
],
"groupBy": [
{
"type": "string",
"field": "vcenter_vm_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "MiBy",
"field": "",
"value": "vcenter_vm_memory_usage",
"metric": "vcenter_vm_memory_usage",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "3h5alk3h2zz",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "%",
"decimals": 3
}
},
"title": "Host Memory Utilization",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": {
"label": "Count",
"value": "count"
}
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "%",
"field": "",
"range": "20s",
"value": "vcenter_host_memory_utilization",
"metric": "vcenter_host_memory_utilization",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "czpqgej16x8",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{KiBy/s}",
"decimals": 3
}
},
"title": "Host Disk Throughput",
"tooltip": {
"mode": "all"
},
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "direction"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{KiBy/s}",
"field": "",
"value": "vcenter_host_disk_throughput",
"metric": "vcenter_host_disk_throughput",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "1lt9h7y9ijcj",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "%",
"decimals": 3
}
},
"title": "VM CPU Utilization",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "table",
"values": [
{
"label": "Mean",
"value": "mean"
}
]
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "vcenter_vm_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "%",
"field": "",
"value": "vcenter_vm_cpu_utilization",
"metric": "vcenter_vm_cpu_utilization",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0n7g3l6evg7c",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "MHz",
"decimals": 3
}
},
"title": "VM CPU Usage",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "vcenter_vm_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "MHz",
"field": "",
"value": "vcenter_vm_cpu_usage",
"metric": "vcenter_vm_cpu_usage",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "0cnn9w461n0n",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{packets/s}",
"decimals": 3
}
},
"title": "Host Network Packet Drop Rate",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"suffix": "packets/S",
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "COUNT",
"type": "",
"unit": "{packets/s}",
"field": "",
"value": "vcenter_host_network_packet_drop_rate",
"metric": "vcenter_host_network_packet_drop_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "celcshmlw8p",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{errors/s}",
"decimals": 3
}
},
"title": "Host Network Packet Error Rate",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": {
"label": "Total",
"value": "total"
}
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "COUNT",
"type": "",
"unit": "{errors/s}",
"field": "",
"value": "vcenter_host_network_packet_error_rate",
"metric": "vcenter_host_network_packet_error_rate",
"metricType": "Gauge",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"responseType": "series"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "dt3d0cf9wye",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{KiBy/s}",
"decimals": 3
}
},
"title": "Host Network throughput",
"tooltip": {
"mode": "all"
},
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "direction"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{KiBy/s}",
"field": "",
"value": "vcenter_host_network_throughput",
"metric": "vcenter_host_network_throughput",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "8dmkcorsdyj",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "number",
"suffix": "{KiBy/s}",
"decimals": 3
}
},
"title": "Host Network Usage",
"panelType": "TimeSeries",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "vcenter_host_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "SUM",
"type": "",
"unit": "{KiBy/s}",
"field": "",
"value": "vcenter_host_network_usage",
"metric": "vcenter_host_network_usage",
"metricType": "Sum",
"temporality": "Cumulative"
},
"datasourceId": "kloudmate",
"legendFormat": "{{vcenter_host_name}}"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
},
{
"id": "03fal14p1ved",
"tz": "local",
"axis": {
"x": {
"date_style": "auto"
},
"y": {
"format": "unformatted",
"decimals": 3
}
},
"table": {
"columns": [
{
"key": "A:AVG()",
"format": {
"format": "percentage",
"decimals": 2,
"multiplyBy": 0.01
},
"rename": "cpu utilazation"
},
{
"key": "vcenter_host_name",
"rename": ""
},
{
"key": "vcenter_vm_name",
"rename": ""
}
]
},
"title": "Host and associated VMs",
"panelType": "table",
"timeRange": "1h",
"statConfig": {
"statView": "grid",
"baseColor": "#4CBB17",
"calculation": "last"
},
"timeseries": {
"legend": {
"view": "list",
"values": []
}
},
"description": "This will provide all VM names associated with host.",
"node_configs": [
{
"page": 1,
"stat": "",
"type": "query",
"hidden": false,
"metric": "",
"nodeId": "A",
"region": "",
"source": "kloudmate",
"dataset": "metrics",
"filters": [],
"groupBy": [
{
"type": "string",
"field": "vcenter_host_name"
},
{
"type": "string",
"field": "vcenter_vm_name"
}
],
"orderBy": [],
"interval": "",
"namespace": "",
"dimensions": [],
"metricType": "",
"time_range": {
"to": 0,
"from": 600
},
"aggregation": {
"stat": "AVG",
"type": "",
"field": "",
"value": "vcenter_vm_cpu_utilization",
"metric": "vcenter_vm_cpu_utilization"
},
"datasourceId": "kloudmate",
"responseType": "number"
}
],
"time_options": {
"override": false,
"time_shift": ""
}
}
],
"timeRange": "1h",
"variables": [],
"panel_layouts": [
{
"h": 1,
"i": "ooqbdw64rj",
"w": 3,
"x": 6,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "bjodoylwp7g",
"w": 3,
"x": 3,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "d9xga7bh2tf",
"w": 2,
"x": 8,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "hse4r3vmlug",
"w": 2,
"x": 0,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "itjetmaqchc",
"w": 2,
"x": 2,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "a1to36n6i09",
"w": 2,
"x": 4,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "gmwqyml6f84",
"w": 2,
"x": 6,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "1ur6kfo0asu",
"w": 3,
"x": 0,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "3tjad23nffw",
"w": 3,
"x": 9,
"y": 1,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "3yofi2qdyk6",
"w": 6,
"x": 0,
"y": 8,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "9ixg82r255n",
"w": 7,
"x": 5,
"y": 2,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "kd3xlocpj9r",
"w": 6,
"x": 0,
"y": 12,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "077sus0xs956",
"w": 2,
"x": 10,
"y": 0,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "0o6znj59hc8b",
"w": 3,
"x": 0,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "ghy8dpa78ro",
"w": 3,
"x": 3,
"y": 11,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "65myk9eib0l",
"w": 3,
"x": 6,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "6opy5uoioto",
"w": 3,
"x": 9,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "6r232rillkc",
"w": 5,
"x": 7,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 1,
"i": "7oamua7y8w5",
"w": 3,
"x": 3,
"y": 10,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "bp3uith3mjc",
"w": 5,
"x": 0,
"y": 2,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "05gj6vthe587",
"w": 6,
"x": 6,
"y": 8,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "3h5alk3h2zz",
"w": 6,
"x": 6,
"y": 12,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "czpqgej16x8",
"w": 12,
"x": 0,
"y": 18,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "1lt9h7y9ijcj",
"w": 6,
"x": 0,
"y": 6,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "0n7g3l6evg7c",
"w": 6,
"x": 6,
"y": 6,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "0cnn9w461n0n",
"w": 6,
"x": 0,
"y": 14,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "celcshmlw8p",
"w": 6,
"x": 6,
"y": 14,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "dt3d0cf9wye",
"w": 6,
"x": 6,
"y": 16,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "8dmkcorsdyj",
"w": 6,
"x": 0,
"y": 16,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
},
{
"h": 2,
"i": "03fal14p1ved",
"w": 7,
"x": 0,
"y": 4,
"minH": 1,
"minW": 2,
"moved": false,
"static": false
}
],
"default_region": "us-east-1"
},
"tags": null
}