5 Replies Latest reply on Nov 13, 2012 9:48 AM by voldog

    Web Reporter Custom Report

      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
        • 1. Re: Web Reporter Custom Report
          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

          • 2. Re: Web Reporter Custom Report
            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
            • 3. Re: Web Reporter Custom Report

              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?

              • 4. Re: Web Reporter Custom Report
                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

                1 of 1 people found this helpful
                • 5. Re: Web Reporter Custom Report

                  Ok, thanks for update.