title: Powershell with JSON nested objects - cannot get to a property of property of object
body: <p>I'm quite new to Powershell and currently I'm trying to convert some data from JSON I downloaded from Solr.</p>
  <p>The JSON file looks like:</p>
  <pre><code>{
   &quot;responseHeader&quot;: {&quot;status&quot;:0, &quot;QTime&quot;:2651},
  &quot;InitFailures&quot;:{}, 
  &quot;status&quot;:{
     &quot;YX_SERVER.ONE_LOG.2020-11-07_07_49_33&quot;: {
           &quot;name&quot;:&quot;SERVER.ONE_LOG.2020-11-07_07_49_33&quot;,
              &quot;index&quot;:{
                 &quot;sizeInBytes&quot;:69,
                  &quot;size&quot;:&quot;69 bytes&quot;}},
   &quot;XY_SERVER.TWO_LOG.2020-11-08_09_52_11&quot;: {
           &quot;name&quot;:&quot;XY_SERVER.TWO_LOG.2020-11-08_09_52_11&quot;,
              &quot;index&quot;:{
                 &quot;sizeInBytes&quot;:6487,
                      &quot;size&quot;:&quot;6487 bytes&quot;}},
   &quot;ZX_SERVER.THREE_LOG.2020-10-07_07_42_23&quot;: {
           &quot;name&quot;:&quot;SERVER.THREE_LOG.2020-10-07_07_42_23&quot;,
              &quot;index&quot;:{
                 &quot;sizeInBytes&quot;:6977,
                 &quot;size&quot;:&quot;6977 bytes&quot;
                                }}}}
  </code></pre>
  <p>Below the second status line is the list of the servers with numerous parameters(all names are different), I tried to go deeper into it, but need help with nested data.</p>
  <p>I tried the following:</p>
  <pre><code>$list = Get-Content C:\Users\User\Download\cores.json - Raw |convertfrom-json |select-object -ExpandProperty status
  </code></pre>
  <p>Then $list shows me the list of servers and the data needed is in the right column but I cannot access it directly. How can I build the table and calculate the sum just like follows:</p>
  <pre><code>Name                                     Size(inbytes) 
  YX_SERVER.ONE_LOG.2020-11-07_07_49_33    69
  XY_SERVER.TWO_LOG.2020-11-08_09_52_11    6487
  ZX_SERVER.THREE_LOG.2020-10-07_07_42_23  6977
  
  Summary                                  Total size
                                           ?
  </code></pre>