InternetOfficer.com

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.

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.