Debian Codegraph @

hub1/.tests/mssql-text-logs/parser.assert

raw
1 len(results) == 4
2 len(results["s00-raw"]["crowdsecurity/non-syslog"]) == 14
3 results["s00-raw"]["crowdsecurity/non-syslog"][0].Success == true
4 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Parsed["message"] == "2022-12-20 12:36:54.17 Logon Error: 18456, Severity: 14, State: 8."
5 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Parsed["program"] == "mssql"
6 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
7 results["s00-raw"]["crowdsecurity/non-syslog"][0].Evt.Meta["datasource_type"] == "file"
8 results["s00-raw"]["crowdsecurity/non-syslog"][1].Success == true
9 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Parsed["message"] == "2022-12-20 12:36:54.17 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
10 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Parsed["program"] == "mssql"
11 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
12 results["s00-raw"]["crowdsecurity/non-syslog"][1].Evt.Meta["datasource_type"] == "file"
13 results["s00-raw"]["crowdsecurity/non-syslog"][2].Success == true
14 results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Parsed["message"] == "2022-12-20 12:36:56.29 Logon Error: 18456, Severity: 14, State: 8."
15 results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Parsed["program"] == "mssql"
16 results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
17 results["s00-raw"]["crowdsecurity/non-syslog"][2].Evt.Meta["datasource_type"] == "file"
18 results["s00-raw"]["crowdsecurity/non-syslog"][3].Success == true
19 results["s00-raw"]["crowdsecurity/non-syslog"][3].Evt.Parsed["message"] == "2022-12-20 12:36:56.29 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
20 results["s00-raw"]["crowdsecurity/non-syslog"][3].Evt.Parsed["program"] == "mssql"
21 results["s00-raw"]["crowdsecurity/non-syslog"][3].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
22 results["s00-raw"]["crowdsecurity/non-syslog"][3].Evt.Meta["datasource_type"] == "file"
23 results["s00-raw"]["crowdsecurity/non-syslog"][4].Success == true
24 results["s00-raw"]["crowdsecurity/non-syslog"][4].Evt.Parsed["message"] == "2022-12-20 12:36:56.83 Logon Error: 18456, Severity: 14, State: 8."
25 results["s00-raw"]["crowdsecurity/non-syslog"][4].Evt.Parsed["program"] == "mssql"
26 results["s00-raw"]["crowdsecurity/non-syslog"][4].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
27 results["s00-raw"]["crowdsecurity/non-syslog"][4].Evt.Meta["datasource_type"] == "file"
28 results["s00-raw"]["crowdsecurity/non-syslog"][5].Success == true
29 results["s00-raw"]["crowdsecurity/non-syslog"][5].Evt.Parsed["message"] == "2022-12-20 12:36:56.83 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
30 results["s00-raw"]["crowdsecurity/non-syslog"][5].Evt.Parsed["program"] == "mssql"
31 results["s00-raw"]["crowdsecurity/non-syslog"][5].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
32 results["s00-raw"]["crowdsecurity/non-syslog"][5].Evt.Meta["datasource_type"] == "file"
33 results["s00-raw"]["crowdsecurity/non-syslog"][6].Success == true
34 results["s00-raw"]["crowdsecurity/non-syslog"][6].Evt.Parsed["program"] == "mssql"
35 results["s00-raw"]["crowdsecurity/non-syslog"][6].Evt.Parsed["message"] == "2022-12-20 12:36:57.23 Logon Error: 18456, Severity: 14, State: 8."
36 results["s00-raw"]["crowdsecurity/non-syslog"][6].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
37 results["s00-raw"]["crowdsecurity/non-syslog"][6].Evt.Meta["datasource_type"] == "file"
38 results["s00-raw"]["crowdsecurity/non-syslog"][7].Success == true
39 results["s00-raw"]["crowdsecurity/non-syslog"][7].Evt.Parsed["program"] == "mssql"
40 results["s00-raw"]["crowdsecurity/non-syslog"][7].Evt.Parsed["message"] == "2022-12-20 12:36:57.23 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
41 results["s00-raw"]["crowdsecurity/non-syslog"][7].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
42 results["s00-raw"]["crowdsecurity/non-syslog"][7].Evt.Meta["datasource_type"] == "file"
43 results["s00-raw"]["crowdsecurity/non-syslog"][8].Success == true
44 results["s00-raw"]["crowdsecurity/non-syslog"][8].Evt.Parsed["program"] == "mssql"
45 results["s00-raw"]["crowdsecurity/non-syslog"][8].Evt.Parsed["message"] == "2022-12-20 12:36:57.59 Logon Error: 18456, Severity: 14, State: 8."
46 results["s00-raw"]["crowdsecurity/non-syslog"][8].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
47 results["s00-raw"]["crowdsecurity/non-syslog"][8].Evt.Meta["datasource_type"] == "file"
48 results["s00-raw"]["crowdsecurity/non-syslog"][9].Success == true
49 results["s00-raw"]["crowdsecurity/non-syslog"][9].Evt.Parsed["message"] == "2022-12-20 12:36:57.59 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
50 results["s00-raw"]["crowdsecurity/non-syslog"][9].Evt.Parsed["program"] == "mssql"
51 results["s00-raw"]["crowdsecurity/non-syslog"][9].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
52 results["s00-raw"]["crowdsecurity/non-syslog"][9].Evt.Meta["datasource_type"] == "file"
53 results["s00-raw"]["crowdsecurity/non-syslog"][10].Success == true
54 results["s00-raw"]["crowdsecurity/non-syslog"][10].Evt.Parsed["message"] == "2022-12-20 12:36:57.94 Logon Error: 18456, Severity: 14, State: 8."
55 results["s00-raw"]["crowdsecurity/non-syslog"][10].Evt.Parsed["program"] == "mssql"
56 results["s00-raw"]["crowdsecurity/non-syslog"][10].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
57 results["s00-raw"]["crowdsecurity/non-syslog"][10].Evt.Meta["datasource_type"] == "file"
58 results["s00-raw"]["crowdsecurity/non-syslog"][11].Success == true
59 results["s00-raw"]["crowdsecurity/non-syslog"][11].Evt.Parsed["message"] == "2022-12-20 12:36:57.94 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
60 results["s00-raw"]["crowdsecurity/non-syslog"][11].Evt.Parsed["program"] == "mssql"
61 results["s00-raw"]["crowdsecurity/non-syslog"][11].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
62 results["s00-raw"]["crowdsecurity/non-syslog"][11].Evt.Meta["datasource_type"] == "file"
63 results["s00-raw"]["crowdsecurity/non-syslog"][12].Success == true
64 results["s00-raw"]["crowdsecurity/non-syslog"][12].Evt.Parsed["message"] == "2022-12-20 12:37:15.23 Logon Error: 18456, Severity: 14, State: 5."
65 results["s00-raw"]["crowdsecurity/non-syslog"][12].Evt.Parsed["program"] == "mssql"
66 results["s00-raw"]["crowdsecurity/non-syslog"][12].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
67 results["s00-raw"]["crowdsecurity/non-syslog"][12].Evt.Meta["datasource_type"] == "file"
68 results["s00-raw"]["crowdsecurity/non-syslog"][13].Success == true
69 results["s00-raw"]["crowdsecurity/non-syslog"][13].Evt.Parsed["message"] == "2022-12-20 12:37:15.23 Logon Login failed for user 'ROOT'. Reason: Could not find a login matching the name provided. [CLIENT: 172.17.0.3]"
70 results["s00-raw"]["crowdsecurity/non-syslog"][13].Evt.Parsed["program"] == "mssql"
71 results["s00-raw"]["crowdsecurity/non-syslog"][13].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
72 results["s00-raw"]["crowdsecurity/non-syslog"][13].Evt.Meta["datasource_type"] == "file"
73 len(results["s00-raw"]["crowdsecurity/syslog-logs"]) == 14
74 results["s00-raw"]["crowdsecurity/syslog-logs"][0].Success == false
75 results["s00-raw"]["crowdsecurity/syslog-logs"][1].Success == false
76 results["s00-raw"]["crowdsecurity/syslog-logs"][2].Success == false
77 results["s00-raw"]["crowdsecurity/syslog-logs"][3].Success == false
78 results["s00-raw"]["crowdsecurity/syslog-logs"][4].Success == false
79 results["s00-raw"]["crowdsecurity/syslog-logs"][5].Success == false
80 results["s00-raw"]["crowdsecurity/syslog-logs"][6].Success == false
81 results["s00-raw"]["crowdsecurity/syslog-logs"][7].Success == false
82 results["s00-raw"]["crowdsecurity/syslog-logs"][8].Success == false
83 results["s00-raw"]["crowdsecurity/syslog-logs"][9].Success == false
84 results["s00-raw"]["crowdsecurity/syslog-logs"][10].Success == false
85 results["s00-raw"]["crowdsecurity/syslog-logs"][11].Success == false
86 results["s00-raw"]["crowdsecurity/syslog-logs"][12].Success == false
87 results["s00-raw"]["crowdsecurity/syslog-logs"][13].Success == false
88 len(results["s01-parse"]["crowdsecurity/mssql-logs"]) == 14
89 results["s01-parse"]["crowdsecurity/mssql-logs"][0].Success == false
90 results["s01-parse"]["crowdsecurity/mssql-logs"][1].Success == false
91 results["s01-parse"]["crowdsecurity/mssql-logs"][2].Success == false
92 results["s01-parse"]["crowdsecurity/mssql-logs"][3].Success == false
93 results["s01-parse"]["crowdsecurity/mssql-logs"][4].Success == false
94 results["s01-parse"]["crowdsecurity/mssql-logs"][5].Success == false
95 results["s01-parse"]["crowdsecurity/mssql-logs"][6].Success == false
96 results["s01-parse"]["crowdsecurity/mssql-logs"][7].Success == false
97 results["s01-parse"]["crowdsecurity/mssql-logs"][8].Success == false
98 results["s01-parse"]["crowdsecurity/mssql-logs"][9].Success == false
99 results["s01-parse"]["crowdsecurity/mssql-logs"][10].Success == false
100 results["s01-parse"]["crowdsecurity/mssql-logs"][11].Success == false
101 results["s01-parse"]["crowdsecurity/mssql-logs"][12].Success == false
102 results["s01-parse"]["crowdsecurity/mssql-logs"][13].Success == false
103 len(results["s01-parse"]["crowdsecurity/mssql-text-logs"]) == 14
104 results["s01-parse"]["crowdsecurity/mssql-text-logs"][0].Success == false
105 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Success == true
106 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["day"] == "20"
107 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["month"] == "12"
108 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["time"] == "12:36:54.17"
109 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["user"] == "SA"
110 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["year"] == "2022"
111 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["date"] == "2022-12-20"
112 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["message"] == "2022-12-20 12:36:54.17 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
113 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["program"] == "mssql"
114 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
115 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Parsed["source_ip"] == "172.17.0.3"
116 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
117 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Meta["datasource_type"] == "file"
118 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Meta["service"] == "mssql"
119 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Meta["source_ip"] == "172.17.0.3"
120 results["s01-parse"]["crowdsecurity/mssql-text-logs"][1].Evt.Meta["subtype"] == "bad_password"
121 results["s01-parse"]["crowdsecurity/mssql-text-logs"][2].Success == false
122 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Success == true
123 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["day"] == "20"
124 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["month"] == "12"
125 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["time"] == "12:36:56.29"
126 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["year"] == "2022"
127 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["source_ip"] == "172.17.0.3"
128 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["user"] == "SA"
129 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["date"] == "2022-12-20"
130 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["message"] == "2022-12-20 12:36:56.29 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
131 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["program"] == "mssql"
132 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
133 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Meta["service"] == "mssql"
134 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Meta["source_ip"] == "172.17.0.3"
135 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Meta["subtype"] == "bad_password"
136 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
137 results["s01-parse"]["crowdsecurity/mssql-text-logs"][3].Evt.Meta["datasource_type"] == "file"
138 results["s01-parse"]["crowdsecurity/mssql-text-logs"][4].Success == false
139 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Success == true
140 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["user"] == "SA"
141 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["date"] == "2022-12-20"
142 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["program"] == "mssql"
143 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["time"] == "12:36:56.83"
144 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
145 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["source_ip"] == "172.17.0.3"
146 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["year"] == "2022"
147 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["day"] == "20"
148 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["message"] == "2022-12-20 12:36:56.83 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
149 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Parsed["month"] == "12"
150 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Meta["datasource_type"] == "file"
151 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Meta["service"] == "mssql"
152 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Meta["source_ip"] == "172.17.0.3"
153 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Meta["subtype"] == "bad_password"
154 results["s01-parse"]["crowdsecurity/mssql-text-logs"][5].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
155 results["s01-parse"]["crowdsecurity/mssql-text-logs"][6].Success == false
156 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Success == true
157 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["message"] == "2022-12-20 12:36:57.23 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
158 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["month"] == "12"
159 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["user"] == "SA"
160 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["year"] == "2022"
161 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["date"] == "2022-12-20"
162 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["day"] == "20"
163 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["program"] == "mssql"
164 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
165 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["source_ip"] == "172.17.0.3"
166 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Parsed["time"] == "12:36:57.23"
167 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Meta["source_ip"] == "172.17.0.3"
168 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Meta["subtype"] == "bad_password"
169 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
170 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Meta["datasource_type"] == "file"
171 results["s01-parse"]["crowdsecurity/mssql-text-logs"][7].Evt.Meta["service"] == "mssql"
172 results["s01-parse"]["crowdsecurity/mssql-text-logs"][8].Success == false
173 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Success == true
174 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["date"] == "2022-12-20"
175 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["user"] == "SA"
176 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["year"] == "2022"
177 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
178 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["source_ip"] == "172.17.0.3"
179 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["time"] == "12:36:57.59"
180 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["day"] == "20"
181 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["message"] == "2022-12-20 12:36:57.59 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
182 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["month"] == "12"
183 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Parsed["program"] == "mssql"
184 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
185 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Meta["datasource_type"] == "file"
186 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Meta["service"] == "mssql"
187 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Meta["source_ip"] == "172.17.0.3"
188 results["s01-parse"]["crowdsecurity/mssql-text-logs"][9].Evt.Meta["subtype"] == "bad_password"
189 results["s01-parse"]["crowdsecurity/mssql-text-logs"][10].Success == false
190 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Success == true
191 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["year"] == "2022"
192 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["date"] == "2022-12-20"
193 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["message"] == "2022-12-20 12:36:57.94 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
194 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
195 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["source_ip"] == "172.17.0.3"
196 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["time"] == "12:36:57.94"
197 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["day"] == "20"
198 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["month"] == "12"
199 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["program"] == "mssql"
200 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Parsed["user"] == "SA"
201 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Meta["datasource_type"] == "file"
202 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Meta["service"] == "mssql"
203 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Meta["source_ip"] == "172.17.0.3"
204 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Meta["subtype"] == "bad_password"
205 results["s01-parse"]["crowdsecurity/mssql-text-logs"][11].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
206 results["s01-parse"]["crowdsecurity/mssql-text-logs"][12].Success == false
207 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Success == true
208 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["user"] == "ROOT"
209 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["year"] == "2022"
210 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["date"] == "2022-12-20"
211 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["day"] == "20"
212 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["month"] == "12"
213 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["program"] == "mssql"
214 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["reason_message"] == "Could not find a login matching the name provided"
215 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["source_ip"] == "172.17.0.3"
216 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["message"] == "2022-12-20 12:37:15.23 Logon Login failed for user 'ROOT'. Reason: Could not find a login matching the name provided. [CLIENT: 172.17.0.3]"
217 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Parsed["time"] == "12:37:15.23"
218 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Meta["datasource_type"] == "file"
219 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Meta["service"] == "mssql"
220 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Meta["source_ip"] == "172.17.0.3"
221 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Meta["subtype"] == "bad_user"
222 results["s01-parse"]["crowdsecurity/mssql-text-logs"][13].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
223 len(results["s02-enrich"]["crowdsecurity/dateparse-enrich"]) == 7
224 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Success == true
225 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["day"] == "20"
226 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
227 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["time"] == "12:36:54.17"
228 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["user"] == "SA"
229 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["year"] == "2022"
230 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["date"] == "2022-12-20"
231 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["message"] == "2022-12-20 12:36:54.17 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
232 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["month"] == "12"
233 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["program"] == "mssql"
234 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Parsed["source_ip"] == "172.17.0.3"
235 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
236 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Meta["datasource_type"] == "file"
237 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Meta["service"] == "mssql"
238 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Meta["source_ip"] == "172.17.0.3"
239 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Meta["subtype"] == "bad_password"
240 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Meta["timestamp"] == "2022-12-20T12:36:54.17Z"
241 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][0].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:36:54.17Z"
242 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Success == true
243 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["date"] == "2022-12-20"
244 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["message"] == "2022-12-20 12:36:56.29 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
245 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
246 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["source_ip"] == "172.17.0.3"
247 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["year"] == "2022"
248 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["day"] == "20"
249 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["month"] == "12"
250 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["program"] == "mssql"
251 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["time"] == "12:36:56.29"
252 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Parsed["user"] == "SA"
253 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Meta["datasource_type"] == "file"
254 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Meta["service"] == "mssql"
255 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Meta["source_ip"] == "172.17.0.3"
256 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Meta["subtype"] == "bad_password"
257 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Meta["timestamp"] == "2022-12-20T12:36:56.29Z"
258 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
259 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][1].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:36:56.29Z"
260 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Success == true
261 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["time"] == "12:36:56.83"
262 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["user"] == "SA"
263 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["date"] == "2022-12-20"
264 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["day"] == "20"
265 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["message"] == "2022-12-20 12:36:56.83 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
266 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["program"] == "mssql"
267 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["month"] == "12"
268 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
269 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["source_ip"] == "172.17.0.3"
270 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Parsed["year"] == "2022"
271 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
272 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Meta["datasource_type"] == "file"
273 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Meta["service"] == "mssql"
274 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Meta["source_ip"] == "172.17.0.3"
275 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Meta["subtype"] == "bad_password"
276 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Meta["timestamp"] == "2022-12-20T12:36:56.83Z"
277 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][2].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:36:56.83Z"
278 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Success == true
279 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["message"] == "2022-12-20 12:36:57.23 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
280 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["program"] == "mssql"
281 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
282 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["time"] == "12:36:57.23"
283 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["date"] == "2022-12-20"
284 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["day"] == "20"
285 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["user"] == "SA"
286 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["year"] == "2022"
287 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["month"] == "12"
288 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Parsed["source_ip"] == "172.17.0.3"
289 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Meta["timestamp"] == "2022-12-20T12:36:57.23Z"
290 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
291 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Meta["datasource_type"] == "file"
292 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Meta["service"] == "mssql"
293 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Meta["source_ip"] == "172.17.0.3"
294 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Meta["subtype"] == "bad_password"
295 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][3].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:36:57.23Z"
296 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Success == true
297 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["day"] == "20"
298 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["message"] == "2022-12-20 12:36:57.59 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
299 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["time"] == "12:36:57.59"
300 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["user"] == "SA"
301 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["source_ip"] == "172.17.0.3"
302 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["year"] == "2022"
303 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["date"] == "2022-12-20"
304 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["month"] == "12"
305 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["program"] == "mssql"
306 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
307 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
308 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Meta["datasource_type"] == "file"
309 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Meta["service"] == "mssql"
310 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Meta["source_ip"] == "172.17.0.3"
311 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Meta["subtype"] == "bad_password"
312 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Meta["timestamp"] == "2022-12-20T12:36:57.59Z"
313 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][4].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:36:57.59Z"
314 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Success == true
315 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["date"] == "2022-12-20"
316 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["message"] == "2022-12-20 12:36:57.94 Logon Login failed for user 'SA'. Reason: Password did not match that for the login provided. [CLIENT: 172.17.0.3]"
317 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["program"] == "mssql"
318 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["reason_message"] == "Password did not match that for the login provided"
319 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["year"] == "2022"
320 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["day"] == "20"
321 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["month"] == "12"
322 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["source_ip"] == "172.17.0.3"
323 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["time"] == "12:36:57.94"
324 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Parsed["user"] == "SA"
325 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Meta["service"] == "mssql"
326 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Meta["source_ip"] == "172.17.0.3"
327 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Meta["subtype"] == "bad_password"
328 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Meta["timestamp"] == "2022-12-20T12:36:57.94Z"
329 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
330 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Meta["datasource_type"] == "file"
331 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][5].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:36:57.94Z"
332 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Success == true
333 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["year"] == "2022"
334 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["date"] == "2022-12-20"
335 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["month"] == "12"
336 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["reason_message"] == "Could not find a login matching the name provided"
337 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["time"] == "12:37:15.23"
338 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["user"] == "ROOT"
339 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["day"] == "20"
340 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["message"] == "2022-12-20 12:37:15.23 Logon Login failed for user 'ROOT'. Reason: Could not find a login matching the name provided. [CLIENT: 172.17.0.3]"
341 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["program"] == "mssql"
342 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Parsed["source_ip"] == "172.17.0.3"
343 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Meta["datasource_path"] == "mssql-text-logs.log"
344 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Meta["datasource_type"] == "file"
345 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Meta["service"] == "mssql"
346 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Meta["source_ip"] == "172.17.0.3"
347 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Meta["subtype"] == "bad_user"
348 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Meta["timestamp"] == "2022-12-20T12:37:15.23Z"
349 results["s02-enrich"]["crowdsecurity/dateparse-enrich"][6].Evt.Enriched["MarshaledTime"] == "2022-12-20T12:37:15.23Z"
350 len(results["success"][""]) == 0