rule win_tabmsgsql_auto {

    meta:
        author = "Felix Bilstein - yara-signator at cocacoding dot com"
        date = "2023-07-11"
        version = "1"
        description = "Detects win.tabmsgsql."
        info = "autogenerated rule brought to you by yara-signator"
        tool = "yara-signator v0.6.0"
        signator_config = "callsandjumps;datarefs;binvalue"
        malpedia_reference = "https://malpedia.caad.fkie.fraunhofer.de/details/win.tabmsgsql"
        malpedia_rule_date = "20230705"
        malpedia_hash = "42d0574f4405bd7d2b154d321d345acb18834a41"
        malpedia_version = "20230715"
        malpedia_license = "CC BY-SA 4.0"
        malpedia_sharing = "TLP:WHITE"

    /* DISCLAIMER
     * The strings used in this rule have been automatically selected from the
     * disassembly of memory dumps and unpacked files, using YARA-Signator.
     * The code and documentation is published here:
     * https://github.com/fxb-cocacoding/yara-signator
     * As Malpedia is used as data source, please note that for a given
     * number of families, only single samples are documented.
     * This likely impacts the degree of generalization these rules will offer.
     * Take the described generation method also into consideration when you
     * apply the rules in your use cases and assign them confidence levels.
     */


    strings:
        $sequence_0 = { 64892500000000 81ec18020000 53 56 57 33db b97f000000 }
            // n = 7, score = 100
            //   64892500000000       | mov                 dword ptr fs:[0], esp
            //   81ec18020000         | sub                 esp, 0x218
            //   53                   | push                ebx
            //   56                   | push                esi
            //   57                   | push                edi
            //   33db                 | xor                 ebx, ebx
            //   b97f000000           | mov                 ecx, 0x7f

        $sequence_1 = { 0f84fb000000 83faff 0f84f2000000 bf???????? 83c9ff 33c0 }
            // n = 6, score = 100
            //   0f84fb000000         | je                  0x101
            //   83faff               | cmp                 edx, -1
            //   0f84f2000000         | je                  0xf8
            //   bf????????           |                     
            //   83c9ff               | or                  ecx, 0xffffffff
            //   33c0                 | xor                 eax, eax

        $sequence_2 = { 5f 5e 5d 5b 7421 8b8424f8f40100 }
            // n = 6, score = 100
            //   5f                   | pop                 edi
            //   5e                   | pop                 esi
            //   5d                   | pop                 ebp
            //   5b                   | pop                 ebx
            //   7421                 | je                  0x23
            //   8b8424f8f40100       | mov                 eax, dword ptr [esp + 0x1f4f8]

        $sequence_3 = { 3bfa 7536 fec8 8841ff 895304 }
            // n = 5, score = 100
            //   3bfa                 | cmp                 edi, edx
            //   7536                 | jne                 0x38
            //   fec8                 | dec                 al
            //   8841ff               | mov                 byte ptr [ecx - 1], al
            //   895304               | mov                 dword ptr [ebx + 4], edx

        $sequence_4 = { 83d8ff 85c0 741b 57 8d442414 68???????? 50 }
            // n = 7, score = 100
            //   83d8ff               | sbb                 eax, -1
            //   85c0                 | test                eax, eax
            //   741b                 | je                  0x1d
            //   57                   | push                edi
            //   8d442414             | lea                 eax, [esp + 0x14]
            //   68????????           |                     
            //   50                   | push                eax

        $sequence_5 = { 8d45dc 68???????? 50 8d8dc8f7ffff 68???????? 51 ffd6 }
            // n = 7, score = 100
            //   8d45dc               | lea                 eax, [ebp - 0x24]
            //   68????????           |                     
            //   50                   | push                eax
            //   8d8dc8f7ffff         | lea                 ecx, [ebp - 0x838]
            //   68????????           |                     
            //   51                   | push                ecx
            //   ffd6                 | call                esi

        $sequence_6 = { 33c0 83c424 f2ae f7d1 49 5f 81f9a0860100 }
            // n = 7, score = 100
            //   33c0                 | xor                 eax, eax
            //   83c424               | add                 esp, 0x24
            //   f2ae                 | repne scasb         al, byte ptr es:[edi]
            //   f7d1                 | not                 ecx
            //   49                   | dec                 ecx
            //   5f                   | pop                 edi
            //   81f9a0860100         | cmp                 ecx, 0x186a0

        $sequence_7 = { 6a00 8d55dc 6a00 52 8d85940bfeff }
            // n = 5, score = 100
            //   6a00                 | push                0
            //   8d55dc               | lea                 edx, [ebp - 0x24]
            //   6a00                 | push                0
            //   52                   | push                edx
            //   8d85940bfeff         | lea                 eax, [ebp - 0x1f46c]

        $sequence_8 = { 50 51 6a00 ff15???????? 85c0 7430 8d7c241c }
            // n = 7, score = 100
            //   50                   | push                eax
            //   51                   | push                ecx
            //   6a00                 | push                0
            //   ff15????????         |                     
            //   85c0                 | test                eax, eax
            //   7430                 | je                  0x32
            //   8d7c241c             | lea                 edi, [esp + 0x1c]

        $sequence_9 = { 33c0 68???????? f2ae f7d1 2bf9 8d442434 8bd1 }
            // n = 7, score = 100
            //   33c0                 | xor                 eax, eax
            //   68????????           |                     
            //   f2ae                 | repne scasb         al, byte ptr es:[edi]
            //   f7d1                 | not                 ecx
            //   2bf9                 | sub                 edi, ecx
            //   8d442434             | lea                 eax, [esp + 0x34]
            //   8bd1                 | mov                 edx, ecx

    condition:
        7 of them and filesize < 163840
}