Web Reporter Custom Report

[voldog]

Needing help with the format of a custom report within Web Reporter 5.2; see attached document that shows the format I am striving for. I have the report where it segments by department and then list the top 10 users under each department along with the sites they have visited (as shown below). However, I need further segmentation; noted in attached document. Can any one provide guidance or recommend article? Or can the web console not perform what I am trying to complete and I must go through backend database via SQL statements?

Department 1

user1     site     date/time      avg browse time

user2     site     date/time      avg browse time

user3     site     date/time      avg browse time

user4     site     date/time      avg browse time

etc.

Department 2

user1      site      date/time      avg browse time

user2      site      date/time      avg browse time

user3      site      date/time      avg browse time

user4      site      date/time      avg browse time

etc.

Thanks

Message was edited by: voldog on 11/2/12 11:36:31 AM CDT

[sroering]

This is a frequently asked question.  In short, it's not possible since browse time isn't tracked by website, only by user. If you have paged views enabled, and you're doing "sticky loadbalancing" the numbers shouldn't be too bad.  Please read this article.

https://kc.mcafee.com/corporate/index?page=content&id=KB64344

[sroering]

Second part to your question regarding the "segmentation", you are looking for the "run report mulitple times" feature on the advanced tab when you edit the report.

That is probably one of the least documented features, so may not be that easy at first.  This is how I describe it.  The advanced tab is to make a list of items to iterate over to make separate tables.  In your example, department, which I assuming you are going to be using groups?

https://kc.mcafee.com/corporate/index?page=content&id=KB67630

So under the advanced tab, you are generating a list of groups that Web Reporter will then run the main report with a "group filter" for each item on your list.  You can combine the results in one report with separate tables, or as separate reports.

The query for your main report would just be the contents of the table.

Username  /   Date   /  Avg Browse time.

I also forgot to say that you cannot have the exact time with browse time since browse time is only in summary data.  Nor does it make any sense to associate browse time with an exact second. 

Message was edited by: sroering on 11/5/12 8:13:38 AM CST

[voldog]

Thanks for the reply. Followed the method you described regarding the report segmentation. However, the results return exactly as what I was getting before, which is

Department1

     USER1       SITE...

     USER2       SITE...

     USER3       SITE...

     etc.

Department 2

     USER1      SITE...

     USER2      SITE...

     USER3      SITE...

     etc.

ETC.

Now in the above format the same user may be listed multiple times under their respective department depending on which choice I made regarding Avg Browse time, number of hits, number of bytes or what ever I choose. So for example, I will use the first department, to demonstrate.

Department 1

     USER1          SITE...

     USER1          SITE...

     USER1          SITE...

     USER2          SITE...

     USER3          SITE...

     USER4          SITE...

     USER4          SITE...

     etc (until 10 users are identified).

I am trying to get it to go in a flow similar to the following:

Department 1

     USER1

          Site1

          Site2

          Site3

          Site4

          etc.

     USER2

          Site1

          Site2

          Site3

          Site4

          etc

Deparment 2

     USER1

          Site1

          Site2

          Site3

          Site4

          etc.

     USER2

          Site1

          Site2

          Site3

          Site4

          etc

(in order to list the top 10 sites for the top 10 users for each department. The results would be the same for deparment 2, department 3, department 4, etc. etc.)

I do no think there is a way to accomplish what I am trying to do from the webconsole as there is no real way to perform extensive Nested operations; at least from what I can tell., Hoping maybe someone can correct that tought and make it possible to perform?

[sroering]

As I said in my first reply, browse time by site is not accurate.  If you only include user and average browse time, your tables would compress.  The site is keeping them separate.

Department 1

  user1   avg_bt_1

  user2  avg_bt_2

  ...

Department 2

   user3  avg_bt_3

   user4 avg_bt_4

   ...

etc.

But if you were using hits instead of browse time, your results would be accurate.  Unfortunately, you cannot do the three level report like this.  You would need to make multiple reports.

Department

    User

         detail table

    User

         detail table

Department

    User

         detail table

    User

         detail table

[voldog]

Ok, thanks for update.