çãããããã«ã¡ã¯ïŒ ã®äž
ã¬ããŒãã®äž»ãªç®çã¯ããã°ã«å«ãŸãã倧éã®ããŒã¿ãçµåããå©çšå¯èœãªèšå®ã«åºã¥ããŠãåä¿¡ãããã¹ãŠã®æ å ±ãèªã¿ãããåœ¢åŒ (ã°ã©ããè¡šããã£ãŒãã®åœ¢åŒ) ã§è¡šç€ºããããšã§ãã 以äžã®å³ã¯ãFortiGate ããã€ã¹ã®ããªã€ã³ã¹ããŒã«ãããã¬ããŒãã®ãªã¹ãã瀺ããŠããŸã (ãã¹ãŠã®ã¬ããŒãããã®ãªã¹ãã«åãŸãããã§ã¯ãããŸãããããã®ãªã¹ãã¯ãããã«äœ¿çšããŠãå€ãã®èå³æ·±ã䟿å©ãªã¬ããŒããäœæã§ããããšããã§ã«ç€ºããŠãããšæããŸã)ã
ããããã¬ããŒãã¯èŠæ±ãããæ
å ±ãèªã¿ãããæ¹æ³ã§æ瀺ããã ãã§ãããèŠã€ãã£ãåé¡ã«å¯Ÿãããããªãã¢ã¯ã·ã§ã³ã«é¢ããæšå¥šäºé
ã¯å«ãŸããŠããŸããã
ã¬ããŒãã®äž»ãªã³ã³ããŒãã³ãã¯ã°ã©ãã§ãã åã¬ããŒã㯠XNUMX ã€ä»¥äžã®ã°ã©ãã§æ§æãããŸãã ã°ã©ãã¯ããã°ããã©ã®ãããªæ å ±ãæœåºããå¿ èŠããããããŸããããã©ã®ãããªåœ¢åŒã§è¡šç€ºããå¿ èŠããããã決å®ããŸãã ããŒã¿ã»ããã¯æ å ±ã®æœåºãã€ãŸãããŒã¿ããŒã¹ãžã® SELECT ã¯ãšãªãæ åœããŸãã ã©ãããã©ã®ãããªçš®é¡ã®æ å ±ãæœåºããå¿ èŠããããã¯ãããŒã¿ã»ããå ã§æ£ç¢ºã«æ±ºå®ãããŸãã èŠæ±ã®çµæãšããŠå¿ èŠãªããŒã¿ã衚瀺ããããšããã®ããŒã¿ã«åœ¢åŒ (ãŸãã¯è¡šç€º) èšå®ãé©çšãããŸãã ãã®çµæãåŸãããããŒã¿ã¯ããŸããŸãªçš®é¡ã®è¡šãã°ã©ãããã£ãŒããšããŠäœæãããŸãã
SELECT ã¯ãšãªã¯ãååŸããæ
å ±ã®æ¡ä»¶ãèšå®ããããŸããŸãªã³ãã³ãã䜿çšããŸãã èæ
®ãã¹ãæãéèŠãªããšã¯ããããã®ã³ãã³ãã¯ç¹å®ã®é åº (以äžã«ãªã¹ããããŠããé åº) ã§é©çšããå¿
èŠããããšããããšã§ãã
FROM ã¯ãSELECT ã¯ãšãªã§å¿
èŠãªå¯äžã®ã³ãã³ãã§ãã ããã¯ãæ
å ±ãæœåºããå¿
èŠããããã°ã®ã¿ã€ãã瀺ããŸãã
WHERE - ãã®ã³ãã³ãã䜿çšãããšããã°ã®æ¡ä»¶ãèšå®ãããŸã (ããšãã°ãã¢ããªã±ãŒã·ã§ã³/æ»æ/ãŠã€ã«ã¹ã®ç¹å®ã®åå)ã
GROUP BY - ãã®ã³ãã³ãã䜿çšãããšãé¢å¿ã®ãã XNUMX ã€ä»¥äžã®åããšã«æ
å ±ãã°ã«ãŒãåã§ããŸãã
ORDER BY - ãã®ã³ãã³ãã䜿çšãããšãæ
å ±ã®åºåãè¡ããšã«äžŠã¹æ¿ããããšãã§ããŸãã
LIMIT - ã¯ãšãªã«ãã£ãŠè¿ãããã¬ã³ãŒãã®æ°ãå¶éããŸãã
FortiAnalyzer ã«ã¯ãäºåå®çŸ©ãããã¬ããŒã ãã³ãã¬ãŒããå«ãŸããŠããŸãã ãã³ãã¬ãŒãã¯ããããã¬ããŒã ã¬ã€ã¢ãŠãã§ãããã¬ããŒãã®ããã¹ããã°ã©ãããã¯ããå«ãŸããŠããŸãã äºåå®çŸ©ãããã¬ããŒãã«æå°éã®å€æŽãå¿ èŠãªå Žåã¯ããã³ãã¬ãŒãã䜿çšããŠæ°ããã¬ããŒããäœæã§ããŸãã ãã ããããªã€ã³ã¹ããŒã«ãããã¬ããŒãã¯ç·šéãŸãã¯åé€ã§ããŸãããã¬ããŒãã®ã¯ããŒã³ãäœæãããã®ã³ããŒã«å¿ èŠãªå€æŽãå ããããšãã§ããŸãã ç¬èªã®ã¬ããŒã ãã³ãã¬ãŒããäœæããããšãã§ããŸãã
å Žåã«ãã£ãŠã¯ãäºåå®çŸ©ãããã¬ããŒããã¿ã¹ã¯ã«é©åããŠãããã®ã®ãå®å
šã«ã¯é©åããŠããªããšããç¶æ³ã«ééããããšããããŸãã ãããããæ
å ±ãè¿œå ããããéã«æ
å ±ãåé€ããå¿
èŠããããŸãã ãã®å Žåããã³ãã¬ãŒããè€è£œããŠå€æŽããããã¬ããŒãèªäœãå€æŽãããã® XNUMX ã€ã®ãªãã·ã§ã³ããããŸãã ããã§ã¯ãããã€ãã®èŠå ã«äŸåããå¿
èŠããããŸãã
ãã³ãã¬ãŒãã¯ã¬ããŒãã®ã¬ã€ã¢ãŠãã§ãããããã«ã¯ã°ã©ããšã¬ããŒã ããã¹ããå«ãŸããŸããããã以äžã®ãã®ã¯ãããŸããã ã¬ããŒãèªäœã«ã¯ããããããã¬ã€ã¢ãŠããã«å ããŠãèšèªããã©ã³ããããã¹ãã®è²ãçææéãæ å ±ãã£ã«ã¿ãªã³ã°ãªã©ã®ããŸããŸãªã¬ããŒã ãã©ã¡ãŒã¿ãå«ãŸããŠããŸãã ãããã£ãŠãã¬ããŒãã®ã¬ã€ã¢ãŠããå€æŽããã ãã®å Žåã¯ããã³ãã¬ãŒãã䜿çšã§ããŸãã è¿œå ã®ã¬ããŒãæ§æãå¿ èŠãªå Žåã¯ãã¬ããŒãèªäœ (ããæ£ç¢ºã«ã¯ãã®ã³ããŒ) ãç·šéã§ããŸãã
ãã³ãã¬ãŒãã«åºã¥ããŠåãã¿ã€ãã®ã¬ããŒããè€æ°äœæã§ãããããé¡äŒŒããã¬ããŒããå€æ°äœæããå¿
èŠãããå Žåã¯ããã³ãã¬ãŒãã䜿çšããããšããå§ãããŸãã
ããªã€ã³ã¹ããŒã«ããããã³ãã¬ãŒããšã¬ããŒããåããªãå Žåã¯ãæ°ãããã³ãã¬ãŒããšæ°ããã¬ããŒãã®äž¡æ¹ãäœæã§ããŸãã
ãŸããFortiAnalyzer ã§ã¯ãã¬ããŒããå管çè
ã«é»åã¡ãŒã«ã§éä¿¡ããããå€éšãµãŒããŒã«ã¢ããããŒããããããããã«èšå®ã§ããŸãã ããã¯ãåºåãããã¡ã€ã« ã¡ã«ããºã ã䜿çšããŠè¡ãããŸãã åå¥ã®åºåãããã¡ã€ã«ãå管çãã¡ã€ã³ã«èšå®ãããŸãã åºåãããã¡ã€ã«ãæ§æããå Žåã次ã®ãã©ã¡ãŒã¿ãå®çŸ©ãããŸãã
- éä¿¡ãããã¬ããŒãã®åœ¢åŒ - PDFãHTMLãXMLããŸã㯠CSVã
- ã¬ããŒããéä¿¡ãããå Žæã ããã¯ç®¡çè ã®é»åã¡ãŒã«ã«ããããšãã§ããŸã (ãã®ããã«ã¯ãFortiAnalyzer ãã¡ãŒã« ãµãŒããŒã«ãã€ã³ãããå¿ èŠããããŸããããã«ã€ããŠã¯ååã®ã¬ãã¹ã³ã§èª¬æããŸãã)ã å€éšãã¡ã€ã« ãµãŒã㌠(FTPãSFTPãSCP) ã«ããããšãã§ããŸãã
- 転éåŸã«ããã€ã¹ã«æ®ãããŒã«ã« ã¬ããŒããä¿æãããåé€ããããéžæã§ããŸãã
å¿
èŠã«å¿ããŠãã¬ããŒãã®çæãé«éåããããšãã§ããŸãã XNUMX ã€ã®æ¹æ³ãèããŠã¿ãŸãããã
ã¬ããŒããçæãããšããFortiAnalyzer 㯠hcache ãšåŒã°ããããªã³ã³ãã€ã«ããã SQL ãã£ãã·ã¥ ããŒã¿ããã°ã©ããæ§ç¯ããŸãã ã¬ããŒãã®å®è¡æã« hcache ããŒã¿ãäœæãããªãå Žåãã·ã¹ãã ã¯ãŸã hcache ãäœæããŠããã¬ããŒããæ§ç¯ããå¿
èŠããããŸãã ããã«ãããã¬ããŒãã®çææéãå¢å ããŸãã ãã ããã¬ããŒãã®æ°ãããã°ãåä¿¡ããªãå Žåãã¬ããŒããåçæãããšãã«ãhcache ããŒã¿ããã§ã«ã³ã³ãã€ã«ãããŠãããããçæã«ãããæéã倧å¹
ã«ççž®ãããŸãã
ã¬ããŒãçæã®ããã©ãŒãã³ã¹ãåäžãããããã«ãã¬ããŒãèšå®ã§ hcache ã®èªåçæãæå¹ã«ããããšãã§ããŸãã ãã®å Žåãhcache ã¯æ°ãããã°ãå°çãããšèªåçã«æŽæ°ãããŸãã èšå®äŸãäžå³ã«ç€ºããŸãã
ãã®ããã»ã¹ã¯å€§éã®ã·ã¹ãã ãªãœãŒã¹ã䜿çšãããã (ç¹ã«ããŒã¿ã®åéã«é·æéãå¿ èŠãšããã¬ããŒãã®å Žå)ããã®ããã»ã¹ããªã³ã«ããåŸãFortiAnalyzer ã®ã¹ããŒã¿ã¹ãç£èŠããå¿ èŠããããŸããè² è·ãå€§å¹ ã«å¢å ãããã©ãããé倧ãªåé¡ãçºçããŠããªããã©ãããªã©ã§ããã·ã¹ãã ãªãœãŒã¹ã®æ¶è²»ã FortiAnalyzer ãè² è·ã«å¯Ÿå¿ã§ããªãå Žåã¯ããã®ããã»ã¹ãç¡å¹ã«ããããšããå§ãããŸãã
ãŸããã¹ã±ãžã¥ãŒã«ãããã¬ããŒãã§ã¯ãhcache ããŒã¿ã®èªåæŽæ°ãããã©ã«ãã§æå¹ã«ãªã£ãŠããããšã«æ³šæããŠãã ããã
ã¬ããŒãçæãé«éåãã XNUMX çªç®ã®æ¹æ³ã¯ãã°ã«ãŒãåã§ãã
ç°ãªã FortiGate (ãŸãã¯ä»ã® Fortinet) ããã€ã¹ã«å¯ŸããŠåã (ãŸãã¯é¡äŒŒãã) ã¬ããŒããçæãããŠããå Žåãããããã°ã«ãŒãåããããšã§çæããã»ã¹ã倧å¹
ã«é«éåã§ããŸãã ã¬ããŒããã°ã«ãŒãåãããšãhcache ããŒãã«ã®æ°ãæžããèªåãã£ãã·ã¥æéãççž®ãããã¬ããŒãã®çæãé«éåãããŸãã
次ã®å³ã«ç€ºãäŸã§ã¯ãååã«æåå Security_Report ãå«ãŸããã¬ããŒããããã€ã¹ ID ãã©ã¡ãŒã¿ã«ãã£ãŠã°ã«ãŒãåãããŠããŸãã
ãã®ãã㪠ãã¥ãŒããªã¢ã«ã§ã¯ãäžã§èª¬æããçè«çãªå
容ã«å ããç¬èªã®ããŒã¿ã»ãããã°ã©ãããã³ãã¬ãŒããã¬ããŒãã®äœæãã管çè
ãžã®ã¬ããŒãã®éä¿¡èšå®ãŸã§ãã¬ããŒãã®æäœã«é¢ããå®è·µçãªåŽé¢ã玹ä»ããŸãã èŠãã®ã楜ããïŒ
次ã®ã¬ãã¹ã³ã§ã¯ãFortiAnalyzer ã®ç®¡çãšãã®ã©ã€ã»ã³ã¹ ã¹ããŒã ã®ããŸããŸãªåŽé¢ãèŠãŠãããŸãã èŠéããªãããã«ã賌èªããŠãã ãã
次ã®ãªãœãŒã¹ã®æŽæ°æ å ±ããã©ããŒããããšãã§ããŸãã
åºæïŒ habr.com