1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22
| logparser使用
1、基本查询结构 Logparser.exe –i:EVT –o:DATAGRID "SELECT * FROM 2.evtx" - 接受的数据类型 输出的数据结构 - 最主要关注 --- eventID、strings
2、查询登录成功的事件 登录成功的所有事件: LogParser.exe -i:EVT –o:DATAGRID "SELECT * FROM 2.evtx where EventID=4624 "
远程登录的用户 LogParser.exe -i:EVT -o:DATAGRID "SELECT TimeGenerated, EXTRACT_TOKEN(Strings,0,'|') as User,EXTRACT_TOKEN(Strings,5,'|') as Username,EXTRACT_TOKEN(Strings,18,'|') as IP,EXTRACT_TOKEN(Strings,8,'|') as LogonType FROM 2.evtx WHERE EventID=4624 AND EXTRACT_TOKEN(Strings,8,'|') = '10'"
指定登录时间范围的事件: LogParser.exe -i:EVT–o:DATAGRID "SELECT * FROM c:\Security.evtx where TimeGenerated>'2018-06-19 23:32:11' and TimeGenerated<'2018-06-20 23:34:00' and EventID=4624"
提取登录成功的用户名和IP: LogParser.exe -i:EVT –o:DATAGRID "SELECT EXTRACT_TOKEN(Message,13,' ') as EventType,TimeGenerated as LoginTime,EXTRACT_TOKEN(Strings,5,'|') as Username,EXTRACT_TOKEN(Message,38,' ') as Loginip FROM 2.evtx where EventID=4624"
提取登录失败用户名进行聚合统计: LogParser.exe -i:EVT "SELECT extract_token(strings, 5, '|') as user,count(extract_token(Message,19,' ')) as conuts FROM 2.evtx WHERE eventid = 4625 GROUP BY user"
|