Query: detect Detects instances where an MSSQL service on an OpenCanary node has had a login attempt using Windows Authentication. in logs
Matching passage: Sigma rule: Detects instances where an MSSQL service on an OpenCanary node has had a login attempt using Windows Authentication.. Logsource: opencanary / application. Rule: title: OpenCanary - MSSQL Login Attempt Via Windows Authentication id: 6e78f90f-0043-4a01-ac41-f97681613a66 status: test description: 'Detects instances where an MSSQL service on an OpenCanary node has had a login attempt using Windows Authentication. ' references: - https://opencanary.readthedocs.io/en/latest/starting/configuration.html#services-configuration - https://github.com/thinkst/opencanary/blob/a0896adfcaf0328cfd5829fe10d2878c7445138e/opencanary/logger.py#L52 author: Security Onion Solutions date: 2024-03-08 tags: - attack.credential-access - attack.collection - attack.t1003 - attack.t1213 logsource: category: application product: opencanary detection: selection: logtype: 9002 condition: selection falsepositives: - Unlikely level: high
Near-miss passage: Sigma rule: Detects DNS queries for IP lookup services such as "api.ipify.org" originating from a non browser process.. Logsource: windows / dns_query. Rule: title: Suspicious DNS Query for IP Lookup Service APIs id: ec82e2a5-81ea-4211-a1f8-37a0286df2c2 status: test description: Detects DNS queries for IP lookup services such as "api.ipify.org" originating from a non browser process. references: - https://www.binarydefense.com/analysis-of-hancitor-when-boring-begets-beacon - https://twitter.com/neonprimetime/status/1436376497980428318 - https://www.trendmicro.com/en_us/research/23/e/managed-xdr-investigation-of-ducktail-in-trend-micro-vision-one.html author: Brandon George (blog post), Thomas Patzke date: 2021-07-08 modified: 2024-03-22 tags: - attack.reconnaissance - attack.t1590 logsource: product: windows category: dns_query detection: selection: - QueryName: - www.ip.cn - l2.io - QueryName|contains: - api.2ip.ua - api.bigdatacloud.net - api.ipify.org - bot.whatismyipaddress.com - canireachthe.net - checkip.amazonaws.com - checkip.dyndns.org - curlmyip.com - db-ip.com - edns.ip-api.com - eth0.me - freegeoip.app - geoipy.com - getip.pro - icanhazip.com - ident.me - ifconfig.io - ifconfig.me - ip-api.com - ip.360.cn - ip.anysrc.net - ip.taobao.com - ip.tyk.nu - ipaddressworld.com - ipapi.co - ipconfig.io - ipecho.net - ipinfo.io - ipip.net - ipof.in - ipv4.icanhazip.com - ipv4bot.whatismyipaddress.com - ipv6-test.com - ipwho.is - jsonip.com - myexternalip.com - seeip.org - wgetip.com - whatismyip.akamai.com - whois.pconline.com.cn - wtfismyip.com filter_optional_brave: Image|endswith: \brave.exe filter_optional_chrome: Image: - C:\Program Files\Google\Chrome\Application\chrome.exe - C:\Program Files (x86)\Google\Chrome\Application\chrome.exe filter_optional_firefox: Image: - C:\Program Files\Mozilla Firefox\firefox.exe - C:\Program Files (x86)\Mozilla Firefox\firefox.exe filter_optional_ie: Image: - C:\Program Files (x86)\Internet Explorer\iexplore.exe - C:\Program Files\Internet Explorer\iexplore.exe filter_optional_maxthon: Image|endswith: \maxthon.exe filter_optional_edge_1: - Image|startswith: C:\Program Files (x86)\Microsoft\EdgeWebView\Application\ - Image|endswith: \WindowsApps\MicrosoftEdge.exe - Image: - C:\Program Files (x86)\Microsoft\Edge\Application\msedge.exe - C:\Program Files\Microsoft\Edge\Application\msedge.exe filter_optional_edge_2: Image|startswith: - C:\Program Files (x86)\Microsoft\EdgeCore\ - C:\Program Files\Microsoft\EdgeCore\ Image|endswith: - \msedge.exe - \msedgewebview2.exe filter_optional_opera: Image|endswith: \opera.exe filter_optional_safari: Image|endswith: \safari.exe filter