I have the following JSON:
I need to extract the size (key "2") of each db (key "1").
I can't seem to understand how to do that in JSONPath.
Please advise...
Thank you in advance!
Amit.
Code:
[
{},
{
"1": "DB1",
"2": " 13.94 MB",
"3": "NT AUTHORITY\\SYSTEM",
"4": "8",
"5": "Feb 19 2020",
"6": "Status=ONLINE",
"7": " Updateability=READ_WRITE",
"8": " UserAccess=MULTI_USER",
"9": " Recovery=FULL",
"10": " Version=869",
"11": " Collation=SQL_Latin1_General_CP1_CI_AS",
"12": " SQLSortOrder=52",
"13": " IsAutoCreateStatistics",
"14": " IsAutoUpdateStatistics",
"15": " IsFullTextEnabled",
"16": "140"
},
{
"1": "B2",
"2": " 6.00 MB",
"3": "NT AUTHORITY\\SYSTEM",
"4": "7",
"5": "Feb 19 2020",
"6": "Status=ONLINE",
"7": " Updateability=READ_WRITE",
"8": " UserAccess=MULTI_USER",
"9": " Recovery=FULL",
"10": " Version=869",
"11": " Collation=SQL_Latin1_General_CP1_CI_AS",
"12": " SQLSortOrder=52",
"13": " IsAutoCreateStatistics",
"14": " IsAutoUpdateStatistics",
"15": " IsFullTextEnabled",
"16": "140"
},
{
"1": "DB3",
"2": " 3836.19 MB",
"3": "NT AUTHORITY\\SYSTEM",
"4": "12",
"5": "Feb 19 2020",
"6": "Status=ONLINE",
"7": " Updateability=READ_WRITE",
"8": " UserAccess=MULTI_USER",
"9": " Recovery=FULL",
"10": " Version=869",
"11": " Collation=SQL_Latin1_General_CP1_CI_AS",
"12": " SQLSortOrder=52",
"13": " IsAutoCreateStatistics",
"14": " IsAutoUpdateStatistics",
"15": " IsFullTextEnabled",
"16": "140"
}
]
I can't seem to understand how to do that in JSONPath.
Please advise...
Thank you in advance!
Amit.