Transpose lines to Column

[felipesodre]

{
  "DbMaintenanceDailyRoutineSummary": {
    "success": [
      {
        "server-002": [
          {
            "vacuum": true,
            "analyze": true,
            "warehouse": "mydatabase@aaaaaa"
          },
          {
            "vacuum": true,
            "analyze": true,
            "warehouse": "mydatabase@bbbbbb"
          }
        ]
      },
      {
        "server-003": [
          {
            "vacuum": true,
            "analyze": true,
            "warehouse": "mydatabase@ccccccc"
          },
          {
            "vacuum": true,
            "analyze": true,
            "warehouse": "mydatabase@ddddddd"
          }
        ]
      }
    ],
    "fail": [
      {
        "server-002": [
          {
            "vacuum": true,
            "analyze": false,
            "warehouse": "mydatabase@eeeeee"
          }
        ]
      },
      {
        "server-003": [
          {
            "vacuum": false,
            "analyze": true,
            "warehouse": "mydatabase@fffffff"
          },
          {
            "vacuum": true,
            "analyze": false,
            "warehouse": "mydatabase@gggggg"
          },
          {
            "vacuum": true,
            "analyze": false,
            "warehouse": "mydatabase@hhhhhh"
          }
        ]
      }
    ]
  }
}

I am wondering how can I convert this result in something like the following message to sent it as a alert by email.

DbMaintenanceDailyRoutineSummary

fail:

server002:

mydatabase@eeeeee:  analyze: false, vacuum: true

server003:

mydatabase@fffffff - analyze: false, vacuum: true

mydatabase@ggggg - analyze: false, vacuum: true

success:

server002:

mydatabase@aaaaaa- analyze: true, vacuum: true

mydatabase@bbbbbb - analyze: true, vacuum: true

server003:

mydatabase@ccccccc  - analyze: false, vacuum: true

mydatabase@dddddd - analyze: false, vacuum: true

[felipesodre · Accepted solution]

Thanks for your help, appreciate it. But the  solution presented is not I would like to have.

I just want to change that part from this:

"vacuum": true,
"analyze": false,
"warehouse": "mydatabase@hhhhhh"

to this:

"warehouse": "mydatabase@hhhhhh", "vacuum": true, "analyze": false
            

[felipesodre]

Thanks.

This is all I need.  Issue fixed.

Appreciate it!

[felipesodre]

Yes it is. Thank you.

[to4kawa]

OK. My answer is not your solution.