Forum Discussion
How to Automatically Export Microsoft Defender Security Recommendations with Historical Tracking
Hi Tammy,
Have you checked out the https://github.com/microsoft/MicrosoftDefenderForEndpoint-PowerBI/blob/master/TVM/TVM%20report%20templates%20June%202021/vulnerabilities_report_V6_full_dataset.pbit .
We discovered these a few months ago, these helped us build a PowerBI page that has a daily scheduled sync, we've connected it to an exported/synced software list in an Excel workbook to help us keep track of sanctioned software.
Your idea of using Azure SQL Tables is great—it's scalable and should work smoothly with Power BI.Cheers and Good luck.
Notes: To get a full list of software we use this source https://api.securitycenter.microsoft.com/api/software .Just a heads-up: users with Security Reader roles may only see software with CPE identifiers. Elevated permissions help access the full dataset.
Cheers,
Keith
Hi Tammy,
Have you checked out the https://github.com/microsoft/MicrosoftDefenderForEndpoint-PowerBI/blob/master/TVM/TVM%20report%20templates%20June%202021/vulnerabilities_report_V6_full_dataset.pbit .
We discovered these a few months ago, these helped us build a PowerBI page that has a daily scheduled sync, we've connected it to an exported/synced software list in an Excel workbook to help us keep track of sanctioned software.
Your idea of using Azure SQL Tables is great—it's scalable and should work smoothly with Power BI.
Cheers and Good luck.
Notes: To get a full list of software we use this source https://api.securitycenter.microsoft.com/api/software .
Just a heads-up: users with Security Reader roles may only see software with CPE identifiers. Elevated permissions help access the full dataset.
Cheers,
Keith