infotechmb 0 Posted September 25, 2020 Share Posted September 25, 2020 Hello I have fiew clients with 15 to 100 computers with ESET v5 and ERA5. It is good and simple software. I install it on MS SQL server and scheduled task run 2 reports in sql and daily send me email: Computer IP Signatures Connected --------------- --------------- ------------------ ----------- -------------------------------------------- Comp1 192.168.001.002 22046 (20200924) 20200925 Comp2 192.168.001.004 22046 (20200924) 20200925 Operation system is not updateted Computer Date --------------- ----------------------- ------------------------ ---------------------------------- -------------------------------------- ------------------------------- Comp1 2020-09-24 19:27:27.000 HTTP filter hxxp://willioninterpr.club/... JS/Adware.Atocari.B aplikacja connection was terminated Comp2 2020-09-24 19:28:29.000 HTTP filter hxxp://www.drhtv.com.pl/... HTML/ScrInject.B koń trojański connection was terminated I think about upgrade to ESMC but simple reports is not accesible. Thay was generated as PDF attachment and without: - LEFT JOIN (list all computers with column "security trouble" if exists) - sorting via regular expression (substring IP adress: 192.168.0.1 192.168.1.2) Direct connection to database as I have in ERA5 it's not good too, because: - database structure is very complicated (separated table tbld_mac_address with 2 fileds: skey and mac_address have any sense?) - functionality computer severity and any problems description not exists in database (only problem number) Maybe ESMC is good product but in my situation upgrade is more complicated. Regards Michal Link to comment Share on other sites More sharing options...
Recommended Posts