Client User Login Report

From UG

Revision as of 21:18, 22 November 2011 (edit) Alex (Talk | contribs) ← Older edit		Current revision as of 21:25, 22 November 2011 (edit) (undo) Alex (Talk | contribs) (→Info)
(One intermediate revision not shown)
Line 5:		Line 5:
	=== Parent Mantis ===		=== Parent Mantis ===
-	* mantis [http://ct.jaguarfreight.com/mantis/view.php?id=1600 0001600]	+	* mantis [http://ct.jaguarfreight.com/mantis/view.php?id=3275 3275]
	=== Scope of this wiki ===		=== Scope of this wiki ===
Line 85:		Line 85:
	[[#SOW 1]]		[[#SOW 1]]
-	==== Jag User accesses Client User Login Report ====	+	=== Jag User accesses Client User Login Report ===
	'''Accessed by Reports >> Statistical'''		'''Accessed by Reports >> Statistical'''
Line 95:		Line 95:
	[[File:User Login Report Menu.JPG]]		[[File:User Login Report Menu.JPG]]
-	==== Super Ops Jag User sets filters ====	+	=== Super Ops Jag User sets filters ===
-	===== Date filter set =====	+	==== Date filter set ====
	'''User selects Single date'''		'''User selects Single date'''
Line 107:		Line 107:
	[[File:Single Date Filter Results.JPG]]		[[File:Single Date Filter Results.JPG]]
-	===== Client company filter set =====	+	==== Client company filter set ====
	'''User selects Client Company'''		'''User selects Client Company'''
Line 118:		Line 118:
	[[File:Client Company Filter Results.JPG]]		[[File:Client Company Filter Results.JPG]]
-	===== Both Date & client company filter set =====	+	==== Both Date & client company filter set ====
	'''User selects One Month & Year date AND One Client Company'''		'''User selects One Month & Year date AND One Client Company'''
Line 129:		Line 129:
	[[File:Both Single Month Date and Client Company Filters Results.JPG]]		[[File:Both Single Month Date and Client Company Filters Results.JPG]]
-
-	=== Rel 1.1 ===

---

Current revision as of 21:25, 22 November 2011

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