Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Insert excerpt
_NoteAdminDoco
_NoteAdminDoco
nopaneltrue
 

Administrators can keep track of individual user activity via the following methods using the user maintenance form. Depending on your profile, not all of these options may be available.


If you have administrator permission you can monitor individual user activity from the Usage, Query or Audit tabs on the user maintenance formDepending on your profile, not all of these options may be available. 

To access user activity data:

Select a name to open the user maintenance form for that user and then select the required tab. 

Image Added



Table of Content Zone
maxLevel2
minLevel2
locationtop

Usage

page

 

The The Usage tab on the user maintenance form presents  shows a simple column chart showing with the number of queries of queries that a user makes each day, excluding dashboard queries. This iThis is ideal for checking that a user is using the product.  

  • It is a simplistic count and does not include any detail.
  • The Database drop down allows the chart to be filtered to a particular database. 
  • The Period drop down allows the chart to be filtered by 

     

    • You can filter by database from the Database menu. 
    • You can choose to view activity for 28 days, 3 months, 6 months and or 12 months from the Period menu.


    Image Modified

    Query logs 

    Optionally, administrators can enable If 'Detailed Logs' to record  has been enabled, every query that a user executes in a log, as shown below, accessed via the Query Logs tab on the user maintenance form.

    The

    will be recorded. These details can be accessed via the Query Logs tab. 

    • The log includes the date/time, the database, mode, dimension, period, any selections made and whether the result was shown as a chart or grid. 
    • Purge permanently deletes all recorded events.
    • Refresh re-queries the log and reloads the page.

    To enable detailed query logs

    Audit page

    Excerpt

    All significant changes to user accounts are recorded in the Audit page of the User maintenance form. This data is recorded automatically and is captured at a database level, so any changes made outside of the application 'through the back door' are also recorded. The date/time of the event is included. An example audit screen is shown below.

    The user-related events that are audited are:

    • CREATED: Records details about creation of a new user.
    • UPDATED: Changes to password, administrator, group, territory and profile. For all except password, the old and new values are retained.
    • DATABASE ADDED: Shows the physical database name and the restriction, if any, that applied. 
    • DATABASE UPDATED: Changes to a user's database settings. Records the physical database and the details of the restriction.
    • DATABASE DELETED: Records the database name that was removed from a user. Note: The database isn't deleted; it is just removed from the user's available list of databases. It will still be available to other users.

    Details of the 'From' and 'To' fields are truncated at 50 characters; for a detailed view of the change click on the 'From' or 'To' link. This opens a screen with more information, shown below.

    ...