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 form. Depending 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.
Usage
The Usage tab shows a simple column chart with the number of queries that a user makes each day, excluding dashboard queries. This is ideal for checking that a user is using the product.
- You can filter by database from the Database menu.
- You can choose to view activity for 28 days, 3 months, 6 months or 12 months from the Period menu.
Query logs
If 'Detailed Logs' has been enabled, every query that a user executes 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
Enable the Detailed Logs feature from the User maintenance form, as shown below.
Audit page
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.
System-wide audit
Advanced administrators with permission can also access a system-wide log of significant changes to user accounts (see Audit log in 'Implementations' guide - restricted access).
Related articles