Problem Definition

Currently, none of the columns in UserBrowser.jspa are sortable which can make it difficult to filter for inactive users and a users last login date.

Suggested Solution

• Columns should be sortable by clicking on column headers
• Break out Active/Inactive status as a separate column
• Break out Last login date as separate columns

Why this is important

Sorting users by Active/Inactive status and last login date helps us determine potential licenses we can reuse from inactive users.

Workaround

• Show the entire table, copy and paste into Excel and manually massage the columns, rows, formats to get the view needed.
• Retrieve inactive users/last login dates via SQL query as described in: Retrieve last login dates for users via the database and Search for inactive users