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

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

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

Hi Swapnil Pandhare,

Please attach the sql query to fetch this data

Regards,

Samir

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

Keeping this jira on Hold

Sachin Hingole Hrishikesh Deshpande Samir Satya

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

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

Samir Sachin Hingole Hrishikesh Deshpande Rohan J Khandave