Hello,
I am trying to format the following event into a data table that just shows me the last data point (top hit) of a property that contains several objects in one property that is an array.
Here is the JSON:
"Win32_quickfixengineering": [
{
"HotFixID": "KB4489192",
"InstalledOn": "4/12/2019",
"InstalledBy": "NT AUTHORITY\\SYSTEM",
"Description": "Update"
},
{
"HotFixID": "KB4480056",
"InstalledOn": "4/22/2019",
"InstalledBy": "NT AUTHORITY\\SYSTEM",
"Description": "Update"
},
{
"HotFixID": "KB4493478",
"InstalledOn": "4/12/2019",
"InstalledBy": "NT AUTHORITY\\SYSTEM",
"Description": "Security Update"
},
{
"HotFixID": "KB4493510",
"InstalledOn": "4/12/2019",
"InstalledBy": "NT AUTHORITY\\SYSTEM",
"Description": "Security Update"
},
{
"HotFixID": "KB4493509",
"InstalledOn": "4/12/2019",
"InstalledBy": "NT AUTHORITY\\SYSTEM",
"Description": "Security Update"
}
]
},
I have tried several things, but I can't quite get it right:
I want to mimic this data table:
Can someone please help?
Thanks