Read value from variable after converting from JSON

Hi,

I'm developing my first scripts to read data from Defender 365 Hunting queries and then use those values to be stored on a variable and sent over by email for some reports.

For example, now I've got the result from a query, which after parsing the JSON with the command:

$vulnData = $vulnResponse.Content | ConvertFrom-Json

Then, I've got this on $vulnData variable:

email address removed for privacy reasons Count
---------------- -----
#Int64 100

How can I extract the number to a variable?

Thanks

Windows PowerShell

Harm_Veenstra
Jan 05, 2023
😁 The .Count method does a count and that's one. Perhaps putting 's around it would help?

4 Replies

Harm_Veenstra
MVP
Jan 04, 2023
$vulnData.Count should give you 100. You can set it to another variable if needed by using $number=$vulnData.Count
- dmarquesgn
  Iron Contributor
  Jan 05, 2023
  Harm_Veenstra
  Hi,
  That was what I was expecting, but in fact when I do a $vulnData.Count I get a value of 1, instead of the value which is contained.
  Am I missing something obvious here?
  - Harm_Veenstra
    MVP
    Jan 05, 2023
    😁 The .Count method does a count and that's one. Perhaps putting 's around it would help?

Forum Discussion

Read value from variable after converting from JSON

4 Replies

Resources