EBMS Tickets

Issue Number 167
Summary [Reports] Board Member Activity Report - Add usernames, Separate Boards
Created 2014-03-14 13:21:23
Issue Type Improvement
Submitted By Juthe, Robin (NIH/NCI) [E]
Assigned To Kline, Bob (NIH/NCI) [C]
Status Closed
Resolved 2014-08-05 19:23:54
Resolution Fixed
Path /home/bkline/backups/jira/oceebms/issue.119826
Description

We would like to make a few changes to the Board Member Activity Report.

1. Please replace the Board column with the NCI username (if possible). Our Board members often ask us for their NCI username and we don't currently have an easy way to get this information.

2. Please place the members of each Board on a separate sheet in the Excel workbook (and label the tabs at the bottom with the Board name).

Thanks!

Comment entered 2014-08-04 11:49:45 by Kline, Bob (NIH/NCI) [C]

I'm going to call the middle column "Authname," and it will hold the NIH domain login for SSO accounts, the distinguished name (DN) for eDir accounts (this has the common name (CN) embedded as part of the DN), and an empty string for the rest (e.g., the test accounts, which have local Drupal logins). Sound OK?

Comment entered 2014-08-04 12:22:13 by Juthe, Robin (NIH/NCI) [E]

I think that sounds good. I'm assuming the difference between the eDir name and the NIH SSO will be clear, but could you provide an example?

Comment entered 2014-08-04 12:30:53 by Kline, Bob (NIH/NCI) [C]

Sure. Barry's got an SSO login, so kramerb is his NIH domain account name. Beverly doesn't, so her DN is shown (with common name of moybev):

cn=moybev,ou=EXT,ou=NCI,o=NIH

Comment entered 2014-08-04 12:36:07 by Juthe, Robin (NIH/NCI) [E]

Thanks. I think this is fine.

What does Authname stand for - authentication name? Might be better to spell it out. I think we'll have the real estate to do so since the DN is long.

Comment entered 2014-08-04 12:55:10 by Kline, Bob (NIH/NCI) [C]

Authname is the name of the database column, and it's just a contraction of authentication name, as you suggest, so we could use that for the column header if you prefer.

Comment entered 2014-08-05 19:23:54 by Kline, Bob (NIH/NCI) [C]

Ready for user review on DEV.

Comment entered 2014-08-19 17:50:23 by Juthe, Robin (NIH/NCI) [E]

Could you please place the NO BOARDS tab at the far right of the report output? I don't think we will use that very often (if at all) so I don't think it should be the primary tab. Thanks.

Comment entered 2014-08-20 08:46:41 by Kline, Bob (NIH/NCI) [C]

NO BOARDS tab moved.

Comment entered 2014-08-20 08:51:07 by Juthe, Robin (NIH/NCI) [E]

Verified on DEV. Thanks!

Comment entered 2014-09-13 11:45:42 by Shields, Victoria (NIH/NCI) [E]

Verified on QA.

Comment entered 2014-11-05 16:36:14 by Shields, Victoria (NIH/NCI) [E]

Verified on PROD.

Attachments
File Name Posted User
board-members-last-login-20140804114141.xlsx 2014-08-04 12:30:53

Elapsed: 0:00:00.000675