[DMS-1253] System Utilization Report - Workterra Jira

Details

Type: New Feature
Status: Done
Priority: Medium
Resolution: Done
Affects Version/s: None
Fix Version/s: Enhancements - Fall
Labels:
None

Company:
All Clients/Multiple Clients
Epic Link:
Access levels - data security

Sprint:
DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7
Dev Estimates:
16

Description

System Utilization Report

Company ID
User ID (UserDiD)
IP Address
Device (Web)
APIUserID
Browser Name
Browser Version
Logged In Time
Log out Time
Page viewed
- Page Name

Date and Time Visited

Attachments

Options
- Sort By Name
- Sort By Date
- Ascending
- Descending
- Thumbnails
- List
- Download All

Attachments

DMS-1253_Documentation.doc
06/May/19 05:02 AM
23 kB
Komal Barde
DMS-1253_Documentation_updated.doc
09/May/19 05:22 AM
20 kB
Komal Barde
AffectedFiles_DMS-1253.txt
17/Jun/19 04:39 AM
0.3 kB
Sonali Farakate

Activity

Ascending order - Click to sort in descending order

Hide

Permalink

Komal Barde (Inactive) added a comment - 09/May/19 05:15 AM

List of modified/added files:

DMS/DMS.App/src/DMS_AppLogic/Common/Enums.cs
DMS/DMS.App/src/DMS_AppLogic/Common/Routines/CommonRoutines.cs
DMS/DMS.App/src/DMS_Data/Models/Company.cs
DMS/DMS.App/src/DMS_Data/Models/Person.cs
DMS/DMS.App/src/DMS_Data/Models/Systemutilization.cs
DMS/DMS.App/src/DMS_Data/Models/Users.cs
DMS/DMS.App/src/DMS_Data/Models/dms_masterContext.cs
DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/IntegrationBaseController.cs
DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/ValidateIntegrationController.cs
DMS/DMS.App/src/DMS_WebApi/Controllers/UserAccount/UserController.cs
DMS/DMS.App/src/Entities/SessionData.cs
DMS/DMS.Web/src/DMS_WebApp/ClientApp/src/app/Integration/BasicIntegration/BasicIntegration/BasicIntegration.component.ts
DMS/DMS.Web/src/DMS_WebApp/ClientApp/src/app/Shared/Components/header/header.component.ts
DMS/DMS_App_Tests/DMSUserControllerTest.cs
DMS/Databases Objects/01_DDL/005_~~DMS-1253~~_DMS_NewTable_SystemUtilization.sql

Show

Komal Barde (Inactive) added a comment - 09/May/19 05:15 AM List of modified/added files : DMS/DMS.App/src/DMS_AppLogic/Common/Enums.cs DMS/DMS.App/src/DMS_AppLogic/Common/Routines/CommonRoutines.cs DMS/DMS.App/src/DMS_Data/Models/Company.cs DMS/DMS.App/src/DMS_Data/Models/Person.cs DMS/DMS.App/src/DMS_Data/Models/Systemutilization.cs DMS/DMS.App/src/DMS_Data/Models/Users.cs DMS/DMS.App/src/DMS_Data/Models/dms_masterContext.cs DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/IntegrationBaseController.cs DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/ValidateIntegrationController.cs DMS/DMS.App/src/DMS_WebApi/Controllers/UserAccount/UserController.cs DMS/DMS.App/src/Entities/SessionData.cs DMS/DMS.Web/src/DMS_WebApp/ClientApp/src/app/Integration/BasicIntegration/BasicIntegration/BasicIntegration.component.ts DMS/DMS.Web/src/DMS_WebApp/ClientApp/src/app/Shared/Components/header/header.component.ts DMS/DMS_App_Tests/DMSUserControllerTest.cs DMS/Databases Objects/01_DDL/005_ DMS-1253 _DMS_NewTable_SystemUtilization.sql

Hide

Permalink

Komal Barde (Inactive) added a comment - 09/May/19 05:17 AM

Unit testing:

Log login and logout time for DMS login
Log login and logout time for API integration for OneIam
Log login and logout time for API integration for Bearer

