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 CDTThis 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
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 CSTThanks 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?
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
Ok, thanks for update.
Corporate Headquarters
6220 America Center Drive
San Jose, CA 95002 USA