Ensure 'Scan encrypted macros in Excel Open XML workbooks' is set to 'Enabled: Scan encrypted macros (default)'

TinggiLevel 1Otomatisintune-office

Deskripsi

This policy setting controls whether encrypted macros in Open XML documents are required to be scanned with anti-virus software before being opened. The recommended state for this setting is: Enabled: Scan encrypted macros (default). Audit: reads the registry value(s) excelbypassencryptedmacroscan that the Intune policy writes for every loaded user profile (HKEY_USERS) and prints compliant only when each satisfies the benchmark value.

Cara pemeriksaan

Metode audit: Registry Windows

registry

$bad = @(); $bad += @(Get-ChildItem Registry::HKEY_USERS | Where-Object { $_.PSChildName -match '^S-1-5-21-\d+-\d+-\d+-\d+$' } | ForEach-Object { $v = (Get-ItemProperty -Path ('Registry::HKEY_USERS\' + $_.PSChildName + '\SOFTWARE\Policies\Microsoft\office\16.0\excel\security') -Name 'excelbypassencryptedmacroscan' -ErrorAction SilentlyContinue).'excelbypassencryptedmacroscan'; if (-not ($null -ne $v -and @(0) -contains [int64]$v)) { $_.PSChildName + ':excelbypassencryptedmacroscan=' + $v } }); if ($bad.Count -eq 0) { 'compliant' } else { 'non-compliant: ' + ($bad -join ', ') }

Output yang diharapkan: compliant

Cara perbaikan

Metode perbaikan: Panduan atau patch infrastruktur

To establish the recommended state via configuration profiles, set the following Settings Catalog path to Enabled: Scan encrypted macros (default). Microsoft Excel 2016\Excel Options\Security\Scan Encrypted Macros in Excel Open XML Workbooks

Properti

Sistem operasi: Apa saja
Tag: intune-officeintuneregistry
Referensi: CIS Microsoft Intune for Office Benchmark v1.1.0 - 2.2.4.7.4 Ensure 'Scan encrypted macros in Excel Open XML workbooks' is set to 'Enabled: Scan encrypted macros (default)'

Periksa host ini

Jalankan ini pada mesin yang diizinkan untuk Anda audit. Pemindaian bersifat hanya baca.

shell

tmaegis scan --target intune-office