Client User Login Report

From UG

Contents 1 Info 1.1 Parent Mantis 1.2 Scope of this wiki 2 SOW 1 2.1 Filters 2.2 Output 3 SOW 2 3.1 Impact on DB performance and speed 4 SOW 3 5 History 5.1 Links to Archived / Old specs 5.2 0002827: (User Login Report)Change:If filter client comp set, filter of nonjag user should list only users that have same cc in profile 6 User Guide 6.1 Feature Sets covered 6.2 Jag User accesses Client User Login Report 6.3 Super Ops Jag User sets filters 6.3.1 Date filter set 6.3.2 Client company filter set 6.3.3 Both Date & client company filter set

[edit] Info

[edit] Parent Mantis

• mantis 3275

[edit] Scope of this wiki

Create this new CT2 report, Client User Login Report, for internal super ops & management users for them to run a report on the number of client company users (AKA non Jag users) that access our system on a daily basis.

[edit] SOW 1

Mantis: 1616 (User Login Report) Design and Implement this new report

Core requirements:

• Task type: Feature.
• Where: CT2 Internal Application (maybe in Admin section or among Statistical Reports).
• What: Report which displays number of logins into CT2 Client Application at any given time for one or more Client Companies with breakdown on client users.

[edit] Filters

• Client Companies (multiselect):
  • This is a required filter.
  • This filter is multiselect.
  • If the filter is empty and selected then report should display results for all Client Companies.
• Non-Jaguar Users (multiselect).
  • This filter is multiselect.
  • If the filter is empty and selected then report should display results for all Non-Jaguar Users of given Client Conpany.
• Login Date:
  • Single Date OR
  • To and From pair of Date ranges (Day, Month, Year) OR
  • To and From pair of Month ranges (Month, Year)

[edit] Output

Results to be a summary of the above filters that jag user selected, as well as list the number of times the system was accessed according to the filtered criteria.

Example from BA:

User selects Client Company - Coty Sanford, selects Single Date: 20-Jan-2011,
the results would show the following:

Client Company: Coty Sanford
Date: 20-Jan-2011
Number of Logins: 15 

User Name                      Real Name                        Logins
russel_schiavone@cotyinc.com   Russ Schiavone                   2
angela_schmidt@cotyinc.com     Angela Schmidt                   8
irma_galeos@cotyinc.com        Irma Galeos                      5

[edit] SOW 2

Mantis: 2827 (User Login Report)Change:If filter client comp set, filter of nonjag user should list only users that have same cc in profile

Core requirements:

Change for the client company filtering results.

• If filter client company is set, the filtered results should be only the non jag users, that have that same set client company name in their non jag user profile.

[edit] Impact on DB performance and speed

TBD

[edit] SOW 3

Just a stub!!!

[edit] History

[edit] Links to Archived / Old specs

• See business requirements here:1616_rfsa

• See Design / Solution here: 1616_rfd

[edit] 0002827: (User Login Report)Change:If filter client comp set, filter of nonjag user should list only users that have same cc in profile

[edit] User Guide

[edit] Feature Sets covered

#SOW 1

[edit] Jag User accesses Client User Login Report

Accessed by Reports >> Statistical

User can set filters

[edit] Super Ops Jag User sets filters

[edit] Date filter set

User selects Single date

Results of Single Date filter

[edit] Client company filter set

User selects Client Company

Results of Client Company Set

[edit] Both Date & client company filter set

User selects One Month & Year date AND One Client Company

Results of One Month & Year date AND One Client Company