Inflectra Customer Forums: custom report to display all user ids (Thread) need help to create custom report to display all user ids, status of user ids(active/inactive), last time they login to the system and days they are not using their user ids. en-US(C) Copyright 2006-2026 Inflectra Corporation.support@inflectra.com/Computers/Software/Project_Management//Computers/Software/Quality_Assurance/KronoDesksupport@inflectra.comhttp://www.inflectra.com/kronodesk/forums/threads120/Support/Forum/spirateam/reports/3015.aspxthreadId=3015Mac Clarus (markclarus@gmail.com)custom report to display all user ids need help to create custom report to display all user ids, status of user ids(active/inactive), last time they login to the system and days they are not using their user ids. Mon, 03 Feb 2025 09:42:38 -05002025-05-06T08:16:04-04:00/Support/Forum/spirateam/reports/3015.aspxmessageId=7099Sam I (sriram@inflectra.com) Hello, Thanks for asking about this request. Please check out KB article that will help you with Hello, Thanks for asking about this request. Please check out KB article that will help you with this request. Hope this report delights you! Thanks Sam Mon, 03 Feb 2025 21:06:10 -05002025-02-03T21:06:10-05:00/Support/Forum/spirateam/reports/3015.aspx#reply7099messageId=7100Mac Clarus (markclarus@gmail.com) this helps, thank you Sam this helps, thank you Sam Tue, 04 Feb 2025 00:29:15 -05002025-02-04T00:29:15-05:00/Support/Forum/spirateam/reports/3015.aspx#reply7100messageId=7103Mac Clarus (markclarus@gmail.com) Hi Sam, upon using this query for a couple of days, i noticed seeing negative values on the Day Hi Sam, upon using this query for a couple of days, i noticed seeing negative values on the Days_Unused column, may i know how can i prevent this? i think those users who are currently logged in when the report is generated triggers negative value. Thu, 06 Feb 2025 01:58:54 -05002025-02-06T01:58:54-05:00/Support/Forum/spirateam/reports/3015.aspx#reply7103messageId=7222Victoria D (nino.diasamidze@inflectra.com) Hello, I think that the value for Days_Unused column for currently active users should be 0 (zero) Hello, I think that the value for Days_Unused column for currently active users should be 0 (zero) and cannot get negative.. If the issue still there, please contact support directly in a dedicated ticket and provide some additional details like screenshots, etc. Regards, Victoria - Tue, 06 May 2025 08:16:04 -04002025-05-06T08:16:04-04:00/Support/Forum/spirateam/reports/3015.aspx#reply7222