Hello, I need to create list of users with information when they were logged in for the last time. Could you please tell me where i can find this option? Tomasz 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/issues-questions/1852.aspxthreadId=1852Tomasz Owsiany (tomasz.owsiany-external@edf.pl)login history Hello, I need to create list of users with information when they were logged in for the last time. Could you please tell me where i can find this option? Tomasz Tue, 15 May 2018 07:18:32 -04002018-05-17T15:05:31-04:00/Support/Forum/spirateam/issues-questions/1852.aspxmessageId=3281Kat A (elise.brooks@inflectra.com) Hi Tomasz, Please see this KB article: Creating a Report of All Users in the System https://www.inflectra.com/Support/KnowledgeBase/KB103.aspx If you do select value R from SpiraTestEntities.R_Users as R where R.IS_ACTIVE = True It will return back all the available columns (its the equivalent of SELECT *) Regards, Elise Tue, 15 May 2018 14:01:11 -04002018-05-15T14:01:11-04:00/Support/Forum/spirateam/issues-questions/1852.aspx#reply3281messageId=3286Tomasz Owsiany (tomasz.owsiany-external@edf.pl) I used this query and preview result is ok but when i create new report to MS-EXCEL this problem appears: Wed, 16 May 2018 08:49:08 -04002018-05-16T08:49:08-04:00/Support/Forum/spirateam/issues-questions/1852.aspx#reply3286messageId=3288Kat A (elise.brooks@inflectra.com) Hi Tomasz, Usually that error means that the XSLT template is blank in your custom section. See the Template field below the Query field? Something needs to be in there. The easiest way to populate it is to click on +Create Default Template button. Regards, Elise Thu, 17 May 2018 15:05:31 -04002018-05-17T15:05:31-04:00/Support/Forum/spirateam/issues-questions/1852.aspx#reply3288