ThinkChat2.0新版上线,更智能更精彩,支持会话、画图、阅读、搜索等,送10W Token,即刻开启你的AI之旅 广告
命令中的{0}代表源日志文件的路径,实际运行的时候请替换为真实路径 命令中的{1}代表日志导出到的文件的路径,实际运行的时候请替换为真实路径 例如: ~~~ 7i24iislog.exe -i:BIN -o:W3C "select siteid,uristem,bytessent from 'd:\iislog\w3svc\sss.ibl' to 'd:\a.log' order by bytessent desc" ~~~ 1、查询某IP访问某网站的某网页的次数,倒序排列 ~~~ 7i24iislog.exe -i:BIN -o:W3C "select clientipaddress,siteid,uristem,count(clientipaddress) from '{0}' to '{1}' group by clientipaddress,uristem,siteid order by count(clientipaddress) desc" ~~~ 2、某IP访问整个服务器网站的次数 ~~~ 7i24iislog.exe -i:BIN -o:W3C "select clientipaddress,count(clientipaddress) from '{0}' to '{1}' group by clientipaddress order by count(clientipaddress) desc" ~~~ 3、按照接收数据(用户上传)大小排列 ~~~ 7i24iislog.exe -i:BIN -o:W3C "select siteid,uristem,bytesreceived from '{0}' to '{1}' order by bytesreceived desc" ~~~ 4、按照发送数据(用户下载)大小排列 ~~~ 7i24iislog.exe -i:BIN -o:W3C "select siteid,uristem,bytessent from '{0}' to '{1}' order by bytessent desc" ~~~ 5、检测PHP发包 ~~~ 7i24iislog.exe -i:BIN -o:W3C "select siteid,uristem,uriquery from '{0}' to '{1}' where uriquery like '%port=%' and uriquery like '%ip=%'" ~~~