EBMS Tickets

Issue Number 133
Summary [Reports] Board Member Activity Report
Created 2013-12-19 15:13:15
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2013-12-20 15:18:49
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.116325
Description

We would like to have a report to show when our Board members last logged into the EBMS. This will help us keep a handle on who has/has not successfully logged into the system.

We would like the report to have the following columns:
Name
Board
Date/Time - please list the date and time of the last successful login in ISO format.

(Some Board members will be listed more than once on the report since they are associated with >1 Board.)

Generating the report in Excel probably makes the most sense as we would like to have the ability to sort by Board, Name, and Date/Time.

Please give Board Managers, ICRDB Managers, and Admin Assistants the ability to run this report.
Thanks.

Comment entered 2013-12-19 15:14:31 by Juthe, Robin (NIH/NCI) [E]

On second thought, please rename the "Date/Time" column to "Last Login".

Comment entered 2013-12-19 16:38:15 by Kline, Bob (NIH/NCI) [C]

I assume you just want active members, right?

Comment entered 2013-12-19 16:41:51 by Juthe, Robin (NIH/NCI) [E]

Yes, just active members. Thanks.

Comment entered 2013-12-20 15:18:49 by Kline, Bob (NIH/NCI) [C]

Ready for user review on DEV. We'll see how much luck we have getting CBIIT to install the libraries for generating Excel workbooks on the upper tiers. :-)

Comment entered 2014-01-06 00:50:13 by Kline, Bob (NIH/NCI) [C]

Promoted to QA.

Comment entered 2014-01-16 11:29:38 by Juthe, Robin (NIH/NCI) [E]

Would it be possible to limit this to active Board members?

Comment entered 2014-01-16 11:31:14 by Juthe, Robin (NIH/NCI) [E]

Nevermind, I think it is. Let me double-check.

Comment entered 2014-01-17 12:49:09 by Juthe, Robin (NIH/NCI) [E]

Verified on QA. Confirmed that the report is limited to active members (at least according to the data on QA, which is old).

Comment entered 2014-02-25 15:45:46 by Juthe, Robin (NIH/NCI) [E]

Verified on prod.

Elapsed: 0:00:00.000234