SpiraTeam - login history

Tuesday, May 15, 2018
Avatar

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

 

3 Replies
Tuesday, May 15, 2018
Avatar
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 *)

Regards,

Elise

Wednesday, May 16, 2018
Avatar
re: inflectra.elise 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
Avatar
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.

Regards,

Elise

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