Formatting of Get-FalconVulnerability command #92
-
|
When I get the Spotlight Vulnerability reports directly from the Falcon Console, I see all of the fields. When I get them using PSFalcon's Get-FalconVulnerability command, a number of the fields are grouped into JSONs. The following is an example of 3 fields. The following is the line of code I am using: I have attach a sample of the report from PS Falcon, the code I am using, and a sample of the report from the Falcon Console. How do I get the data from Get-FalconVulnerability to look like the Falcon Console report? |
Beta Was this translation helpful? Give feedback.
Replies: 2 comments
-
|
If you can cut/paste plaintext examples into your issue it is easier for me to review them. The "grouping" of the field data is due to Have you seen Export-FalconReport? I created that command to make it easier to export to CSV. It does filter out some fields, but I tried to select what seemed like the relevant data from each request type. Try this and see if it works for you: |
Beta Was this translation helpful? Give feedback.
-
|
This worked perfectly.
Thank you!
|
Beta Was this translation helpful? Give feedback.
If you can cut/paste plaintext examples into your issue it is easier for me to review them.
The "grouping" of the field data is due to
Export-Csvattempting to convert those fields into a string value. This behavior isn't restricted to PSFalcon or the Spotlight APIs--it's how PowerShell works when you try toExport-Csv.Have you seen Export-FalconReport? I created that command to make it easier to export to CSV. It does filter out some fields, but I tried to select what seemed like the relevant data from each request type.
Try this and see if it works for you: