Sentinel: Top 10 reports does not work

  • 3010082
  • 29-Jan-2007
  • 26-Apr-2012

Environment

Microsoft Windows Server 2003 Standard Edition
Microsoft Windows 2000 Server
RedHat Linux
Solaris 9

Situation

Why don't the top 10 reports return data?

Resolution

Please note, for the following to work, make sure that aggregation is turned on.

Please go to SDM =>Reporting Data tab=>activate all summary services by clicking on Status column for each row. Keep it running.
After a couple of hours the aggregation should be done and data for your report should be populated. To make sure the data is populated in the DB, please run the following queries:

select count(*) from dbo.EVT_DEST_EVT_NAME_SMRY_1_RPT_V
select count(*) from dbo.EVT_DEST_SMRY_1_RPT_V
select count(*) from dbo.EVT_DEST_EVT_NAME_SMRY_1_RPT_V
select count(*) from dbo.EVT_DEST_TXNMY_SMRY_1_RPT_V
select count(*) from dbo.EVT_PORT_SMRY_1_RPT_V
select count(*) from dbo.EVT_SEV_SMRY_1_RPT_V

If you have data returned from the query against DB, you should have data in your reports.