How do I report on homepage usage?

[zheil]

Hi All

I'd like to report on:

- What homepages a certain user uses.

OR

- What users use a certain homepage.

Is this information somewhere in either the user or the homepage records?

[ryan86]

Hi Zalan,

The table you would need to focus your report on would be the "sys_portal_page" table.

From here, you could group by user to view which pages they use?

[zheil]

Hi Ryan VN

Thanks for your comment, I can't find anything relevant in that table, can you be more specific about the suggested solution?

[zheil · Accepted solution]

Here is the solution:

- Open the 'User Preferences' module

- Filter for Name = homepage

- The 'Value' column contains the sysid of the homepage a user visited recently

- Export this data

- Export the list of homepages with sysid

- Use the vlookup function in Excel to match homepages with users

- Define pivot charts