Query: write Sigma for Detects when an attacker calls the "ALTER SERVER AUDIT" or "DROP SERVER AUDIT" transaction in order to delete or disable
Matching passage: Sigma rule: Detects when an attacker calls the "ALTER SERVER AUDIT" or "DROP SERVER AUDIT" transaction in order to delete or disable. Logsource: windows / application. Rule: title: MSSQL Disable Audit Settings id: 350dfb37-3706-4cdc-9e2e-5e24bc3a46df status: test description: Detects when an attacker calls the "ALTER SERVER AUDIT" or "DROP SERVER AUDIT" transaction in order to delete or disable audit logs on the server references: - https://www.netspi.com/blog/technical/network-penetration-testing/sql-server-persistence-part-1-startup-stored-procedures/ - https://learn.microsoft.com/en-us/sql/t-sql/statements/drop-server-audit-transact-sql?view=sql-server-ver16 - https://learn.microsoft.com/en-us/sql/t-sql/statements/alter-server-audit-transact-sql?view=sql-server-ver16 author: Nasreddine Bencherchali (Nextron Systems) date: 2022-07-13 modified: 2024-06-26 tags: - attack.defense-impairment logsource: product: windows service: application definition: 'Requirements: MSSQL audit policy must be enabled in order to receive this event in the application log' detection: selection: Provider_Name|contains: MSSQL EventID: 33205 Data|contains: - statement:ALTER SERVER AUDIT - statement:DROP SERVER AUDIT condition: selection falsepositives: - This event should only fire when an administrator is modifying the audit policy. Which should be a rare occurrence once it's set up level: high
Near-miss passage: Sigma rule: Detects potential registry persistence technique using the Event Viewer "Events.asp" technique. Logsource: windows / registry_set. Rule: title: Potential Persistence Via Event Viewer Events.asp id: a1e11042-a74a-46e6-b07c-c4ce8ecc239b status: test description: Detects potential registry persistence technique using the Event Viewer "Events.asp" technique references: - https://twitter.com/nas_bench/status/1626648985824788480 - https://admx.help/?Category=Windows_7_2008R2&Policy=Microsoft.Policies.InternetCommunicationManagement::EventViewer_DisableLinks - https://www.hexacorn.com/blog/2019/02/15/beyond-good-ol-run-key-part-103/ - https://github.com/redcanaryco/atomic-red-team/blob/f296668303c29d3f4c07e42bdd2b28d8dd6625f9/atomics/T1112/T1112.md author: Nasreddine Bencherchali (Nextron Systems) date: 2023-02-17 modified: 2023-03-05 tags: - attack.persistence - attack.defense-impairment - attack.t1112 logsource: category: registry_set product: windows detection: selection: TargetObject|contains: - \Microsoft\Windows NT\CurrentVersion\Event Viewer\MicrosoftRedirectionProgram - \Microsoft\Windows NT\CurrentVersion\Event Viewer\MicrosoftRedirectionURL filter_default_redirect_program: Image|endswith: C:\WINDOWS\system32\svchost.exe TargetObject|endswith: \Microsoft\Windows NT\CurrentVersion\Event Viewer\MicrosoftRedirectionProgram Details: '%%SystemRoot%%\PCHealth\HelpCtr\Binaries\HelpCtr.exe' filter_default_redirect_program_cli: Image|endswith: C:\WINDOWS\system32\svchost.exe TargetObject|endswith: \Microsoft\Windows NT\CurrentVersion\Event Viewer\MicrosoftRedirectionProgramCommandLineParameters Details: -url hcp://services/centers/support?topic=%%s filter_url: Details: http://go.microsoft.com/fwlink/events.asp filter_cleaner: Details: (Empty) condition: selection and not 1 of filter_* falsepositives: - Unknown level: medium