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.
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.