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