Summarizer tables for SEP 11

novadean's picture

Hello,

What summarizer tables does SEP 11 use?  We have reports for SAV that we would like to replicate for SEP.  However, it looks like the queries do not use the same summarizer tables.   I am attempting other tables to try to duplicate the report.  For example, we have a query that displays a chart of Infected computers per hour.  This query uses SYMCMGMT.SUM_60_VIRUSEVENTIDMACHINE table.

Thanks
Dean

Laurent_c's picture

I think you right, they are

I think you right, they are the standard AV summary tables (Generic AV and Firewall) and they are the SAV summary tables. As far as I know they are no dedicated SEP tables.

novadean's picture

 Does Symantec plan on

 Does Symantec plan on integrating SEP with the existing summarizer tables or plan on implementing new summarizer tables for SEP?  It would be nice to display trending queries + reports.  ie having time as the 'X' axis.  It appears the only way to have time as the x-axis is to create advanced SQL queries.

It's a good report for management to show over time how many viruses, threats, etc have been eliminated or if there was an outbreak during a specific period of time.

Thanks!
Dean

MegL's picture

4.7 is what you want

allowing you to do that sort of thing - there is a new option "Top N by field over time" which trends over time the events.