23 Feb 2023 11:10 PM - last edited on 24 Feb 2023 08:08 AM by MaciejNeumann
Hi Team
Just wanted to ask if there is a way we can get a exported report of all the Vulnerabilities in Dynatrace again the Host Name?
24 Feb 2023 02:55 AM
Hey sumitlut,
You can export all vulnerabilities through the API and in the request filter by host name. This is documented here: Security problems API - GET all problems | Dynatrace Docs
Hope this helps!
28 Feb 2023 03:56 AM
Hi Fin_Ubels,
Thanks for the reply. I have created the API access token, but unable to find the correct parameter to apply the filter for all the problems against the hostname. If you have any insight on that that would be really appreciated.
28 Feb 2023 04:35 AM
Hey sumitlut,
On that API documentation page it details the problem selector syntax. Having a look through there are 3 filters which would likely work well for you. Best to try it out in the API tester in the tenant as its super easy to change parameters on the fly and test all of this.
02 Mar 2023 01:43 AM
Thanks a lot for the reply @Fin_Ubels. After testing and playing around those parameters, I have reached only to a level where I can create 1 excel for each hostName with all the vulnerabilities. But it seems like I cannot create just one excel sheet with added extra property (column) of hostNames along with all the vulnerabilities.
02 Mar 2023 03:55 AM
Sorry I'm not too familiar with importing JSON into excel to create a report but by using the relatedHostNames parameter you can specify multiple hostnames and it should export all of them. Good luck!