Extract data from JSON only specific fields

Questions
1

Hi I have this data below and would like to extract only the NETBIOS and RESULTS, I have tried extracting and looking for CODE but I keep failing I am sure I doing wrong please can you guide me or help with what I need to extract the data:

This will run for over 1000 Line what I trying to get is the netbios name associted to results, that is computer with the folder patch

[
{
“HOST_LIST_VM_DETECTION_OUTPUT”:
{
“RESPONSE”:
{
“DATETIME”:
“2023-01-13T21:53:47Z”,
“HOST_LIST”:
{
“HOST”:
[
{
“ID”:
“hpst id1”,
“IP”:
“in IP”,
“TRACKING_METHOD”:
“AGENT”,
“OS”:
“Windows 10 Pro 64 bit Edition Version 21H2”,
“DNS”:
“dns”,
“DNS_DATA”:
{
“HOSTNAME”:
“hostname”,
“DOMAIN”:
“domain”,
“FQDN”:
“full domain”
},
“NETBIOS”:
“comname”,
“QG_HOSTID”:
“id”,
“LAST_SCAN_DATETIME”:
“2023-01-13T20:35:17Z”,
“LAST_VM_SCANNED_DATE”:
“2023-01-13T19:59:14Z”,
“LAST_VM_AUTH_SCANNED_DATE”:
“2023-01-13T19:59:14Z”,
“DETECTION_LIST”:
{
“DETECTION”:
[
{
“QID”:
“00000”,
“TYPE”:
“Confirmed”,
“SEVERITY”:
“4”,
“SSL”:
“0”,
“RESULTS”:
“%systemdrive%\Users\name\AppData\Roaming\software\bin\software.exe Version is 5.11.1.6602”,
“STATUS”:
“Active”,
“FIRST_FOUND_DATETIME”:
“2022-11-01T18:41:47Z”,
“LAST_FOUND_DATETIME”:
“2023-01-13T19:59:14Z”,
“TIMES_FOUND”:
“381”,
“LAST_TEST_DATETIME”:
“2023-01-13T19:59:14Z”,
“LAST_UPDATE_DATETIME”:
“2023-01-13T20:35:17Z”,
“LAST_FIXED_DATETIME”:
“2023-01-11T11:36:17Z”,
“IS_IGNORED”:
“0”,
“IS_DISABLED”:
“0”,
“LAST_PROCESSED_DATETIME”:
“2023-01-13T20:35:17Z”
},
{
“QID”:
“00000”,
“TYPE”:
“Confirmed”,
“SEVERITY”:
“2”,
“SSL”:
“0”,
“RESULTS”:
“%systemdrive%\Users\name\AppData\Roaming\software\bin\software.exe Version is 5.11.1.6602”,
“STATUS”:
“Active”,
“FIRST_FOUND_DATETIME”:
“2022-11-14T23:17:49Z”,
“LAST_FOUND_DATETIME”:
“2023-01-13T19:59:14Z”,
“TIMES_FOUND”:
“309”,
“LAST_TEST_DATETIME”:
“2023-01-13T19:59:14Z”,
“LAST_UPDATE_DATETIME”:
“2023-01-13T20:35:17Z”,
“LAST_FIXED_DATETIME”:
“2023-01-11T11:36:17Z”,
“IS_IGNORED”:
“0”,
“IS_DISABLED”:
“0”,
“LAST_PROCESSED_DATETIME”:
“2023-01-13T20:35:17Z”
}
]
}
},

2

This what I have tried so far and no luck

const jsonInput = JSON.parse(input);
const hostList = jsonInput[‘HOST_LIST_VM_DETECTION_OUTPUT’][‘RESPONSE’][‘HOST_LIST’][‘HOST’];
const endResult = [];
hostList.forEach((host) => {
endResult.push({
“IP”: host[“IP”],
“NETBIOS”: host[“NETBIOS”],
“RESULTS”: host[“DETECTION_LIST”][“DETECTION”][0][“RESULTS”]
});
});

return endResult;

ReferenceError: input is not defined
3

I fixed it myself please makr it resloved

1 Like