Create a report with active and deactivated users

In Showpad, you can export a list of all your users and a particular set of their properties, such as their role, their last sign in, when they last updated their content, and which Showpad version they are using. You can also use this report to get an overview of all active or deactivated users.

Key features

• Export a list of all users
• Filter by active and deactivated users

You need this to succeed

Do this step by step

First, create a report with all users

1. Navigate to Users.
2. Click the gear icon on the bottom right to open the export options.
3. Depending on the required export format, click Export to CSV or Export to XLS. Note that the list will always contain all users, regardless of how many are displayed on the screen.

Next, apply a filter to show only active or deactivated users. In this example, we will use a .csv file and apply a filter.

In the report, you will see a column with the header activated. All users have a value in this column:

• 1 means the user is active
• 0 means the user has been deactivated

All you need to do now is create a filter that allows you to display all active users by filtering on the value 1, or all deactivated users by filtering on the value 0. In this example, we will use a CSV file in Numbers and apply a filter.

1. Open the downloaded report. Select the entire activated column.
2. Click the column's down arrow and select Show Filter Options.
3. Click the Add a Filter dropdown and select activated to filter by column.
4. From the filter rule dropdown menu, select equal to a number.
5. To view only activated users, enter 1. To view only deactivated users, enter 0. Hit enter once you've added a value.

Note: Last Content Update will only show login data for users on mobile devices because they must manually trigger the content update so a timestamp is recorded. This is designed to allow sales reps control of when updates occur so content updates don't begin in the middle of a sales pitch.