Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements
Community Member

Assistance with Sawmill Custom Reports

After successfully implementing a pair of S650 WSAs, I am now being asked by our management for various reports.  I have produced a number of custom Sawmill reports which provide most of the information needed, but I am having trouble trying to produce one report.  The requirement is to show a breakdown of sites vsisited for each user, including the time spent, by month, such as in this example:

Name

Date

Website

Time spent

Total per month

Joe Bloggs

1.3.10

www.e-bay.co.uk

1.30 hrs

Joe Bloggs

4.3.10

www.First Choice.co.uk

45 mins

Joe Bloggs

6.3.10.

www.Boats4us.com

25 mins

2.40 hrs

Paul Smith

2.3.10

www.Facebook.com

3.45 hrs

Paul Smith

8.3.10

www.gjw.co.uk

25 mins

Paul Smith

9.3.10

www.fashion.com

4  mins

Paul Smith

12.3.10

www.fashion .com

2 mins

5.15 hrs

I have looked at using a Report Element of "Table with Sub-table" and, while this would work for sessions/hits, it won't show the time fields as these only appear to be available in the "Sessions" report elements.  Any help or advice on how to accomplish this task would be greatly appreicated.


Regards,

Kev

Everyone's tags (3)
2 REPLIES
Community Member

Re: Assistance with Sawmill Custom Reports

I don't believe it is possible due to some functional constraints within Sawmill.  Tables/sub-tables work well with standard reports elements that have strings or counters - but not when Sawmill needs to sessionalize the data and calculate time usage.

~Tim

Community Member

Re: Assistance with Sawmill Custom Reports

Thanks for the advice Tim, I can now stop spending time trying to generate an impossible report.  I will just have to use the "Time by Server" report and filter it for a single user, although with over 600 people in our company, I will need to pick specific targets rather than produce reports covering everyone!

Kev

389
Views
0
Helpful
2
Replies
CreatePlease to create content