cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 
Highlighted
Level 10
Report Inappropriate Content
Message 1 of 2

Content Security Reporter - Top Web Applications

When we run the report from Content Security Reporter for 'Top Web Applications' no results are returned

The query is

select top 10 sum( cast( [csr_fct_web].[hits] as bigint ) ) as 'csr_fct_web.hits.sum', [csr_dim_site_request].[application], [csr_dim_site_request].[application] from [csr_fct_web] left join [csr_dim_site_request] on [csr_fct_web].[site_request_id] = [csr_dim_site_request].[site_request_id] where ( [csr_dim_site_request].[application] != '-') group by [csr_dim_site_request].[application] order by 'csr_fct_web.hits.sum' desc, [csr_dim_site_request].[application] asc
 
Any ideas?
1 Reply
Highlighted
McAfee Employee
McAfee Employee
Report Inappropriate Content
Message 2 of 2

Re: Content Security Reporter - Top Web Applications

Hi,

I ran the same query on my local lab which took 16 min to complete.

​In your case, I believe the issue is since it doesn't have a specific filter, it will try to get the result of all which may take more time.

​This depends on the DB size.

To rectify this,

  1. Please do regular indexing
  2. If you are using an external DB, please do DB partitioning

​To understand more, we would need the information of DB size, DB partition, data retention period, indexing and statistics run.

Please raise a Support Ticket in-case the above Points doesn't help.

 

Regards,

Shibani

You Deserve an Award
Don't forget, when your helpful posts earn a kudos or get accepted as a solution you can unlock perks and badges. Those aren't the only badges, either. How many can you collect? Click here to learn more.

Community Help Hub

    New to the forums or need help finding your way around the forums? There's a whole hub of community resources to help you.

  • Find Forum FAQs
  • Learn How to Earn Badges
  • Ask for Help
Go to Community Help

Join the Community

    Thousands of customers use the McAfee Community for peer-to-peer and expert product support. Enjoy these benefits with a free membership:

  • Get helpful solutions from McAfee experts.
  • Stay connected to product conversations that matter to you.
  • Participate in product groups led by McAfee employees.
Join the Community
Join the Community