service portal usage reporting

[zachw]

Has anyone set up reporting to track service portal use? If so, what reporting do you have and how did you do it?

[Rushit Patel2 · Accepted solution]

have you seen 'usage overview' module under service portal

it has bunch of OOB reports based on 'sp_log' table.

(please mark helpful/like/correct if it helps)

[zachw]

I hadn't. For some reason we haven't exposed it. Working on that now. Thanks.

[Piotr Ba_amut]

Hi,

You may create any reports, charts based on the sp_log, and sp_page tables. Actually, both tables can be joined to obtain more meaningful results.

At my company I have created the following charts:

- Most popular pages by days, weeks, months (bar chart)

- Total number of hits so far   (total number, gauge)

- Amount of users who visited Portal by days, weeks etc. (column chart, sp_log table has been joined with user table)

- Most active departments broken by pages visited (bar chart)

etc.

Of course, it is possible to develop more detailed hits' logging to the sp_log table to obtain appropriate level of granularity.

[prajaktanaik]

Hi Piotr,

Could you please share how did you create report for number of users who visited portal by month?

Many thanks,

Prajakta