Monitor user activity

User permission: Administration > Users

Individual user activity

The user maintenance form shows you a user's activity over a selected period of days, months or a year, including queries any changes to their permissions, password, user group and so on. You can get activity information from the following three tabs:

Usage

The Usage tab shows a simple column chart with the number of queries that a user makes each day, which is ideal way to check that a user is using the product.

Every time a user performs a query on the query screen, the count for that database and that day is increased. This includes whenever a new item (dimension, measure, property, and so on) is selected. Dashboard and chart queries are not counted.

By default, the chart shows usage across all databases during the past 28 days. You can filter the data by:

• Database - select the database from the Database menu.

• Time period - Select the activity for 28 days, 3 months, 6 months or 12 months from the Period menu.

Query

If the Detailed Logs permission has been enabled on the User tab, every query that a user executes will be recorded.

These details display on the Query Logs tab (you might not have permission to see this 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.

To permanently deletes all recorded events, click the Purge button.

To re-query the log and reload the page, click the Refresh button.

System-wide activity

User permission: Logs

See View system-wide activity and error logs.

Audit

User permission: This feature is not typically available to administrators but is used by Phocas implementation and support consultants.

All significant changes to user accounts are recorded in the Audit tab 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. 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.