-
What Grafana version and what operating system are you using? Grafana v11.6.0
-
What are you trying to achieve? Trying to manipulate data received from CommVault
-
How are you trying to achieve it? I am using the Infinity plugin.
-
What happened? I am receiving the data, but I am having trouble manipulating it since it’s in one long string.
-
What did you expect to happen? I expected it to fit into a table
-
Can you copy/paste the configuration(s) that you are having problems with? Yes
-
Did you receive any errors in the Grafana UI or in related logs? If so, please tell us exactly what they were. No, I didn’t see any errors I have the data I just can’t arrange it to work with Grafana
-
Did you follow any online instructions? If so, what is the URL? No, not for this nor have I seen this problem before when using Grafana.
what does the data look like, can you post it here?
[{“capacity”:1511192580,“company”:{“id”:0,“name”:“”},“freeSpace”:624929754,“id”:75,“libraryVendorType”:1,“name”:“!usilg01-bbp029_test_restore”,“status”:“Online”,“storagePoolType”:“DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:402639872,“company”:{“id”:0,“name”:“”},“freeSpace”:285237396,“id”:163,“libraryVendorType”:1,“name”:“dpusilg01bad009”,“status”:“Online”,“storagePoolType”:“SCALE_OUT”,“storageType”:“HYPERSCALE”},{“capacity”:1511192580,“company”:{“id”:0,“name”:“”},“freeSpace”:624929754,“id”:4,“libraryVendorType”:1,“name”:“dpusilg01bap017”,“status”:“Online”,“storagePoolType”:“SCALE_OUT”,“storageType”:“HYPERSCALE”},{“capacity”:1196360704,“company”:{“id”:0,“name”:“”},“freeSpace”:470208581,“id”:143,“libraryVendorType”:1,“name”:“dpusilg01bap040UCS”,“status”:“Online”,“storagePoolType”:“SCALE_OUT”,“storageType”:“HYPERSCALE”},{“capacity”:572204472,“company”:{“id”:0,“name”:“”},“freeSpace”:144903131,“id”:236,“libraryVendorType”:1,“name”:“Infinidat DDEA-DB Deduplication usilg01-bap051”,“status”:“Online”,“storagePoolType”:“DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:572204472,“company”:{“id”:0,“name”:“”},“freeSpace”:180975901,“id”:238,“libraryVendorType”:1,“name”:“Infinidat DDEB-FS Deduplication usilg01-bap051”,“status”:“Online”,“storagePoolType”:“DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:572204472,“company”:{“id”:0,“name”:“”},“freeSpace”:402502467,“id”:153,“libraryVendorType”:1,“name”:“InfinidatDDEA-DB”,“status”:“Offline (Library has been marked as Disabled.)”,“storagePoolType”:“NON_DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:572204472,“company”:{“id”:0,“name”:“”},“freeSpace”:261692444,“id”:154,“libraryVendorType”:1,“name”:“InfinidatDDEB-FS”,“status”:“Offline (Library has been marked as Disabled.)”,“storagePoolType”:“NON_DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:1511192580,“company”:{“id”:0,“name”:“”},“freeSpace”:624929754,“id”:65,“libraryVendorType”:1,“name”:“Temp Redgate”,“status”:“Online”,“storagePoolType”:“NON_DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:18866216,“company”:{“id”:0,“name”:“”},“freeSpace”:13655746,“id”:98,“libraryVendorType”:1,“name”:“Urbandale”,“status”:“Online”,“storagePoolType”:“DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:572204472,“company”:{“id”:0,“name”:“”},“freeSpace”:144963823,“id”:232,“libraryVendorType”:1,“name”:“usilg01-bap051 Infinidat DDEA-DB”,“status”:“Online”,“storagePoolType”:“NON_DEDUPLICATION”,“storageType”:“DISK”},{“capacity”:572204472,“company”:{“id”:0,“name”:“”},“freeSpace”:180975901,“id”:233,“libraryVendorType”:1,“name”:“usilg01-bap051 Infinidat DDEB-FS”,“status”:“Online”,“storagePoolType”:“NON_DEDUPLICATION”,“storageType”:“DISK”}
]
please post a valid json data using tools like https://jsonformatter.org/. Which data point do you want to extract and into what visualization
What error you are getting?
[
{
"capacity": 1511192580,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 624929754,
"id": 75,
"libraryVendorType": 1,
"name": "!usilg01-bbp029_test_restore",
"status": "Online",
"storagePoolType": "DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 402639872,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 285237396,
"id": 163,
"libraryVendorType": 1,
"name": "dpusilg01bad009",
"status": "Online",
"storagePoolType": "SCALE_OUT",
"storageType": "HYPERSCALE"
},
{
"capacity": 1511192580,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 624929754,
"id": 4,
"libraryVendorType": 1,
"name": "dpusilg01bap017",
"status": "Online",
"storagePoolType": "SCALE_OUT",
"storageType": "HYPERSCALE"
},
{
"capacity": 1196360704,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 470208581,
"id": 143,
"libraryVendorType": 1,
"name": "dpusilg01bap040UCS",
"status": "Online",
"storagePoolType": "SCALE_OUT",
"storageType": "HYPERSCALE"
},
{
"capacity": 572204472,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 144903131,
"id": 236,
"libraryVendorType": 1,
"name": "Infinidat DDEA-DB Deduplication usilg01-bap051",
"status": "Online",
"storagePoolType": "DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 572204472,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 180975901,
"id": 238,
"libraryVendorType": 1,
"name": "Infinidat DDEB-FS Deduplication usilg01-bap051",
"status": "Online",
"storagePoolType": "DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 572204472,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 402502467,
"id": 153,
"libraryVendorType": 1,
"name": "InfinidatDDEA-DB",
"status": "Offline (Library has been marked as Disabled.)",
"storagePoolType": "NON_DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 572204472,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 261692444,
"id": 154,
"libraryVendorType": 1,
"name": "InfinidatDDEB-FS",
"status": "Offline (Library has been marked as Disabled.)",
"storagePoolType": "NON_DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 1511192580,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 624929754,
"id": 65,
"libraryVendorType": 1,
"name": "Temp Redgate",
"status": "Online",
"storagePoolType": "NON_DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 18866216,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 13655746,
"id": 98,
"libraryVendorType": 1,
"name": "Urbandale",
"status": "Online",
"storagePoolType": "DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 572204472,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 144963823,
"id": 232,
"libraryVendorType": 1,
"name": "usilg01-bap051 Infinidat DDEA-DB",
"status": "Online",
"storagePoolType": "NON_DEDUPLICATION",
"storageType": "DISK"
},
{
"capacity": 572204472,
"company": {
"id": 0,
"name": ""
},
"freeSpace": 180975901,
"id": 233,
"libraryVendorType": 1,
"name": "usilg01-bap051 Infinidat DDEB-FS",
"status": "Online",
"storagePoolType": "NON_DEDUPLICATION",
"storageType": "DISK"
}
]
I am attempting to get exactly what you posted. When that data is imported it’s just one straight line of data. I have tried transformations to get it organized into a table but it hasn’t worked. The data I need is “Freespace” and “Name”
And I am not receiving any error.
Looks like the json data you posted is not you recieved.. looks like you need to add $.localStorage as root selector/JSONata under the parsing options.
Just noticed what I was doing wrong. This worked! Thanks!