# Nested JSON is confusing me

**URL:** <https://discuss.elastic.co/t/nested-json-is-confusing-me/232480>\
**Category:** Logstash\
**Created:** [May 13, 2020, 4:40pm UTC](https://discuss.elastic.co/t/nested-json-is-confusing-me/232480 "2020-05-13T16:40:58Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![BlueTeamNinja](https://sea2.discourse-cdn.com/elastic/user_avatar/discuss.elastic.co/blueteamninja/32/63639_2.png) [@BlueTeamNinja](https://discuss.elastic.co/u/BlueTeamNinja)\
**Post date:** [May 13, 2020, 4:40pm UTC](https://discuss.elastic.co/t/nested-json-is-confusing-me/232480/1 "2020-05-13T16:40:59Z")

</div>

I have the exact same problem in two places and I can't quite figure it out. I think I need an ELI5.  
I have a JSON structure coming from a giant hodge-podge of Powershell scripts that are pulling in local computer information.

The two that are evading me, are monitors and Network Adapters. They both stay JSON in Elastic/Kibana without being parsed. The rest of the message is fine. I _think_ it is because they don't have a 'key' name but I suck at this stuff.

Example JSON:

```auto
    {
      "WindowsCurrentVersion": "6.3",
      "WindowsEditionId": "Enterprise",
      "CsNetworkAdapters": [
        {
          "Description": "Intel(R) Ethernet Connection (2) I219-V",
          "ConnectionID": "Ethernet",
          "DHCPEnabled": true,
          "DHCPServer": "10.10.10.10",
          "ConnectionStatus": 2,
          "IPAddresses": [
            "10.10.10.55",
            "fe50::aaaa:aaa:44a:aa9"
          ]
        }
      ],
      "CsNumberOfLogicalProcessors": 4,
      "CsNumberOfProcessors": 1,
      "Monitors": {
        "value": [
          {
            "Vendor": "Lenovo",
            "Model": "T24i-10",
            "Serial": "AB123450"
          },
          {
            "Vendor": "Lenovo",
            "Model": "T24i-10",
            "Serial": "AB123450"
          }
        ],
        "Count": 2
      },
      "LastUser": "CORP.LOCAL\\REALLYBIGABE",
      "PublicIP": "5.5.5.5"
    }

```

How can I get the Monitors values (up to 4) and Network Interfaces (up to a zillion on Hyper-V and VMware hosts) to parse properly into Types and Subtypes? My early investigations had me put them in a JSON Tree viewer and I can see that the subtypes don't have a name per se (they show up as 0), so I probably need to add that or specify a key.

Anyone much smarter than me have any suggestions? Basically I want to be able to search for Monitor Serial Numbers or IPV4 and IPV6 addresses. I can adjust the source data too, if I knew what to adjust it to.

Thanks

---

<div class="post-metadata">

**Author:** ![system](https://us1.discourse-cdn.com/elastic/original/3X/1/a/1ac57faf039f6b580b3f104ef42a2a89e41014de.png) [@system](https://discuss.elastic.co/u/system)\
**Post date:** [June 10, 2020, 4:41pm UTC](https://discuss.elastic.co/t/nested-json-is-confusing-me/232480/2 "2020-06-10T16:41:07Z")

</div>

This topic was automatically closed 28 days after the last reply. New replies are no longer allowed.
