SpiraTeam - login history

Tuesday, May 15, 2018


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?



3 Replies
Tuesday, May 15, 2018
re: tomasz.owsiany Tuesday, May 15, 2018

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 (it's the equivalent of SELECT *)



Wednesday, May 16, 2018
re: inflectra.kat Tuesday, May 15, 2018

I used this query and preview result is ok

but when i create new report to MS-EXCEL this problem appears:

Thursday, May 17, 2018
re: tomasz.owsiany Wednesday, May 16, 2018

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.



Spira Helps You Deliver Quality Software, Faster and With Lower Risk

And if you have any questions, please email or call us at +1 (202) 558-6885


  • Started: Tuesday, May 15, 2018
  • Last Reply: Thursday, May 17, 2018
  • Replies: 3
  • Views: 4449