搜尋此網誌

2016/10/12

[RedHat]CVE Database

https://access.redhat.com/security/security-updates/#/

2016/10/11

[bash]將資料夾內全部檔案做md5並輸出成檔案

find -type f -exec md5sum "{}" + > checklist.chk

[excel]IP2LONG語法

將ip轉成整數後比對範圍,比字串比對效率高的多,看到有網站說明如何轉換的語法,還有sql的語法
http://vcert.blogspot.tw/2013/04/ip2long-and-long2ip-in-excel.html

EXCEL:
=MID(D1,1,FIND("|",SUBSTITUTE(D1,".","|",1))-1)*2^24+MID(D1,FIND("|",SUBSTITUTE(D1,".","|",1))+1,FIND("|",SUBSTITUTE(D1,".","|",2))-FIND("|",SUBSTITUTE(D1,".","|",1))-1)*2^16+MID(D1,FIND("|",SUBSTITUTE(D1,".","|",2))+1,FIND("|",SUBSTITUTE(D1,".","|",3))-FIND("|",SUBSTITUTE(D1,".","|",2))-1)*2^8+MID(D1,FIND("|",SUBSTITUTE(D1,".","|",3))+1,4)