cancel
Showing results for 
Search instead for 
Did you mean: 
hazwan
Level 7

Time being rounded in Content Security Reporter

Jump to solution

Hi Guys,

After integrate CSR with McAfee Web Gateway, we are able to generate report. However the format of all time inside date and time column were rounded. As example, I noticed from Top Web Categories by Bandwidth Consumption -> Personal Network Storage export data into xml as below :


The column of Date and time property = csr_fct_web.datetime_hour_round.

All the time format being rounded as picture above. This is not what we want because we cant determine when the users access the site. How do we achieve to get the exact time to show our report is meaningful? Below are the time stamp in the logs.

Thank You.

Regards,

Hazwan

0 Kudos
1 Solution

Accepted Solutions
McAfee Employee

Re: Time being rounded in Content Security Reporter

Jump to solution

Hi Hazwan,

CSR has two tables in the database, the summary table (csr_fct_web) and the detailed table (csr_fct_exact_access). You must be running a summary report rather than a detailed report which is why you see the rounded times.

Best Regards,

Jon

0 Kudos
1 Reply
McAfee Employee

Re: Time being rounded in Content Security Reporter

Jump to solution

Hi Hazwan,

CSR has two tables in the database, the summary table (csr_fct_web) and the detailed table (csr_fct_exact_access). You must be running a summary report rather than a detailed report which is why you see the rounded times.

Best Regards,

Jon

0 Kudos