cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
hazwan
Level 8
Report Inappropriate Content
Message 1 of 2

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

1 Solution

Accepted Solutions
McAfee Employee jscholte
McAfee Employee
Report Inappropriate Content
Message 2 of 2

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

View solution in original post

1 Reply
McAfee Employee jscholte
McAfee Employee
Report Inappropriate Content
Message 2 of 2

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

View solution in original post

More McAfee Tools to Help You
  • Subscription Service Notification (SNS)
  • How-to: Endpoint Removal Tool
  • Support: Endpoint Security
  • eSupport: Policy Orchestrator
  • 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