Current User: Guest Login
Please consider registering


Lost Your Password?

Search Forums:


 






Minimum search word length is 4 characters – Maximum search word length is 84 characters
Wildcard Usage:
*  matches any number of characters    %  matches exactly one character

Help with Extra section for userID page hit count

Reply to Post Add a New Topic
UserPost

7:08 pm
June 2, 2008


angelko

Phoenix

Member

posts 5

Hi,
I need some help adding an extra section to my AWStats report for a Vignette Portal site.

Here is an example of a record in my log file that I would like to count.

symphony.mycompany.com 192.168.229.13 – userId232 [05/Mar/2008:12:47:00 -0700] “POST HTTPS://symphony.mycompany.com/portal/site/symphony/templ ate.RAW/menuitem.9e5f3b4182dc5534553b9cdb46008a0c/?javax. portlet.tpst=6c126f7f65dc0ef836ab6ff55c7301ca_ws_RW&j avax.portlet.prp_6c126f7f65dc0ef836ab6ff55c7301ca_viewID= aim_save&javax.portlet.begCacheTok=com.vignette.cache token&javax.portlet.endCacheTok=com.vignette.cachetok en HTTP/1.1″ 200 754

I would like to count the total number of times a given user has hit this URL: /portal/site/symphony/template.RAW/menuitem

.9e5f3b4182dc5534553b9cdb46008a0c

Having a the following value for this parameter: javax.portlet.prp_6c126f7f65dc0ef836ab6ff55c7301ca_viewID=aim_save

Is it possible to show the total for each user?

I have tried several different ways of setting the ExtraSectionCondition1 value. Here is how I have it currently:

ExtraSectionName1=”Actioned Alerts”
ExtraSectionCodeFilter1=”200 304″
ExtraSectionCondition1=”URL,portal/site/symphony/template.RAW/m enuitem.9e5f3b4182dc5534553b9cdb46008a 0c”
ExtraSectionFirstColumnTitle1=”Actioned Alerts”
ExtraSectionFirstColumnValues1=”QUERY_STRING,javax.portlet.prp

_6c126f7f65dc0ef836ab6ff55c7301ca_viewID=( [^&]+)”
ExtraSectionFirstColumnFormat1=”%s”
ExtraSectionStatTypes1=PL
ExtraSectionAddAverageRow1=0
ExtraSectionAddSumRow1=1
MaxNbOfExtra1=20000
MinHitExtra1=1

I know the ExtraSectionFirstColumnValues1 is wrong. How can I pull out the authenticated user id?

When I update my database I see the following data in and a new section in my report but no rows end up in my report.

# Extra key – Pages – Hits – Bandwidth – Last access
# The 20000 first number of hits are first
BEGIN_EXTRA_1 11
aim 5467 5467 0 20080430135237
aim_save 2726 2726 0 20080430135237
process_filter 652 652 0 20080430151638
ffss_detail 33 33 0 20080429080657
save_ffss 15 15 0 20080429080655
demand 5 5 0 20080411093324
process_oq_filters 4 4 0 20080404091909
apply_save 2 2 0 20080404133608
qoh_inventory 2 2 0 20080417083511
supply 1 1 0 20080403030134
abc_detail 1 1 0 20080411092018
END_EXTRA_1

thanks for your help.

1:57 am
June 3, 2008


Jean-Luc

Admin

posts 1125

Hi,

I don't think that your ExtraSectionFirstColumnValues1 is wrong. If the data of the extra section are present in the AWStats database file as you show in your message, they should appear in the AWStats report itself. Double-chek that you are using the right config file.

Are you looking at the Perl reports (.pl) or at the static reports (.html) ? If using the Perl reports, refresh the page in your browser; if you use the static reports, try rebuilding the reports.

12:58 pm
June 3, 2008


angelko

Phoenix

Member

posts 5

Thanks for the advice. I think I know what is wrong.

The files I am processing only have data for March, April and May but since I am generating the report in June, it is showing zero rows in the report extra section.

Is there a way I can get the report to generate totals for all months that I have data for?

thanks.

2:21 pm
June 3, 2008


angelko

Phoenix

Member

posts 5

Yes, that was the problem. I added the -month=MM -year=YYYY flags and was able to see the data.

However, I am not sure how to show the data by user id.

Here is what the log file entry looks like:

symphony.mycompany.com 192.168.229.13 – userId232 [05/Mar/2008:12:47:00 -0700] "POST https://symphony.mycompany.com/portal/site/symphony/templ ate.RAW/menuitem.9e5f3b4182dc5534553b9cdb46008a0c/?javax. portlet.tpst=6c126f7f65dc0ef836ab6ff55c7301ca_ws_RW&j avax.portlet.prp_6c126f7f65dc0ef836ab6ff55c7301ca_viewID= aim_save&javax.portlet.begCacheTok=com.vignette.cache token&javax.portlet.endCacheTok=com.vignette.cachetok en HTTP/1.1" 200 754

The LogFormat = “%host %host %other %logname %time1 %methodurl %code %bytesd”

How can I use the %logname field in the report?

thanks.

4:02 pm
June 3, 2008


Jean-Luc

Admin

posts 1125

You cannot use %logname as such in an extra section.

If you rename %logname in %extra1, you will be able to use it in the extra section, but %logname will not be available anymore in the report. I am not sure this option is acceptable to you.

5:13 pm
June 3, 2008


angelko

Phoenix

Member

posts 5

Thanks for help.

Given your explanation, I decided to use the awk command to process the log file and rewrite it adding the userId as an additional field on each line.

I then referenced this new field in the ExtraSectionFirstColumnValues1 and was able to get what I need.

I now can get both the %logname field and the additional information I needed for each user id.

Reply to Post

Reply to Topic:
Help with Extra section for userID page hit count

Guest Name (Required):

Guest Email (Required):

NOTE: New Posts are subject to administrator approval before being displayed

Smileys
Confused Cool Cry Embarassed Frown Kiss Laugh Smile Surprised Wink Yell
Post New Reply

Guest URL (required)

Math Required!
What is the sum of:
4 + 3
   


About the InternetOfficer.com Forum

Forum Timezone: UTC 1

Most Users Ever Online: 302

Currently Online:
10 Guests

Currently Browsing this Topic:
1 Guest

Forum Stats:

Groups: 2
Forums: 9
Topics: 638
Posts: 2709

Membership:

There are 257 Members
There have been 302 Guests

There is 1 Admin
There is 1 Moderator

Top Posters:

cssfsu – 55
deepakgupta – 34
albert_newton – 30
cosminpana – 20
DTNMike – 19
ahtshun83 – 17

Recent New Members: raju, todd2taylor, sbdcunha, mansigill1987, ThomasDuh, ThomasKic

Administrators: Jean-Luc (1125 Posts)

Moderators: Jean-Luc (1125 Posts)