How can we improve Azure Log Analytics ?

Azure Security Center Recommendations Log Analytics Query syntax

Could someone point me in the direction of a resource that provides a mapping of the recommendations in Security Center (SC) with the associated Log Analytics query syntax? For example SC lists all of the machines that are not compliant with the recommendations in list below. I need to extract these results out into a spreadsheet and cannot see how to do this other than maybe running a query in Log analytics? If so does anyone know of a listing of these queries?

Designate more than one owner on your subscription (Preview)
Enable MFA for accounts with owner permissions on your subscription (Preview)
Endpoint Protection not installed on Azure VMs
Enable Auditing on SQL servers
Apply a Just-In-Time network access control
Enable Auditing on SQL databases
Apply system updates
Apply disk encryption
CORS should not allow every resource to access your Web Application (Preview)
Configure IP restrictions for Web Application (Preview)
Enable MFA for accounts with write permissions on your subscription (Preview)
Web Application should only be accessible over HTTPS (Preview)
Web Sockets should be disabled for Web Application (Preview)
Restrict access through Internet facing endpoint
Add a vulnerability assessment solution
Enable Transparent Data Encryption
Reboot after system updates
Enable MFA for accounts with read permissions on your subscription (Preview)
Remove deprecated accounts from your subscription (Preview)
Remove external accounts with read permissions from your subscription (Preview)
Use custom domains for Web Application (Preview)
Use the latest supported PHP version for Web Application (Preview)
Remediate security configurations

8 votes
Sign in
Sign in with: Microsoft
Signed in as (Sign out)
You have left! (?) (thinking…)
Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →


Sign in
Sign in with: Microsoft
Signed in as (Sign out)

Feedback and Knowledge Base