Document Management SystemProject Type: software

Document Management System

Uploaded image for project: 'Document Management System'
  1. Document Management System
  2. DMS-1253

System Utilization Report

    Details

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

      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

          Activity

          Ascending order - Click to sort in descending order
          samir Samir created issue -
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Field Original Value New Value
          Fix Version/s Enhancements - Fall [ 10610 ]
          samir Samir made changes -
          Remaining Estimate 24h [ 86400 ]
          Original Estimate 24h [ 86400 ]
          samir Samir made changes -
          Sprint DMS - Fall Sprint 4 [ 163 ]
          samir Samir made changes -
          Assignee Samir [ samir ] Komal Barde [ komal.barde ]
          samir Samir made changes -
          Description h2. System Utilization Report
           * Company ID
           * User ID (UserDiD)
           * IP Address
           * Device (Web)
           * Browser Name
           * Browser Version
           * Logged In Time
           * Log out Time
           * Page viewed
           ** Page Name

          Date and Time Visited           		h2. System Utilization Report
           * Company ID
           * User ID (UserDiD)
           * IP Address
           * Device (Web)
           * Browser Name
           * Browser Version
           * Logged In Time
           * Log out Time
           * Page viewed
           ** Page Name

                              Date and Time Visited
          Permalink
          komal.barde Komal Barde (Inactive) logged work - 05/May/19 06:31 PM - edited
          • Time Spent:
            6.5h
             
            • Discussion on implementation and Database structure & integration APIs for system utilization reports logging
            • Feature analysis
            • Code debugging for login and logout flow
          samir Samir made changes -
          Remaining Estimate 24h [ 86400 ] 16h [ 57600 ]
          Original Estimate 24h [ 86400 ] 16h [ 57600 ]
          samir Samir made changes -
          Description h2. System Utilization Report
           * Company ID
           * User ID (UserDiD)
           * IP Address
           * Device (Web)
           * Browser Name
           * Browser Version
           * Logged In Time
           * Log out Time
           * Page viewed
           ** Page Name

                              Date and Time Visited           		h2. 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
          komal.barde Komal Barde (Inactive) made changes -
          Sprint DMS - Fall Sprint 4 [ 163 ] DMS - Fall Sprint 2 [ 161 ]
          komal.barde Komal Barde (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          komal.barde Komal Barde (Inactive) made changes -
          Attachment DMS-1253_Documentation.doc [ 106712 ]
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 16h [ 57600 ] 32h [ 115200 ]
          Original Estimate 16h [ 57600 ] 32h [ 115200 ]
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 06/May/19 05:07 AM
          • Time Spent:
            1h
             

            Discussion with Komal, Ganesh, Rohan

             

          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Remaining Estimate 32h [ 115200 ] 31h [ 111600 ]
          Time Spent 1h [ 3600 ]
          Worklog Id 176393 [ 176393 ]
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 31h [ 111600 ] 32h [ 115200 ]
          Permalink
          Ganesh.sadawarte Ganesh Sadawarte (Inactive) logged work - 06/May/19 06:01 AM
          • Time Spent:
            0.5h
             

            Discussion on implementation, database structure & integration APIs for system utilization reports logging 

          Ganesh.sadawarte Ganesh Sadawarte (Inactive) made changes -
          Remaining Estimate 32h [ 115200 ] 31.5h [ 113400 ]
          Time Spent 1h [ 3600 ] 1.5h [ 5400 ]
          Worklog Id 176414 [ 176414 ]
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 31.5h [ 113400 ] 24.5h [ 88200 ]
          Time Spent 1.5h [ 5400 ] 8.5h [ 30600 ]
          Worklog Id 176428 [ 176428 ]
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 24.5h [ 88200 ] 25h [ 90000 ]
          Time Spent 8.5h [ 30600 ] 8h [ 28800 ]
          Worklog Id 176428 [ 176428 ]
          Permalink
          komal.barde Komal Barde (Inactive) logged work - 06/May/19 07:02 PM
          • Time Spent:
            7.5h
             
            1. Table structure creation
            2. Code debugging and fixing to store data on login for normal DMS user login
            3. Code debugging and fixing to store data on logout for normal DMS user login
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 25h [ 90000 ] 17.5h [ 63000 ]
          Time Spent 8h [ 28800 ] 15.5h [ 55800 ]
          Worklog Id 176707 [ 176707 ]
          Permalink
          komal.barde Komal Barde (Inactive) logged work - 07/May/19 07:37 PM
          • Time Spent:
            7.5h
             
            • Debugging code of login flow
            • Discussion with Ganesh
            • Analysis of custom attribute
            • Code fixing
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 17.5h [ 63000 ] 10h [ 36000 ]
          Time Spent 15.5h [ 55800 ] 23h [ 82800 ]
          Worklog Id 176966 [ 176966 ]
          Permalink
          komal.barde Komal Barde (Inactive) logged work - 08/May/19 05:09 PM
          • Time Spent:
            7.5h
             
            1. Code debugging and fixing for API integration
            2. Unit testing
            3. Discussion with Ganesh
          komal.barde Komal Barde (Inactive) made changes -
          Remaining Estimate 10h [ 36000 ] 2.5h [ 9000 ]
          Time Spent 23h [ 82800 ] 30.5h [ 109800 ]
          Worklog Id 177119 [ 177119 ]
          komal.barde Komal Barde (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          komal.barde Komal Barde (Inactive) made changes -
          Assignee Komal Barde [ komal.barde ] Swapnil Pandhare [ swapnil.pandhare ]
          Hide
          Permalink
          komal.barde Komal Barde (Inactive) added a comment -

          List of modified/added files:

          1. DMS/DMS.App/src/DMS_AppLogic/Common/Enums.cs
          2. DMS/DMS.App/src/DMS_AppLogic/Common/Routines/CommonRoutines.cs
          3. DMS/DMS.App/src/DMS_Data/Models/Company.cs
          4. DMS/DMS.App/src/DMS_Data/Models/Person.cs
          5. DMS/DMS.App/src/DMS_Data/Models/Systemutilization.cs
          6. DMS/DMS.App/src/DMS_Data/Models/Users.cs
          7. DMS/DMS.App/src/DMS_Data/Models/dms_masterContext.cs
          8. DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/IntegrationBaseController.cs
          9. DMS/DMS.App/src/DMS_WebApi/Controllers/IntegrationAPI/ValidateIntegrationController.cs
          10. DMS/DMS.App/src/DMS_WebApi/Controllers/UserAccount/UserController.cs
          11. DMS/DMS.App/src/Entities/SessionData.cs
          12. DMS/DMS.Web/src/DMS_WebApp/ClientApp/src/app/Integration/BasicIntegration/BasicIntegration/BasicIntegration.component.ts
          13. DMS/DMS.Web/src/DMS_WebApp/ClientApp/src/app/Shared/Components/header/header.component.ts
          14. DMS/DMS_App_Tests/DMSUserControllerTest.cs
          15. DMS/Databases Objects/01_DDL/005_DMS-1253_DMS_NewTable_SystemUtilization.sql
          Show
          komal.barde Komal Barde (Inactive) added a comment - 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 Komal Barde (Inactive) added a comment -

          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 Komal Barde (Inactive) added a comment - 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
          komal.barde Komal Barde (Inactive) made changes -
          Attachment DMS-1253_Documentation_updated.doc [ 107108 ]
          Hide
          Permalink
          komal.barde Komal Barde (Inactive) added a comment -

          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

          Show
          komal.barde Komal Barde (Inactive) added a comment - 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
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Sprint DMS - Fall Sprint 2 [ 161 ] DMS - Fall Sprint 2, DMS - Fall Sprint 3 [ 161, 162 ]
          Hide
          Permalink
          samir Samir added a comment -

          Hi Swapnil Pandhare,

          Please attach the sql query to fetch this data

          Regards,

          Samir

          Show
          samir Samir added a comment - Hi Swapnil Pandhare , Please attach the sql query to fetch this data Regards, Samir
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) logged work - 17/May/19 12:07 AM
          • Time Spent:
            1h
             

            Discussion and code review

          Hide
          Permalink
          swapnil.pandhare Swapnil Pandhare (Inactive) added a comment -

          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 Swapnil Pandhare (Inactive) added a comment - 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
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Assignee Swapnil Pandhare [ swapnil.pandhare ] Harshveer Singh [ harshveer.singh ]
          swapnil.pandhare Swapnil Pandhare (Inactive) made changes -
          Remaining Estimate 2.5h [ 9000 ] 1.5h [ 5400 ]
          Time Spent 30.5h [ 109800 ] 31.5h [ 113400 ]
          Worklog Id 178816 [ 178816 ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Assignee Harshveer Singh [ harshveer.singh ] Priya Dhamande [ priya.dhamande ]
          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

          Keeping this jira on Hold

          Sachin Hingole Hrishikesh Deshpande Samir Satya

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - Keeping this jira on Hold Sachin Hingole Hrishikesh Deshpande Samir Satya
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Status In QA Testing [ 11901 ] On hold in Test [ 10019 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 2, DMS - Fall Sprint 3 [ 161, 162 ] DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4 [ 161, 162, 163 ]
          samir Samir made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Samir [ samir ]
          samir Samir made changes -
          Assignee Samir [ samir ] Priya Dhamande [ priya.dhamande ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4 [ 161, 162, 163 ] DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4, DMS - Fall Sprint 5 [ 161, 162, 163, 164 ]
          samir Samir made changes -
          Status On hold in Test [ 10019 ] In Progress [ 3 ]
          samir Samir made changes -
          Status In Progress [ 3 ] To Do [ 10000 ]
          Permalink
          sonali.farakate Sonali Farakate (Inactive) logged work - 12/Jun/19 09:13 PM
          • Time Spent:
            7h
             
            • Code debugging
            • Code Understanding
            • Discussion with Ramya, Rohan and Ganesh
            • Verification on Local and Pre-production
            • Understanding database tables

             

          samir Samir made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Sonali Farakate [ sonali.farakate ]
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Status To Do [ 10000 ] In Progress [ 3 ]
          Hide
          Permalink
          sonali.farakate Sonali Farakate (Inactive) added a comment -

          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 Sonali Farakate (Inactive) added a comment - 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
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Remaining Estimate 1.5h [ 5400 ] 0h [ 0 ]
          Time Spent 31.5h [ 113400 ] 38.5h [ 138600 ]
          Worklog Id 183046 [ 183046 ]
          Permalink
          sonali.farakate Sonali Farakate (Inactive) logged work - 13/Jun/19 09:26 PM
          • Time Spent:
            7.5h
             

            Analysis

            Back end Code changes

            Debugging

            Testing for Ip

          sonali.farakate Sonali Farakate (Inactive) made changes -
          Dev Estimates 16
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Time Spent 38.5h [ 138600 ] 46h [ 165600 ]
          Worklog Id 183306 [ 183306 ]
          Permalink
          sonali.farakate Sonali Farakate (Inactive) logged work - 16/Jun/19 06:38 PM
          • Time Spent:
            0.5h
             

            Done check ins and created PR for test patch

          Permalink
          sonali.farakate Sonali Farakate (Inactive) logged work - 16/Jun/19 08:35 PM
          • Time Spent:
            5.5h
             
            • Discussion with Ganesh, Rohan and Ramya regarding code change approch,
            • Tried code for getting Ip address through front end
            • Verified different approaches for getting User's IP address. 
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Status In Progress [ 3 ] In Progress [ 3 ]
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Status In Progress [ 3 ] Code Review [ 11801 ]
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Attachment AffectedFiles_DMS-1253.txt [ 110564 ]
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Assignee Sonali Farakate [ sonali.farakate ] Samir [ samir ]
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Time Spent 46h [ 165600 ] 51.5h [ 185400 ]
          Worklog Id 183583 [ 183583 ]
          sonali.farakate Sonali Farakate (Inactive) made changes -
          Time Spent 51.5h [ 185400 ] 52h [ 187200 ]
          Worklog Id 183585 [ 183585 ]
          samir Samir made changes -
          Epic Link DMS-475 [ 75968 ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4, DMS - Fall Sprint 5 [ 161, 162, 163, 164 ] DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 161, 162, 163, 164, 165 ]
          samir Samir made changes -
          Status Code Review [ 11801 ] In QA Testing [ 11901 ]
          samir Samir made changes -
          Assignee Samir [ samir ] Priya Dhamande [ priya.dhamande ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Status In QA Testing [ 11901 ] In QA Testing [ 11901 ]
          Raj.Hawaldar Raj Hawaldar (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Samir [ samir ]
          shashikant.mishra ShashiKant Mishra (Inactive) made changes -
          Sprint DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6 [ 161, 162, 163, 164, 165 ] DMS - Fall Sprint 2, DMS - Fall Sprint 3, DMS - Fall Sprint 4, DMS - Fall Sprint 5, DMS - Fall Sprint 6, DMS - Fall Sprint 7 [ 161, 162, 163, 164, 165, 166 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Samir [ samir ] Priya Dhamande [ priya.dhamande ]
          Hide
          Permalink
          priya.dhamande Priya Dhamande (Inactive) added a comment -

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

          Samir Sachin Hingole Hrishikesh Deshpande Rohan J Khandave

          Show
          priya.dhamande Priya Dhamande (Inactive) added a comment - No action required from QA end. So, marking this jira done. Samir Sachin Hingole Hrishikesh Deshpande Rohan J Khandave
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Resolution Done [ 10000 ]
          Status In QA Testing [ 11901 ] Done [ 10001 ]
          priya.dhamande Priya Dhamande (Inactive) made changes -
          Assignee Priya Dhamande [ priya.dhamande ] Sonali Farakate [ sonali.farakate ]
          Transition Time In Source Status Execution Times
          Priya Dhamande (Inactive) made transition -
          In QA Testing On hold in Test
          		56m 12s 1
          Samir made transition -
          On hold in Test In Progress
          		21d 45m 1
          Samir made transition -
          In Progress To Do
          		10s 1
          Sonali Farakate (Inactive) made transition -
          To Do In Progress
          		13d 16h 40m 2
          Sonali Farakate (Inactive) made transition -
          In Progress In Progress
          		4d 6h 4m 1
          Sonali Farakate (Inactive) made transition -
          In Progress Code Review
          		3d 6h 11m 2
          Samir made transition -
          Code Review In QA Testing
          		21d 14h 8m 2
          Raj Hawaldar (Inactive) made transition -
          In QA Testing In QA Testing
          		5h 15m 1
          Priya Dhamande (Inactive) made transition -
          In QA Testing Done
          		19d 20h 36m 1

            People

            Assignee:
            sonali.farakate Sonali Farakate (Inactive)
            Reporter:
            samir Samir
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved:

                Time Tracking

                Estimated:
                Original Estimate - 32h Original Estimate - 32h
                32h
                Remaining:
                Remaining Estimate - 0h
                0h
                Logged:
                Time Spent - 52h
                52h