User Last Activity

The last activity date for users, based on login or background processes (for example, scheduled endpoints, imports, or exports) can be recorded daily using a date attribute. Last active date functionality provides information often required by auditors and can be used to report on active and/or inactive users.

Note: Impersonated users are not recorded or reported. When used with web services, the date attribute also records that a user attempted to log in, even if authentication failed.

Prerequisites

  1. Create a last activity description attribute with no dimension dependencies and 'ISO Date' validation base type, and make the attribute valid on User objects. For more information on creating description attributes, refer to the Creating Attributes topic in the System Setup documentation.

  2. In the Self-Service UI, select your environment, and on the 'Configuration properties' tab set the LastActivityDateAttributeID key and specify the ID of the description attribute created as the Value.

    In the following example, the attribute with ID 'LastActivityDate' is identified as the attribute to be used for reporting login activity. 

Reporting Last Activity

To access last activity:

  1. Complete the required configuration in the Prerequisites section above.

  2. On the Advanced Search tab, in the Search field, add the ID of the last activity attribute, add a space, and select an operator.

    For details on the operators, refer to the 'Attribute Value Searches' section of the Advanced Search Functionality topic in the Getting Started documentation.

  3. Add another space to display the additional operators available for the selection. The specific values displayed in the list are values that exist in the last login attribute.

    Note: Using a variable operator (such as 'today' or 'yesterday') allows the search results to be refreshed via a saved collection. For details, refer to the 'Refresh Data' section of the Maintaining Collections topic in the Getting Started documentation. Using a specific calendar date ('2025-01-16' or '2025-01-23' in the image above) in a collection includes static search results and requires a manual update in the search criteria to provide a different date.

  4. Click the Search button to display the results.

  5. Choose an 'Operation on Entire Result' to save the results as a collection, export the results as STEPXML, or run a bulk update. Or use the results context menu () to copy the first 100 users to paste into Excel or a text fileFor more information, refer to the Advanced Search topic in the Getting Started documentation.