Content Security Reporter - Top Web Applications

[jround]

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?

[SMEDHI]

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