If i disable the Analytic log i can see events in the event viewer and fetch data with Get-WinEvent:
Get-WinEvent -logname Microsoft-Windows-DNSServer/Analytical -Oldest
9/27/2023 11:35:40 AM 261 Information RECURSE_RESPONSE_IN: TCP=0; Source=x.x.x.x; InterfaceIP=0.0.0...
9/27/2023 11:35:40 AM 257 Information RESPONSE_SUCCESS: TCP=0; InterfaceIP=x.x.x.x; Destination=...
9/27/2023 11:35:40 AM 257 Information RESPONSE_SUCCESS: TCP=0; InterfaceIP=x.x.x.x; Destination=...
Also, i am using a centralized config FWIW. ossec.log:
2023/09/27 11:39:08 wazuh-agent: INFO: Windows version is 6.0 or newer. (Microsoft Windows Server 2019 Standard [Ver: ...] - Wazuh v4.5.0).
2023/09/27 11:39:08 wazuh-agent: INFO: (1951): Analyzing event log: 'Application'.
2023/09/27 11:39:08 wazuh-agent: WARNING: (1958): Log file 'C:\LOGS\dnslog.txt' is duplicated.
2023/09/27 11:39:08 wazuh-agent: WARNING: (1958): Log file 'Security' is duplicated.
2023/09/27 11:39:08 wazuh-agent: INFO: (1951): Analyzing event log: 'Microsoft-Windows-DNSServer/Operational'.
2023/09/27 11:39:08 wazuh-agent: ERROR: Could not EvtSubscribe() for (Microsoft-Windows-DNSServer/Operational) which returned (15007)
2023/09/27 11:39:08 wazuh-agent: INFO: (1951): Analyzing event log: 'System'.
2023/09/27 11:39:08 wazuh-agent: INFO: (1950): Analyzing file: 'active-response\active-responses.log'.
2023/09/27 11:39:08 wazuh-agent: INFO: (1951): Analyzing event log: 'C:\LOGS\dnslog.txt'.
2023/09/27 11:39:09 wazuh-agent: INFO: (1951): Analyzing event log: 'Security'.
2023/09/27 11:39:09 wazuh-agent: INFO: (1951): Analyzing event log: 'Microsoft-Windows-DNSServer/Analytical'.
2023/09/27 11:39:09 wazuh-agent: ERROR: Could not EvtSubscribe() for (Microsoft-Windows-DNSServer/Analytical) which returned (15022)
2023/09/27 11:39:09 wazuh-agent: INFO: Started (pid: 488).