cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

McAfee Web Reporter DB Data Dictionary

Where can I get McAfee Web Reporter DB Data Dictionary? I would like to get information directly from DB.

Thanks


Rubén

1 Reply
Highlighted

Re: McAfee Web Reporter DB Data Dictionary

scr_fct_web = summary data

scr_fct_exact_access = detail data

scr_dim_XXXX = dimension tables of what the name suggests, for example, scr_dim_user has all the user names, and scr_dim_site has a list of all (web) site names.

the detail data has data dated by epoch time. For example, 8AM, March 2, 2012 CST is 1330675200 in epoch time.

the summary data has the date split into days since epoch and hour of day.  For example, 8AM, March 2, 2012 is day 15401 since epoch.

Mapping the site to one of the two data tables is done through the scr_dim_site_request table.  For example, to find summary records for www.mcafee.com on March 2, 2012.

SELECT

     scr_fct_web.*, scr_dim_site.site_name

FROM

     scr_fct_web scr_fct_web,

     scr_dim_site_request scr_dim_site_request,

     scr_dim_site scr_dim_site

WHERE

     scr_fct_web.site_request_id = scr_dim_site_request.site_request_id

     AND scr_dim_site_request.site_id = scr_dim_site.site_id

     AND scr_dim_site.site_name = 'www.mcafee.com'

     AND scr_fct_web.days_since_epoch = 15401

Hopefully that helps.

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