Show

Komal Barde (Inactive) added a comment - 09/May/19 05:17 AM Unit testing: Log login and logout time for DMS login Log login and logout time for API integration for OneIam Log login and logout time for API integration for Bearer

Hide

Permalink

Komal Barde (Inactive) added a comment - 09/May/19 05:24 AM

Please find updated DMS-1253_Documentation_updated.doc table structure and flow for 'System Utilization Report'.

Thanks,
Komal

CC:Samir, Swapnil Pandhare,Ganesh Sadawarte,Rohan J Khandave

Show

Komal Barde (Inactive) added a comment - 09/May/19 05:24 AM Hi Please find updated DMS-1253_Documentation_updated.doc table structure and flow for 'System Utilization Report'. Thanks, Komal CC: Samir , Swapnil Pandhare , Ganesh Sadawarte , Rohan J Khandave

Hide

Permalink

Samir added a comment - 16/May/19 10:53 PM

Hi Swapnil Pandhare,

Please attach the sql query to fetch this data

Regards,

Samir

Show

Samir added a comment - 16/May/19 10:53 PM Hi Swapnil Pandhare , Please attach the sql query to fetch this data Regards, Samir

Hide

Permalink

Swapnil Pandhare (Inactive) added a comment - 17/May/19 05:55 AM

HI Samir,

This Jira contains changes for saving the request details into database. It doesn't have changes to fetch the details and doesn't contain query for fetching the details as there is no page where these can be displayed. Still, you can use below query to check from database for respective company :

select * from dms_master.systemutilization
where companyID = @CompanyID order by id desc

Show

Swapnil Pandhare (Inactive) added a comment - 17/May/19 05:55 AM HI Samir , This Jira contains changes for saving the request details into database. It doesn't have changes to fetch the details and doesn't contain query for fetching the details as there is no page where these can be displayed. Still, you can use below query to check from database for respective company : select * from dms_master.systemutilization where companyID = @CompanyID order by id desc

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 22/May/19 01:32 AM

Keeping this jira on Hold

Sachin Hingole Hrishikesh Deshpande Samir Satya

Show

Priya Dhamande (Inactive) added a comment - 22/May/19 01:32 AM Keeping this jira on Hold Sachin Hingole Hrishikesh Deshpande Samir Satya

Hide

Permalink

Sonali Farakate (Inactive) added a comment - 13/Jun/19 06:13 AM

Hi Samir,

I have verified the IP addresses getting inserted in 'SystemUtilization' table.

As per the analysis, the host IP address is getting inserted in table instead of the User's IP address. This is because, in code we are taking host IP address instead of User's IP address.

Thanks,
Sonali Farakate.

CC : Rohan J Khandave, Ganesh Sadawarte

Show

Sonali Farakate (Inactive) added a comment - 13/Jun/19 06:13 AM Hi Samir , I have verified the IP addresses getting inserted in ' SystemUtilization ' table. As per the analysis, the host IP address is getting inserted in table instead of the User's IP address. This is because, in code we are taking host IP address instead of User's IP address. Thanks, Sonali Farakate. CC : Rohan J Khandave , Ganesh Sadawarte

Hide

Permalink

Priya Dhamande (Inactive) added a comment - 16/Jul/19 01:09 AM

No action required from QA end. So, marking this jira done.

Samir Sachin Hingole Hrishikesh Deshpande Rohan J Khandave

Show

Priya Dhamande (Inactive) added a comment - 16/Jul/19 01:09 AM No action required from QA end. So, marking this jira done. Samir Sachin Hingole Hrishikesh Deshpande Rohan J Khandave

People

Assignee:: Sonali Farakate (Inactive)

Reporter:: Samir

Votes:: 0 Vote for this issue

Watchers:: 5 Start watching this issue

Dates

Created:: 23/Apr/19 02:31 AM

Updated:: 16/Jul/19 01:10 AM

Resolved:: 16/Jul/19 01:10 AM

Time Tracking

Estimated:

32h

Remaining:

Logged:

52h