Custom User View Usage

Version 1

    As a matter of managing my user base, I have a set of views showing me things like the age of the accounts, when the last time they access the server and how often.  One piece of the puzzle I was missing is to see what content they were accessing and how frequently.  This led me to create the attached example (created in v10). 

     

    There is a custom PostgreSQL query that gets the data together and a sample view that I threw together.  Of course, there are many things you could to with this type of data.  Check out the actions on the sheet to email the user and to go to the actual view.  Keep in mind the underlying query is built for my install and you would need to update the string for the URL as well as adjust the time zone. 

     

    I welcome any feedback to make this better.  I hope you find it useful!