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
          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
          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
          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
          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
          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
          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
          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

            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